Post reply

Creating a link server with AS/400

  • 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

  • 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....

  • 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')

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply