Error: ''Data source name not found'' when creating a ODBC socket datasource with ColdFusion 8 64 bit on Windows 64 bit

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:
  1. Windows\system32\odbcad32.exe
  2. Windows\SYSWOW64\odbcad32.exe

Get help faster and easier

New user?