Our application is developed as VB components running under MTS in
Windows NT Server 4.0. One of the component is accessing SQL Server 6.5
database using ADO and ODBC driver.

Some times I am getting Distributed Transaction Error from ODBC SQL
Server Driver. But this error is not consistent. Do you have any idea
why I should be getting this error ?

Advance thanks for your help

Hari Somaskanthan

Sent via Deja.com http://www.*-*-*.com/
Before you buy.

"Distributed Transaction Error" is a little vague, but you are most
likely experiencing a contention problem with one of the tables in
the affected method call.

When you more heavily stress the objects, do you will see an increase
in both the elapsed time and frequency of the error?

Are you performing SELECT statements over a connection that is
participating in a distributed transaction, with reference to a table
being updated in the same transaction?

Mike