Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Denver, Colorado

    Post Unanswered: Setting up linked server to IBM AS400

    I am trying to set up a linked server in MSSQL to an IBM AS400 using the IBM AS400 OLE DB Provider. The New Linked Server dialog box asks for properties Product Name and Data Source. I would like to know from someone who has successfully set up a linked server to an AS400 what the specific syntax in the properties needs to be. I have reviewed the OLB section on sp_addlinkedserver, and while this is helpful and gives many specific examples, I need an example for an AS400. Thank you to anyone who can help!

  2. #2
    Join Date
    Aug 2002
    Follow references in books online and this KBA;EN-US;218590, also search under this forum for other information.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts