Re: Problems with Distributed transactions

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: Thu, 07 Jun 2001 10:38:59 +0100
Message-ID: <kqiuht0acbfpor531m1fb64va4lbr25cqr@4ax.com>

On Wed, 6 Jun 2001 01:29:36 +1000, "Koh Sin Guan" <singuan_at_pacific.net.sg> wrote:

>Hi,
> I am experimenting with distributed transactions and have encountered
>some problems. Below is the
>
> select * from customer_at_test.com
>
> When I execute the above statement from SQL Plus, it works fine.
>However, when I tried executing the same statement using VBScript, i get the
>following error.
> ORA-02041: client database did not begin a transaction
>
>I am wondering if there is any configuration settings that needs to be done
>before using the distributed transactions.
>

I've had this problem. If you're using ODBC, you need to disable Microsoft Transaction Server (MTS) support in the ODBC configuration. I think you can do it as part of the connection syntax as well. Received on Thu Jun 07 2001 - 04:38:59 CDT