470,602 Members | 1,589 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,602 developers. It's quick & easy.

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

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.
----------------------------------------
Jul 19 '05 #1
1 14084
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

fa*********@hotmail.com (fa*********@hotmail.com) wrote in message news:<fe**************************@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.
----------------------------------------

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Thiemo Kellner | last post: by
1 post views Thread by Doron | last post: by
6 posts views Thread by bdj | last post: by
3 posts views Thread by Michael John | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.