ODBC Connectivity
Posted: Thu Jun 09, 2005 5:34 am
Hi,
DataStage is installed on a Linux Server. Oracle is in another Unix Box. Oracle 9i Client is installed in that Linux server.
From a local machine that connects to this server, I am designing a simple job using ODBC stage.
For this I followed the steps in order
1) Created a systen DSN in the local machine using start->settings-> Control panel->Administrative tools->Data Sources(ODBC). I am using DataDirect 4.10 Oracle.. Lets say it was cats_odbc..Should I be using Microsoft ODBC for Oracle instead???
2) I connect to the DS Designer and try to add an ODBC stage in a job.. while editing the stage properties, it is asking for Data source Name--> I am not able to see the system DSN Name( viz. cats_odbc) that I added earlier from step 1. Also, I dont have a userid and password for this.
3) When I hardcode the Data source Name( viz. cats_odbc) and then run the job, I get the following error
COE_LALS_DEPT..ODBC_20: DSD.BCIConnect connecting to <cats_odbc>, call to SQLConnect failed.
SQLSTATE=IM002, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified.
4) I got suggestions that I shd add this Data source name in uvodbc.config....I did that. Still not working.
All help on this issue is appreciated. Let me know if more info is required.
P.S. I am posting this mail after not being able to find a similar query/answer in all topics related to ODBC.
Thanks,
Lali
DataStage is installed on a Linux Server. Oracle is in another Unix Box. Oracle 9i Client is installed in that Linux server.
From a local machine that connects to this server, I am designing a simple job using ODBC stage.
For this I followed the steps in order
1) Created a systen DSN in the local machine using start->settings-> Control panel->Administrative tools->Data Sources(ODBC). I am using DataDirect 4.10 Oracle.. Lets say it was cats_odbc..Should I be using Microsoft ODBC for Oracle instead???
2) I connect to the DS Designer and try to add an ODBC stage in a job.. while editing the stage properties, it is asking for Data source Name--> I am not able to see the system DSN Name( viz. cats_odbc) that I added earlier from step 1. Also, I dont have a userid and password for this.
3) When I hardcode the Data source Name( viz. cats_odbc) and then run the job, I get the following error
COE_LALS_DEPT..ODBC_20: DSD.BCIConnect connecting to <cats_odbc>, call to SQLConnect failed.
SQLSTATE=IM002, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified.
4) I got suggestions that I shd add this Data source name in uvodbc.config....I did that. Still not working.
All help on this issue is appreciated. Let me know if more info is required.
P.S. I am posting this mail after not being able to find a similar query/answer in all topics related to ODBC.
Thanks,
Lali