From: "Daniel A. Morgan" <dmorgan@exesolutions.com>
Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.tools
Subject: Re: Problems with Distributed Transactions
Date: Tue, 05 Jun 2001 23:10:13 -0700
Organization: EXE
Message-ID: <3B1DC945.AA359A33@exesolutions.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
References: <9fj2h1$p04$1@newton3.pacific.net.sg>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yabetcha.drizzle.com!unknown@ava25.drizzle.com
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
X-Complaints-To: newsabuse@supernews.com
Lines: 20


Koh Sin Guan wrote:

> Hi,
>    I am experimenting with distributed transactions and have encountered
> some problems. Below is the
>
>    select * from customer@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.

Not in Oracle. But I wonder whose ODBC driver you are using.

Daniel A. Morgan