“Data source name not found and no default driver specified” with Access ODBC

by

Is there some modification that can be done to make it work without installing 32 bit python and 32 bit pyodbc?

Not really. If you have 32-bit Office installed then you have the 32-bit version of the Access Database Engine (a.k.a. “ACE”), and only 32-bit applications can use it.

The installer for the 64-bit version of the Access Database Engine will abort if it detects 32-bit Office components. There is a way to force the installer to continue, but that is not recommended because it can apparently break Office.

Bottom Line: The “bitness” of your application must match the “bitness” of the installed Access Database Engine. So, practically speaking, your options are

  1. Use 32-bit Python and pyodbc, or
  2. replace your 32-bit Office with the 64-bit version.

More Related Contents:

  1. Working with an Access database in Python on non-Windows platform (Linux or Mac)
  2. How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access
  3. how to catch specific pyodbc error message
  4. How to speed up bulk insert to MS SQL Server using pyodbc
  5. Speeding up pandas.DataFrame.to_sql with fast_executemany of pyODBC
  6. “General error Unable to open registry key Temporary (volatile) …” from Access ODBC
  7. python pip specify a library directory and an include directory
  8. What do I need to read Microsoft Access databases using Python?
  9. Error 28000: Login failed for user DOMAIN\\user with pyodbc
  10. Can’t open lib ‘ODBC Driver 13 for SQL Server’? Sym linking issue?
  11. Output pyodbc cursor results as python dictionary
  12. PYODBC–Data source name not found and no default driver specified
  13. pyodbc – How to perform a select statement using a variable for a parameter
  14. Get data from pandas into a SQL server with PYODBC
  15. Unable to install pyodbc on Linux
  16. Writing a csv file into SQL Server database using python
  17. MSSQL2008 – Pyodbc – Previous SQL was not a query
  18. Using SQL Server stored procedures from Python (pyodbc)
  19. Pyodbc – “Data source name not found, and no default driver specified”
  20. pyodbc insert into sql
  21. to_sql pyodbc count field incorrect or syntax error
  22. how to deal with .mdb access files with python
  23. Pyodbc error Data source name not found and no default driver specified paradox
  24. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  25. pyodbc the sql contains 0 parameter markers but 1 parameters were supplied’ ‘hy000’
  26. In Python, Using pyodbc, How Do You Perform Transactions?
  27. Remote connection to MS SQL – Error using pyodbc vs success using SQL Server Management Studio
  28. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  29. sql.h not found when installing PyODBC on Heroku
  30. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()

Leave a Comment