DSXchange

Posted: **Mon Dec 01, 2008 3:19 am**

hi Friends,

We have shifted our datastage jobs to a different server where a new project is created. i have created all the SQl DSNs that were present in the old server in the new server by editing uvodbc.config and odbc.ini files. but the jobs are failig giving the following error :

Load_Ora_Opmetrics_DEV_V1..OPMETRIC_DEV: DSD.BCIConnect connecting to SQLComplianceDB, call to SQLConnect failed.

SQLSTATE=IM998, DBMS.CODE=0

[DataStage][SQL Client]There is no configuration file, or an error was found in the file.

Where is the problem, project, uvodbc.config files or the configuration files?

Posted: **Mon Dec 01, 2008 2:04 pm**

"No configuration file" in the error message suggests that the .odbc.ini file can not be found. Is your ODBCINI environment variable set?

Posted: **Tue Dec 02, 2008 12:16 am**

hi Thanks Ray,

thats right. actually files were not changed properly. the datastage was not recognizing these files after changes had been done. now its working fine.

DSXchange

SQL DSN Not working

SQL DSN Not working

Done