How to connect SQL Server 2005 with both ORACLE 8 and 10g databases

No replies
thinker
thinker's picture
User is online Online
Joined: 06/02/2008
Printer-friendly versionPrinter-friendly versionSend to friendSend to friendPDF versionPDF version

I was honestly trying to stop using ODBC for its tremendously slow performance.

It was a real pain to begin with. I had Oracle 8 client on my PC but I could not connect to ORACLE 10g database we have. I also tried using 10g client but again I could not communicate with ORACLE 8 database. I found out ORACLE 10g client does not talk to ORACLE 8 database and ORACLE 8 client does not talk to 10g database. Finally, I was successful with 9i client to be able to connect to both ORACLE 8 and 10g databases.

Are we being helpful? If so, please link to us here.