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
Using Correct ODBC driver to connect to Oracle 10g db
Moderators: chulett, rschirm, roy
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?
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers