Hi
I am trying to use Oracle 1og database with datastage 7. I am having difficulties in retrieving date using odbc or native oracle drivers. Any suggestions? (I only have 8i,9i,OCI drivers installed)
10g problem
Moderators: chulett, rschirm, roy
I doubt it.
Don't remember that even being mentioned as part of 7.5.
Have you tried pointing DataStage's $ORACLE_HOME environment variable to a 9i client and then using the 9i client via an OCI9 stage to access the 10g database? Does that work?
It's an old trick I've used before when 9i was brand new. We used an 8i client and an OCI8 stage to talk to our 9i databases for awhile.
![Wink :wink:](./images/smilies/icon_wink.gif)
Have you tried pointing DataStage's $ORACLE_HOME environment variable to a 9i client and then using the 9i client via an OCI9 stage to access the 10g database? Does that work?
It's an old trick I've used before when 9i was brand new. We used an 8i client and an OCI8 stage to talk to our 9i databases for awhile.
Last edited by chulett on Wed Jul 14, 2004 4:24 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Info needed
chulett wrote:I doubt it.Don't remember that even being mentioned as part of 7.5.
Have you tried pointing DataStage's $ORACLE_HOME environment variable to a 9i client and then using the 9i client via an OCI9 stage to access the 10g database? Does that work?
It's an old trick I've used before when 9i was brand new. We used an 8i client and an OCI8 stage to talk to our 9i databases for awhile.
Can you please inform in detail about how to do that.