Hi..

I am working on VB.NET (windows forms) and i am using ADO.NET to deal
with databases. I have 2 databases say dbA (on Server1) and dbB (on
Server2). I am reading data from dbA and writing it on dbB. After i am
done writing, i delete information from dbA.  Is there a way i can
perform this activity as a single transaction?

Any help on this one will be much appreciated. Thank you.

Hetal.

Hi Hetal,

What you are describing is called a Distributed Transaction.  If you google
for that you will come up with lots of links and resources.  Of course it
all depends on your specific configuration/setup.  I found this article
quite quickly though.

http://www.c-sharpcorner.com/UploadFile/mosessaur/TransactionScope04142006103850AM/TransactionScope.aspx


Robin

Hi Robin,

The keyword "Distributed Transaction" did the trick for me. I found a
bunch of helpful articles online. Thanks.

Thanks Robin.

Help with delegate callback error
Strange Date Problem
there is no 64-bit Jet (MS Access) OLEDB driver.
Question about sending email via Visual Basic 2005 on a ASP.NET pa
Problem with: Use the following method to smooth edges of screen fonts: if ClearType is selected
COM problem
Publishing problem
Can someone help me with this menu?
debug mode faster than bin\exe ?
Forms