Pyodbc error Data source name not found and no default driver specified paradox

by

Two thoughts on what to check:

1) Your connection string is wrong. There’s a way to get a known good connection string directly from the ODBC Administrator program (taken from http://www.visokio.com/kb/db/dsn-less-odbc). These instructions assume you’re using an MDB, but the same process will work for a paradox file

  • On a typical client PC, open Control Panel -> Administrative Tools -> Data Sources.
  • Select the File DSN tab and click Add.
  • Select the appropriate driver (e.g. “Microsoft Access Driver (*.mdb)”) and click Next
  • Click Browse and choose where you want to save the .dsn file (this is a temporary file you are going to delete later).
  • Click Next then Finish.
  • You will be shown the vendor-specific ODBC setup dialog. For example, with Microsoft Access, you might only need to click Select and browse to an existing .mdb file before clicking OK.
  • Browse to the location of the .dsn file and open using Notepad.

In the DSN file you might see something similar to:

[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir=C:\
DBQ=C:\db1.mdb

To convert the above to the full connection strring:

  1. Omit the first [ODBC] line
  2. Put curly braces around all values containing spaces
  3. Put all name=value pairs on one line, separated by semicolons.

This gives you the full connection string. In this example, the string becomes:

DRIVER={Microsoft Access Driver (*.mdb)};UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;PageTimeout=5;axScanRows=8;MaxBufferSize=2048;FIL={MS Access};DriverId=25;DefaultDir=C:\;DBQ=C:\db1.mdb

2) 32/64 bit mismatch. I’ve had troubles when mixing 32-bit python with 64-bit drivers, or vice-versa. You may want to check your Python interpreter and database driver line up.

More Related Contents:

  1. Adding Python to PATH on Windows
  2. How do I install PyCrypto on Windows?
  3. Check if a process is running or not on Windows?
  4. Installing Numpy on 64bit Windows 7 with Python 2.7.3 [closed]
  5. Why does Python’s multiprocessing module import __main__ when starting a new process on Windows?
  6. ImportError: cannot import name NUMPY_MKL
  7. Running powershell script within python script, how to make python print the powershell output while it is running
  8. Python Pip install Error: Unable to find vcvarsall.bat. Tried all solutions [duplicate]
  9. portable way to write csv file in python 2 or python 3
  10. How do I run Python script using arguments in windows command line
  11. MSSQL2008 – Pyodbc – Previous SQL was not a query
  12. How to configure Python Kivy for PyCharm on Windows?
  13. How to run different python versions in cmd [duplicate]
  14. Running Cython in Windows x64 – fatal error C1083: Cannot open include file: ‘basetsd.h’: No such file or directory
  15. ‘^’ is ignored by Python – how to escape ‘^’ character in Popen Windows?
  16. Pyodbc – “Data source name not found, and no default driver specified”
  17. Timeout a function (windows)?
  18. Running Scapy on Windows with Python 2.7
  19. Pathname too long to open?
  20. Creating multiple python dictionaries from a file
  21. What is the result of % in Python?
  22. How to use __setattr__ correctly, avoiding infinite recursion
  23. pyclipper installation error: “tp_print is not a member of _typeobject”
  24. How to get selectors with dynamic part inside using Selenium with Python?
  25. ValueError: malformed string when using ast.literal_eval
  26. How to stop Python closing immediately when executed in Microsoft Windows
  27. What does “table” in the string.translate function mean?
  28. How to create a new text file using Python
  29. PythonMagick can’t find my pdf files
  30. ‘is’ operator behaves unexpectedly with floats

Leave a Comment