Need help with 2 Connections

[acextrem]

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??

 

[BobRodes]

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

 

[harebrain]

And, before any potential hair-pulling occurs, this requires the Enterprise Version.

 

[BobRodes]

Oo, good point, harebrain.