Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Connecting to Oracle 8 database using OLEDB

Author  Topic 

stapsey
Starting Member

3 Posts

Posted - 2008-03-18 : 22:25:52
Help, I'm attempting to connect to an Oracle 8 database using the microsoft OLD DB for oracle driver.

It works fine connecting to a 9i database but when I attempt to connect to the 8 database I get ORA-12537 TNS Connection Closed.

I can connect to the database fine using sqlplus on the machine.

Any ideas would be appreciated.

Thanks



Stapsey

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-03-18 : 22:30:34
try using the oracle provided ole db driver instead. the microsoft driver is crap.


-ec
Go to Top of Page
   

- Advertisement -