Now the problem is I need to browse the data from SQL server, but when I use the above TSQL I get the following error message. SELECT a.* from OPENROWSET('MSDASQL', 'DSN=TestDSN', 'select * from mylibrary.mytable') as a I have already setup the DSN connection(TestDSN) which is working just fine and I am able to connect and look at the data by creating linked-table in MS Access.
I am using the following code to retrieve data from an AS400 datasource.
View 1 Replies View Related Openrowset Using ODBC DSN Is Not Working! Mar 14, 2008 Syntax Of OpenRowset With UDL? Oct 25, 2007ĭoes anyone know or have a sample of a syntax of OpenRowset using a UDL file? Converting Rrom Access Syntax To Sql Syntax.Which Is Faster? Conditional Within JOIN Syntax Or WHERE Syntax?.Incorrect Syntax When There Appears To Be No Syntax Errors.MS OLE DB For ODBC With Oracle ODBC Source Headaches.Incorrect Syntax Near The Keyword CONVERT When The Syntax Is Correct - Why?.Can't Find SQL Native Client In ODBC Connection Manager In SQL Server Open Database Connectivity (ODBC).How Can I Use Create Or Alter Statements With ODBC And Microsoft Access ODBC Driver (*mdb)?.Integration Services :: Unable To See 64bit ODBC Driver From SSIS Odbc Connection?.Passing A Variable To A Linked Query (OPENROWSET For Excel Syntax).What Syntax Should I Use To Connect To Access DB (having System Database) Via OPENROWSET?.