Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help with 2 Connections

Status
Not open for further replies.

acextrem

Programmer
Nov 29, 2007
5
RO
I'm trying to make an aplication that use 2 different connections in VB6. So, I open a Transaction for each connections and then I load and modify data from recordsets!
After that, I want to Commit in the same time the 2 connections.
I read that is not possible without MTS. But I don't know how to use it. Can somebody help me please??
 
That's exactly what MTS is designed for, making an atomic transaction involving more than one connection. You'll need to investigate the following:

CreateInstance
SetCommit
SetAbort
ContextObject
TransactionMode property

Once you've done this preliminary reading, get back and post more questions as you have them. Keep in mind that this is not a trivial endeavor; two days of a five day class I used to teach, which also assumed a high level of knowledge going in, were devoted to building well-behaved MTS objects.

HTH

Bob
 
And, before any potential hair-pulling occurs, this requires the Enterprise Version.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top