Can I use two diff port nos connect to different Oracle SIDs
Posted: Mon Dec 15, 2003 10:24 am
We have 2 projects running on the same datastage box version 5.2. Both connect to different Oracle_SID's on diferent Oracle hosts. Connecting through ORAOCI is not a problem for both the projects to their respective SID's.
One project uses default port number as 1521
Other uses Default Port Number as 1530.
Now I want to connect through ODBC for both the SID's.
Have edited odbc.ini file for both the port numbers and also the corresponding uvodbc.config file. It shows the available connect strings in the drop down after that, but throws error once clicked on that to import something. the error is:
Client[ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified
I do not have any clue for rectifying it. As it is necessary to do so, any help is appreciated.
Regards
Alok
One project uses default port number as 1521
Other uses Default Port Number as 1530.
Now I want to connect through ODBC for both the SID's.
Have edited odbc.ini file for both the port numbers and also the corresponding uvodbc.config file. It shows the available connect strings in the drop down after that, but throws error once clicked on that to import something. the error is:
Client[ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified
I do not have any clue for rectifying it. As it is necessary to do so, any help is appreciated.
Regards
![Sad :(](./images/smilies/icon_sad.gif)
Alok