Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server 2000, MS DTC and VB6

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-19 : 11:16:49
Michael writes "Hi -

MSDN says that to begin a SQL Server 2000 distributed transaction in Visual Basic 6.0 .....


"you must use the following API to enlist an MS DTC transaction:
HResult iRepositoryTransaction2::JoinTransaction([in]VARIANT sVArTxn);

where sVArTxn is an IUnknown pointer to the distributed transaction coordinator"


Can anyone actually tell me what this means? I've no C experience, MSDN/BOL don't go any further.

If I use ADO transactions I receive an error as soon as I try to insert data into the remote table - functionality is not supported, so I need to understand how this JoinTransaction functionality works.

Thanks."

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-03-19 : 11:49:51
double post ...

setBasedIsTheTruepath
<O>
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-19 : 11:56:55
Why yes it is :)

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -