Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002

    Unanswered: Viewing LIVE transactions from AS400 in SQL-Server 2000

    I need to live update my SQL-Server 2000 database from AS400 database.
    I usually use Access 2002 database between the AS400 database and the SQL-Server 2000 database to reflect any live update.
    I use the (Link Tables...) option when creating a new table in access and link it with the ODBC to connect with the AS400 database.
    After that I work with the Access link table.

    Is there any tool in SQL-Server 2000 to show the live transactions in AS400 databasee so I can work on it?

    Please advise
    Khalid Yousef

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I don't clearly understand your request, but my first thought is sp_addlinkedserver.


Posting Permissions

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