Distributed Transaction Error !!!

[bots]

First of all, Merry Christmas Everybody and Happy New Year!

Well, I have two components installed in the MTS. The first one is "require new
transaction", the other one is "require transaction". The first component calls
the second which in turn inserts a row in a database and returns a status data.
If I use only local database, I have no problem. But when I use my local database
and a remote one in order to test the two-phase-commit procedure, I get the
error: "Distributed Transaction Error". Nothing more.
If the second component is configured as "does not support transaction", once
again, I have no problem, but the 2-phase-commit procedure does not work. (As it
was expected)
I have no idea what's happening.

My Visual Studio is SP4 and Windows NT is SP6. In the remote machine too. Both
DTC are up.

Could someone help me?

 

[zeevgetner]

I CAN GUESS THAT IT MIGHT HAVE SOMTHING TO DO, WITH
THE KIND OF DB YOU USE FOR YOUR LOCAL DB.

IF ITS ACCESS, OR SOMTHING LIKE THAT, IT MIGHT
HAVE SOME PROBLEMS, WORKING WITH THE MTS

 

[bots]

Hi zeevgetner

Both databases are SQL Server 7.0 SP2.
The problem comes up when, inside the second component, I open the connection to the DB. This 2º component is "require transaction". The version of MSDTC is 02.00.00.854
I'm still going over!


Thank you very much for your answer!

 

[BML]

Hi,

Maybe is the way you use to instanciate the second component. If you use CreateInstance, the context remains the same (you are using the same transaction), if you use CoCreateInstance the context is diferent (you use another transaction).

I never worked with two-phase-commit, but "Distributed Transaction Error" may be related to the creation of the second component.
regards,

Bruno Loureiro
<brunoloureiro@usa.net>

 

[Guest_imported]

I also have an application Using VB dll's in MTS.
The Database is on another server(MS SQL 6.5).
Everything worked fine, but since we moved the components and the web application in another folder (on the same server) the Distributed transaction error(-2147168246)
Occurs once a while(3 times in the past 3 weeks) and it makes MSDTC unavailable for all other application using it MTS Components. The only way of fixing it was to reboot the server (the one whit the Mts Dll's). It works for a while and then comes back. Even Microsoft support line hasen't found the problem yet.

If anyone can help
Please let me know!

 

[Guest_imported]

I also have an application Using VB dll's in MTS.
The Database is on another server(MS SQL 6.5).
Everything worked fine, but since we moved the components and the web application in another folder (on the same server) the Distributed transaction error(-2147168246)
Occurs once a while(3 times in the past 3 weeks) and it makes MSDTC unavailable for all other application using it MTS Components. The only way of fixing it was to reboot the server (the one whit the Mts Dll's). It works for a while and then comes back. Even Microsoft support line hasen't found the problem yet.

If anyone can help
Please let me know!
Vailla@parl.gc.ca