Distributed Transaction Error !!! Part 2

[bots]

Hi everybody

I've made some tests and I've found out some clues:
Whenever I have a COM component that is "requires new transaction" or "requires transaction" and I try to open a connection to a remote database (SQL Server 7.0) inside the component, I get the error "Distributed Transaction Error". I'm asking myself: Does it make any sense, I mean, to open a connection inside a transaction?

Does someone have any idea?

 

[zallen]

The DTC must be started both on MTS machine and DBMS machine!


Maybe i donnot understand you! I want to migrate to Canada or Australia. Any relative information you supplied will be appreciated!

zallen@cmmail.com
ICQ:101229409

 

[zeevgetner]

Ill tell you what.

send me your vb code to zeevgetner@hotmail.com, and ill tell
you if there is something wrong with it.

any way there is no problem in opening a connection inside a distributer transaction. mts is responsible for the transaction.

i have another idea for you. try to work without the mts, and see if it works. maybe you have a bug that isn't related to the mts.

zeev