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?
SQL DSN Not working
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 136
- Joined: Wed May 07, 2008 11:26 am
- Location: Sydney, Australia
- Contact:
SQL DSN Not working
Vinay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: