Creating a link server with AS/400

• Sharri Ennis

  SSC Rookie

  Points: 34

  More actions

  September 21, 2004 at 4:11 am

  #162217

  Hey,

  I am new to sql (learning it all on my own) I was asked to research for my company;

  They want to created a linked server with AS/400 without DTS, they want to do this live. Is it possible?                                   I am sure I will be back with more questions

  Thanks,                                           Sharri

• oldgoat

  SSCrazy

  Points: 2344

  More actions

  September 21, 2004 at 7:44 am

  #523812

  Its all in the interface with these things, and as far as I know, you have to use MS Host integration server to talk to as/400 boxes. Mind you, someone might have built an ODBC for this exact purpose....

• csherwood

  SSC Eights!

  Points: 823

  More actions

  September 22, 2004 at 6:19 am

  #523955

  I have done this with the following

  IBM400 = As400 Name

  In following example as400 name and odbc data source are named the same

  EXEC sp_addlinkedserver

     @server = 'IBM400',

     @provider = 'IBMDA400',

     @datasrc = 'IBM400'

     @srvproduct='',

     @provstr = 'Driver={Client Access ODBC Driver (32-bit)};SERVER=IBM400;UID=username;PWD=password;'

  EXEC sp_addlinkedsrvlogin 'IBM400', 'false', NULL, username, Password

  select  *

  from OPENQuery(IBM400,'select * from library.table')

• Linda Johanning

  SSCertifiable

  Points: 6727

  More actions

  September 22, 2004 at 12:25 pm

  #524047

  We also have a linked server to an AS/400 using the Client Access driver and a 3rd party driver called HiT.  We're only pulling data into a SQL database and am not sure if data can be pushed or not.

  Linda