Cannot Query Oracle Linked Table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Working with Oracle » Cannot Query Oracle Linked Table

Cannot Query Oracle Linked Table

Rate Topic

Display Mode

Topic Options

Author

Message

scott.bond

Posted Tuesday, September 11, 2012 8:13 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 30, 2012 9:33 AM
Points: 1, Visits: 6

SQL Server 2005 on Windows 7 box. I have the Oracle 11g client installed. I also have an ODBC connection to the Oracle DB and that works fine - used it in Access with no issue. Also can see linked Oracle tables in my SQL Server.

I have tried my query with several types of linked tables including MSDASQL - the error I get from this query is (where X is my linked server name):

SELECT * FROM OPENQUERY(X, 'SELECT * FROM TABLE')

OLE DB provider "MSDASQL" for linked server "X" returned message "[Microsoft][ODBC Driver Manager] Invalid connection string attribute".
OLE DB provider "MSDASQL" for linked server "X" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 3
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "X".

I have tried selecting and deselecting "Allow in process" and every other solution I can find.

PLEASE HELP - I AM BANGING MY HEAD ON THE DESK!

Post #1357764

anissw

Posted Sunday, March 24, 2013 7:57 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 25, 2013 6:02 AM
Points: 1, Visits: 4

Hi Scott- Have you tried MSDAORA for Oracle?

Post #1434726

« Prev Topic | Next Topic »

Permissions