[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

by

  1. In reference to the error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

    That error means that the Data Source Name (DSN) you are specifying in your connection configuration is not being found in the windows registry.

    • It is important that your ODBC driver’s executable and linking format (ELF) is the same as your application. In other words, you need a 32-bit driver for a 32-bit application or a 64-bit driver for a 64-bit application.

      If these do not match, it is possible to configure a DSN for a 32-bit driver and when you attempt to use that DSN in a 64-bit application, the DSN won’t be found because the registry holds DSN information in different places depending on ELF (32-bit versus 64-bit).

      Be sure you are using the correct ODBC Administrator tool. On 32-bit and 64-bit Windows, the default ODBC Administrator tool is in c:\Windows\System32\odbcad32.exe. However, on a 64-bit Windows machine, the default is the 64-bit version. If you need to use the 32-bit ODBC Administrator tool on a 64-bit Windows system, you will need to run the one found here: C:\Windows\SysWOW64\odbcad32.exe

      Where I see this tripping people up is when a user uses the default 64-bit ODBC Administrator to configure a DSN; thinking it is for a 32-bit DSN. Then when the 32-bit application attempts to connect using that DSN, “Data source not found…” occurs.

    • It’s also important to make sure the spelling of the DSN matches that of the configured DSN in the ODBC Administrator. One letter wrong is all it takes for a DSN to be mismatched.

      Here is an article that may provide some additional details

      It may not be the same product brand that you have, however; it is a generic problem that is encountered when using ODBC data source names.

  2. In reference to the OLE DB Provider portion of your question, it appears to be a similar type of problem where the application is not able to locate the configuration for the specified provider.

More Related Contents:

  1. what is the difference between OLE DB and ODBC data sources?
  2. Can’t install distlearn through a firewall
  3. What is the purpose of administrative installation initiated using msiexec /a?
  4. Install apps silently, with granted INSTALL_PACKAGES permission
  5. Cannot install R-forge package using install.packages
  6. Installing SciPy with pip
  7. What is INSTALL_PARSE_FAILED_NO_CERTIFICATES error?
  8. How can I find the Upgrade Code for an installed MSI file?
  9. How to set Python’s default version to 3.x on OS X? [duplicate]
  10. WIX Installer with modern look and feel
  11. How to install Poppler on Windows?
  12. How to setup mail in XAMPP locally?
  13. ADB Install Fails With INSTALL_FAILED_TEST_ONLY
  14. Application Installation Failed in Android Studio
  15. Visual Studio 2015 installer hangs during install?
  16. How to install and start a Windows Service using WiX
  17. Error in setting JAVA_HOME
  18. PHP and Microsoft Access database – Connection and CRUD
  19. Excel: Use a cell value as a parameter for a SQL query
  20. Install Visual Studio 2013 on Windows 7
  21. How do I install Python libraries in wheel format?
  22. Installation of VB6 on Windows 7 / 8 / 10 [duplicate]
  23. Installing Homebrew on macOS
  24. Check if a SQL table exists
  25. Installing lapack for numpy
  26. Difference between Groovy Binary and Source release?
  27. Visual studio 2017 installer won’t run after extracting
  28. Simplest solution to replace a tiny file inside an MSI?
  29. MySQL data directory location
  30. Enterprise app deployment doesn’t install on iOS 8.1.3

Leave a Comment