MS SQL Connection Information

ODBC Connection Issues Using 64-Bit Windows

Contents

Problem

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.

Symptoms

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.
  • 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.

Solution

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:

%SystemRoot%\SysWow64\odbcad32.exe

On a default install, this tool is located in the following directory:

C:\WINDOWS\SysWOW64\odbcad32.exe

  • 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.
Continue: Tuning Tips