krush870
asked on
ERROR linked server MSDORA ORA-12154, ODBC works
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oracle client vs 10.2.0