Windows\system32\odbcad32.exe
Last updated on
Apr 27, 2021
Issue
In certain instances, Adobe ColdFusion cannot properly detect and use ODBC data sources on 64 bit systems.
When you create system DSN connection with ODBC manager in Windows (Windows\system32\odbcad32.exe) with the executable below and add it in the ColdFusion administrator under datasources as a ODBC socket the following errors occurs:
\ Connection verification failed for data source: test java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified
Solution
Add an identical data source to the 32 and 64 bit ODBC settings
Create the system DSN with the samenamewith both of the following executables:
-
-
Windows\SYSWOW64\odbcad32.exe