0 Replies Latest reply on Oct 19, 2009 9:24 AM by 186133

    Linked Servers Msg 7303


      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?