Update two databases

Results 1 to 2 of 2

Thread: Update two databases

  1. #1
    Join Date
    Dec 1969

    Default Update two databases

    Here is what I need to do: User insert record into one database, then, the auto-generated ID number will be retrieved and used to update another database. The problems is how to implement the data integrity. For example, If these two SQL query both executed successfully, the whole transcation is completed, if not (like during the interim, one database is damaged at the execution time, or the server is down), the transcation should fail and roll back totally. Is there a way to implement this in ASP or what? Please help.

  2. #2
    Join Date
    Dec 1969

    Default RE: Update two databases

    go through the methods of connection objects and also MTS(microsoft transaction server)

Posting Permissions

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