Troubleshoot ODBC Data Connections

Overview

If your ODBC connections show any of the following symptoms, refer to the following resolutions.

SQL Server ODBC Driver Error in Windows

If you have an ODBC DSN that uses the Windows SQL Server driver, replace that DSN with one that uses the DataFlux 32 or 64-bit SQL Server Wire Protocol driver. Using the Windows SQL Server driver can cause problems with your repository.
Note: Use the 32 or 64-bit driver depending on the operating environment of the DataFlux Data Management Server. Access the drivers by selecting Control Panelthen selectODBC Data Sources. The DataFlux drivers are listed in the Drivers tab.

Teradata and Informix ODBC Drivers Fail to Load

In the Solaris x86 operating environment, DataDirect does not currently provide Teradata or Informix drivers.
In Linux operating environments, the directory that contains the Teradata client libraries needs to be in your LD_LIBRARY PATH. The exact path will vary depending on the version of your Teradata client.
Last updated: June 16, 2017