Informix ODBC Unable to Load Translation DLL 2

[lordhowe]

We have a SQL Server 7.0 database running on NT 4. We have loaded Informix Connect 2.7 with the Intersolve 3.80 driver.

We can run a DTS package in designer mode when trying to connect to our Informix database. But when we schedule the package, we get an error message : [Informix][Informix ODBC Driver] Unable to load translation DLL. Error Source : Microsoft OLE DB Provider for ODBC Drivers

Any ideas of what can be wrong ?

 

[tlbroadbent]

Check your path statement in AUTOEXEC.BAT. It should include \informix. It may also require \informix\bin and \informix\lib.

Another solution is to set an environment variable named INFORMIXDIR equal to the path of the Informix directory.

Example:
SET INFORMIXDIR=c:\imformix Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous

 

[lordhowe]

Thanks. We've got it working now.