TechNote

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

Search Support

---