Re: Database link and ORA-02041: client database did not begin a transaction

after doing seach on other groups (MS Access) found a solution for my problem..

Control Panal-->SYSTEM DSN--> pes_orcle_odbc-->Configure--> Workarounds-->Disable Microsoft Transaction Server (check it)

worked wonders

faris_idris_at_hotmail.com (faris_idris_at_hotmail.com) wrote in message news:<fe478e3a.0307170727.69e2fb73_at_posting.google.com>...
> Hello, we are using Oracle 9i for client and server and Powerbuilder
> 8.0.3. We have a database link between two databases, whenever I try
> to do a simple select, update or insert I get the following error. Any
> idea why?
> "ORA-02041: client database did not begin a transaction"
>
> This is the sql I am using. It works fine if I am on sql plus. I have
> also tried to "using sqlca" as well as creating a new transaction for
> the select. All return the same error message.
>
> string ls_new
> select id_num
> into :ls_new
> from id_rec
> where user_if = '818';
> if sqlca.sqlcode <> 0 then
> messagebox("Error ",sqlca.sqlerrtext)
> end if
>
>
>
>
> also this is the definition it gives for the error message
> ----------------------------------------
> ORA-02041: client database did not begin a transaction
>
> Cause: An update occurred at a coordinated database without the
> coordinator beginning a distributed transaction. This may happen if a
> stored procedure commits and then performs updates, and the stored
> procedure is invoked remotely. It could also happen if an external
> transaction monitor violates the XA protocol.
>
> Action: If the cause is the former, check that any commit is not
> followed by an update.
> ----------------------------------------
Received on Mon Jul 21 2003 - 18:18:44 CEST