Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    now in UAE, i am an INDIAN.
    Posts
    16

    Unanswered: Connect to AS400 table

    Hi,
    Is there anyway to connect to AS400 table (something like link table feature in MS Access). OR. I have to use the DTS package and schedule it to update in intervals, this i am not preferring due to the performance issue ?

    your help highly appreciate

    thanks
    Murali.
    Last edited by ipmurali; 11-06-07 at 04:01.
    TEAM (Together Everybody Achieve More)

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    As long as you have ODBC drivers that will allow a Windows application to access the AS400 table, you can use sp_addlinkedserver to allow SQL Server to access it too.

    -PatP

Posting Permissions

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