My Oracle Support Banner

OPENROWSET Query Results in The Errors MSG 7399, MSG 7350 When Using Oracle Provider for OLE DB (Doc ID 789481.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Provider for OLE DB - Version 9.2.0.8 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 24-Feb-2013***


Symptoms

When trying to execute the following sql in Sql Server Management Studio without using a linked server:

SELECT ACCOUNT_NBR FROM OPENROWSET ( 'OraOLEDB.Oracle',
'CMIDW1.world' ; 'USER' ; 'Password', 
'SELECT ACCOUNT_NBR FROM MORTGAGE_MIS.LOAN WHERE ROWNUM < 101' ) b

Results in the following error:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "(null)" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "OraOLEDB.Oracle" for linked server "(null)".


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.