SQL DSN Not working

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vintipa
Participant
Posts: 136
Joined: Wed May 07, 2008 11:26 am
Location: Sydney, Australia
Contact:
Contact vintipa

SQL DSN Not working

Post by vintipa »

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?
Vinay
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

"No configuration file" in the error message suggests that the .odbc.ini file can not be found. Is your ODBCINI environment variable set?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
vintipa
Participant
Posts: 136
Joined: Wed May 07, 2008 11:26 am
Location: Sydney, Australia
Contact:
Contact vintipa

Done

Post by vintipa »

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.

:)
Vinay
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”