DSXchange

Posted: **Mon Apr 02, 2007 4:56 pm**

Hello friends,

We have DataStage 7.5.x installed on Linux server. All these days we were using the following driver (as defined in .odbc.ini file) to connect to Oracle 9i database
'Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMor820.so'

Recently we upgraded our database to 10g. Do we need to change the DataStage ODBC driver to connect to the new 10g db?

Thanks a lot in advance
Yamini

Posted: **Mon Apr 02, 2007 5:20 pm**

Nope, same one.

Use of this driver requires the Oracle client to be installed. The question will be, do you continue to use the 9i Client to connect to the 10g instance or switch to a 10g Client? Do you use OCI stages or just ODBC? Do you support a mixture of 9i and 10g targets?

Posted: **Mon Apr 02, 2007 5:44 pm**

Yamini,
I am using the same Driver VMora820.so for my 10g database. Just to make sure entries in .odbc.ini and tnsnames.ora files are populated correctly for your 10g DB.

Posted: **Mon Apr 02, 2007 6:15 pm**

Cool... thanks guys

DSXchange

Using Correct ODBC driver to connect to Oracle 10g db

Using Correct ODBC driver to connect to Oracle 10g db