I have some trouble with Linked Servers after upgrade of Sql Server 2005 to SP3. In my previous version the connection to the oracle database worked. Now i try to execute a simple SQL from the SQL Server Management Studio:
select * from ORATEST1...DUAL
It endups with the following message:
OLE DB provider "OraOLEDB.Oracle" for linked server "ORATEST1" returned message "".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "ORATEST1".
Anyone more than me that have this problem? Is there a solution?