Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR linked server MSDORA ORA-12154, ODBC works

711085Jul 9 2009 — edited Jul 9 2009

I am trying to link a MS SQL Server 2005 to an oracle 10g database. I have tried MSDAORA provider and get ORA-12154 "TNS:Could not resolve names" I have verifiy TNSNAMES.ora is correct and can connect ussing ORACLE ODBC.

I try using ORAOLEDB.Oracle and it gives OLE DB provider "oRAoledb.Oracle" for linked server "PACSTEST" returned message "" MSG 7303

I have found conflicting answers on web if MSDORA supports 10g
Also I would like to verify MSDAORA is pointed correctly to my ORACLE client

MDAC vs 2.8 sp1
Oracle client 10.2.0

Edited by: user11241608 on Jul 9, 2009 7:50 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 6 2009

Added on Jul 9 2009

#database-installation, #server, #sql

1 comment

2,071 views