Results 1 to 2 of 2

Thread: Creating a Linked Server to AS400.

  1. #1
    GMK Guest

    Creating a Linked Server to AS400.

    I wanted to know whether it is possible to query a database in AS400 server from MS SQL Server 7.0 using linked server. If it is possible, could you show some pointers as to how it can/should be implemented.
    Thanks in Advance.
    Manojkumar
    DMT Team
    DaimlerChrysler Capital Services
    Phone - 203-845-7326
    EMail - manoj.kumar@dcxcapital.com

  2. #2
    Jason Guest

    Creating a Linked Server to AS400. (reply)

    Yes, you can link to an As400 server using an odbc connection. First you must get a trusted third party odbc component. I suggest looking at the following site www.merant.com they have some of the best odbc engines. You can use the following code as a sample on how to run queries against an attached server:
    This query is used against an index server that I have linked to in SQL 2000.
    --- sp_addlinkedserver testIndex,'Index','MSIDXS','te stBHG'
    SELECT *

    FROM OPENQUERY(testIndex,

    'SELECT Directory,

    FileName,

    DocAuthor,

    Size,

    Create,

    Write

    FROM SCOPE('' "c:hg" '&#39

    WHERE
    freetext(''meeting or xsystem and ebiz'&#39


    &#39
    order by docauthor,FILENAME



    ------------
    GMK at 3/15/01 9:50:24 AM

    I wanted to know whether it is possible to query a database in AS400 server from MS SQL Server 7.0 using linked server. If it is possible, could you show some pointers as to how it can/should be implemented.
    Thanks in Advance.
    Manojkumar
    DMT Team
    DaimlerChrysler Capital Services
    Phone - 203-845-7326
    EMail - manoj.kumar@dcxcapital.com

Posting Permissions

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