OPENROWSET from SQL Server to AS400

• George Lassiter

  SSC Enthusiast

  Points: 194

  More actions

  September 16, 2005 at 11:50 am

  #165325

  I am trying to duplicate an Access pass-thru query on SQL Server 2000, but I need help with the syntax.

  I am using the statement below as a template to build my view.

  SELECT a.*

  FROM OPENROWSET('MSDASQL',

  'DRIVER={SQL Server};SERVER=seattle1;UID=manager;PWD=MyPass',

  pubs.dbo.authors) AS a

  ORDER BY a.au_lname, a.au_fname

  My data source is IBMDADB2.1.

  What driver do I use and would the rest of the statement remain the same?

  Thanks

   

• Jo Pattyn

  SSC-Dedicated

  Points: 32473

  More actions

  September 19, 2005 at 1:26 pm

  #591111

  You can find a list of connectionstrings at

  http://www.connectionstrings.com/