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.