updating a remote database

Results 1 to 2 of 2

Thread: updating a remote database

  1. #1
    Join Date
    Dec 1969

    Default updating a remote database

    I want to perform a transaction on one server, then update a database on a different server with the results.<BR><BR>I want this update to be transparent to the user and keep the user on the original site.<BR><BR>Any Ideas, the simpler the better, I have been told that I cannot use a simple form as this will send the user to the remote server

  2. #2
    Join Date
    Dec 1969

    Default RE: updating a remote database

    Internet with Access:<BR>====================<BR>You could use XMLHTTP on the local server ASP to perform the DB change via an ASP page on the remote server.<BR><BR>Intranet with SQL:<BR>====================<BR>if it&#039;s SQL Server 2K you can just link the servers up and use TRIGGERS to automatically update the remote server transparently behind the scenes.

Posting Permissions

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