InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 15:42:27 GMT20http://www.sqlservercentral.com/Forums/Topic1357764-1042-1.aspxHi Scott- Have you tried MSDAORA for Oracle?Sun, 24 Mar 2013 19:57:00 GMTanisswhttp://www.sqlservercentral.com/Forums/Topic1357764-1042-1.aspxSQL 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 3Cannot 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!Tue, 11 Sep 2012 20:13:49 GMTscott.bond