IBM Support

Unable to load translation.dll

Technote (troubleshooting)


When configuring ODBC, you receive a "Unable to load Translation.dll" error


You are setting up an ODBC data source on a Windows® operating system using the Data Sources (ODBC) utility. The data source uses the IBM Informix® ODBC driver. When you use the Apply and Test Connection button you receive this error in a pop-up error window:

Unable to load Translation.dll


The INFORMIXDIR environment variable is incorrectly set in the operating system, in the Setnet32 utility, or in both. In both places the variable should be set to the full path of the directory where the IBM Informix® Client SDK is installed.

Important: This is only one possible cause of the problem. If this document does not give you what you need then search for other documents with the same problem.

Resolving the problem

Set the environment variable INFORMIXDIR correctly in both the operating system and in Setnet32.

1. Shut down the Data Sources (ODBC) utility you are using to set up the ODBC data source.

2. Set the environment variable INFORMIXDIR in the operating system so that the value is the complete path to the directory in which you installed Client SDK.

    Tip: For more information about setting environment variables in the operating system see the Related Information section.

3. Set the environment variable INFORMIXDIR in Setnet32 so that the value is the complete path to the directory in which you installed Client SDK.

    a. Go to Start --> Programs --> the folder for Client SDK --> Setnet32.

    b. In the IBM Informix Setnet32 window, the Environment tab scroll down to the INFORMIXDIR variable in the Client/Server Environment scroll box. If it is not the complete path to the Client SDK installation directory, same as the system variable above, update it:

      i. Click the INFORMIXDIR variable.

      ii. In the Edit Environment Variable text box type the directory path.

      iii. Click Set.

      iv. Verify that the change took place in the list.

      v. Click Apply.

      vi. Click OK.

Related information

Setting Environment Variables

Document information

More support for: Informix Tools
Informix Client Software Development Kit (CSDK)

Software version: 1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 3.0, 4.0, 4.1, 4.2, 5.1, 6.0, 7.2, 7.3

Operating system(s): Windows

Reference #: 1144413

Modified date: 07 January 2011

Translate this page: