var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DataAccess/Updates in multi databases
I have 2 databases siting on the same DB server.
I need to update both in a transaction or nothing at all.
How can I put 2 ado connections in a single transaction?
Anyone has any ideas at all?
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
The database is MSSQL.
The problem is each connection to the database in VB maintains its' own transaction (begin and commit trans).
You need to use the Distributed Transcation Coordinator (DTC).
Search on BOL for "DTC" - never needed to use this yet myself...
Figured I needed that but thought I can get away without using DTC.