Data Source Name not found
When a 32-bit application connects using a data source name (DSN) on a 64-bit version of the
Windows
operating system, you may receive the following error message:Data source name not found and no default driver specified
The 64-bit version of the Microsoft
Windows
operating system uses the 64-bit version of the Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe) in the Control Panel, which displays different sets of the DSN than the 32-bit version.The operating system installs a 32-bit version and a 64-bit version of the tool in different folders. The following table identifies the locations for the two ODBC Administrator tools and the DSNs each tool displays.
ODBC Admin Tool version & location in system drive | 32-bit system DSN | 32-bit user DSN | 64-bit system DSN | 64-bit user DSN |
|---|---|---|---|---|
32-bit version located in \Windows\SysWoW64 folder | Yes | Yes | No | Yes |
64-bit version located in \Windows\System32 folder | No | Yes | Yes | Yes |
To resolve this problem use the appropriate version of the ODBC Administrator tool to create the DSN:
- For 32-bit applications, use the 32-bit version of the ODBC Administrator tool.
- For 64-bit applications, use the 64-bit version of the ODBC Administrator Tool.
- For both 32-bit and 64-bit applications, use.FactoryTalk Diagnostics> Setup > ODBC Database
Provide Feedback