Informix connection through ODBC stage - issue

cse_gopu · Post by **cse_gopu** » Thu Jul 14, 2011 7:33 am

Hi,
We are in the process of migrating the ds projects from one HP-UX server to other HP-UX server. And, there is a job which extracts data from Informix through OBDC stage and it is failing to connect to that informix server. We have made all the entries in .odbc.ini and uvodbc.config files for this connection. But, the following error is thrown.

Error message:
sourceCAHacctODBC..acct: DSD.BCIConnect connecting to escahlive, call to SQLConnect failed.
SQLSTATE=IM003, DBMS.CODE=80
[DataStage][SQL Client][ODBC]Specified driver could not be loaded

On the new server, only the informix client is installed and the server is on different machine. We are not sure about the settings that we should make for this.
Can any of you please help us here?

Thanks in advance,

Regards,
Gopu

PaulVL · Post by **PaulVL** » Thu Jul 14, 2011 6:58 pm

A) Contact your Informix DBA.
B) look at the sqlhosts file located under your Informix installation path. You will need to add an entry there to configure your connectivity to informix when using the CLI connection methods. Don't need it for ODBC.