November 23, 2005 at 9:59 am
Hello,
Recently one of our developers machine was upgraded to oracle 9i client.Now
he's trying to make a connection to Oracle from DTS packages it comes out
saying it can't find ora8.dll which is not there anywhere is there a place in
the registry or some where i can say to look at the new 9i dll instead of old
one
appreciate ur help!
November 28, 2005 at 8:00 am
This was removed by the editor as SPAM
November 28, 2005 at 3:31 pm
I do not know ... if it were me though ... I'd uninstall the 9i upgrade and reinstall 8g (and what ever patches you need) ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
November 29, 2005 at 7:22 am
Actually I think you do not need to uninstall 9i.
I believe the headache comes from not selecting the correct connection in DTS.
First make sure that the server where the DTS package is being created has the Oracle 9i client network stuff and possibly ODBC drivers.
Second, when making the connection (you may have to re-build the packages) make sure that you choose the Oracle 9i driver, you may have to use ODBC and set up a connection.
Oracle users may be able to provide you more info.
Good luck,
Brian
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply