Tuesday, September 14, 2010

Oracle Linked Server issue

Today I got the error below on the SQL Server job it runs a SSIS Package.

Msg 7302, Level 16, State 1, Server USIVA007, Line 1
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server

  Strange but recreating of the Linked Server connection, resolved the issue.

Techniques to Debug Connectivity Issues to an Oracle Server Using the ODBC Driver and OLE DB Provider

No comments: