Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot Query Oracle Linked Table Expand / Collapse
Author
Message
Posted Tuesday, September 11, 2012 8:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Sunday, March 24, 2013 7:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 23, 2013 8:17 AM
Points: 2, Visits: 8
Hi Scott- Have you tried MSDAORA for Oracle?
Post #1434726
Posted Sunday, June 15, 2014 12:39 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:38 PM
Points: 1,385, Visits: 6,175
sqlserver works best with the oracle oledb driver (OraOLEDB)
Post #1580947
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse