DataStage Error on AIX machine while using ODBC table def

datastage_user · Post by **datastage_user** » Wed Aug 23, 2006 8:08 am

Hi,

We have configured our DSNs on the DataStage server installed on AIX.

And we are able to see the DSN's in the Designer when we design a job.

But we try to run it after succesful compilation, we are getting the following error.

ds_loadlibrary error in dlopen.

Can anyone please suggest how to overcome the above error.

Thanks in advance.

Regards,
Vikram.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 23, 2006 8:55 am

This is usually a problem with your shared library search path, which should be set in the dsenv as an environment variable called LD_LIBRARY_PATH. It must be able to find the libraries in the branded_odbc/lib directory. Also, make sure that 32-bit database client libraries precede any 64-bit database client libraries.