From: mark.powell@eds.com (Mark D Powell)
Newsgroups: comp.databases.oracle.server
Subject: Re: Problems with Distributed transactions
Date: 6 Jun 2001 07:46:52 -0700
Organization: http://groups.google.com/
Lines: 39
Message-ID: <178d2795.0106060646.403eb6ea@posting.google.com>
References: <9fj1sc$opp$1@newton3.pacific.net.sg> <3B1DAC16.D105A4E8@pro-ns.net>
NNTP-Posting-Host: 199.228.142.8
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 991838813 20446 127.0.0.1 (6 Jun 2001 14:46:53 GMT)
X-Complaints-To: groups-support@google.com
NNTP-Posting-Date: 6 Jun 2001 14:46:53 GMT


Alex Filonov <afilonov@pro-ns.net> wrote in message news:<3B1DAC16.D105A4E8@pro-ns.net>...
> 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.
> 
> oerr ora 2041
> 02041, 00000, "client database did not begin a transaction"
> // *Cause: internal error
> // *Action: contact support
> 
> I think you should trust Oracle and contact support.

Before calling support try replacing the statement with:
select * from customer

where customer is a synonym of the form
create public synonym customer for owner.customer@test.com

Also if the database link does not have a hard-coded userid/password
but uses the current user then make sure the id connecting to Oracle
in the VB application has been granted access to the object in the
remote database.

If this fails then check both databases alert logs for any error
messages that may be of interest for when you talk to support.

-- Mark D Powell --