none
OraOLEDB.Oracle Linked Server

    Question

  • Have an Issue trying to call a SQL View which calls a Oracle Linked server via OPENQUERY.  This is all done from inside access.  The issue is that when I remove the user from the local administrator group on the SQL server.  I get the following error:

    ODBC call failed.  
    [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot create and instance of OLE DB provider "OraOLEDB.Oracle" for linked server .... (#7302)

    The issue is that I can't leave this user in the local Administrator group and I need to use Windows Authentication.  It doesn't matter if the account is a sysadmin on SQL, you still get the error unless the user is in the local windows Administrator group.

    Tuesday, February 5, 2013 9:58 PM

Answers

All replies