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