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

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy