ODBC Connection Issues Using 64-Bit Windows
When attempting to use an ODBC data source in Iguana on a 64-bit Windows machine, you may encounter the following error:
ODBC Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
This error only occurs when attempting to use a channel that uses the ODBC data source.
To reproduce this error:
- Set up Iguana on a Windows 64-bit machine. It should run normally.
- Set up an ODBC data source. To learn how using MS SQL Server as an example, see Setting Up an ODBC Data Source For MS SQL Server.
- Create a new channel that uses that data source. You should encounter the error message shown above when you try to run the channel, or view the logs.
The error message itself indicates that the data source was not found. The error occurs at this point because the data source was created using the 64-bit ODBC Administrator tool, and Iguana cannot find the sources made by that tool.
To fix this issue:
- Set up an ODBC connection using the 32-bit ODBC Administrator tool located in the following directory:
On a default install, this tool is located in the following directory:
- Create a new channel that uses the data source you created using the ODBC Administrator tool. The error message should no longer appear.
Tip: Did you know?
The 64-bit version of Windows includes two ODBC Administrator tools:
- 64-bit ODBC Administrator tool – Invoked from the Control Panel to manage user DSNs and system DSNs that are used by 64-bit processes.
- 32-bit ODBC Administrator tool – Invoked directly from the SysWoW64 folder to manage user DSNs and system DSNs that are used by WOW64 processes.