2 Replies Latest reply: Mar 15, 2013 12:47 PM by 997212 RSS

    Oracle 10g Linked server

    588273
      Hi all,

      I am trying to access an Oracle DB from SQL server. My environment:

      - Windows 2000
      - SQL 2005 Express
      - Oracle 10g & Client & Oracle Provider for OLD DB 10.2...

      I linked Oracle from within SQL Management studio. When I try to access Oracle tables I get the error "Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server......"

      I test the connection to Oracle via OraOLEDB.Oracle.1 using a UDL file and the connection is successful.

      Any ideas what is wrong ??