473,287 Members | 1,904 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

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 14418
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Thiemo Kellner | last post by:
Hi, we have come across the problem that the execution of a stored procedure by our scheduling tool (cronacle -> over db link) fails with the error message: ORA-04068: existing state of...
1
by: Doron | last post by:
I'm getting a ORA-00600 error on SYS.EXU8REF (see trace file below). SYS.EXU8REF is a view so the problem should be with one of the underlaying tables. i didnt run oerr12700 yet. can i find the...
6
by: bdj | last post by:
Hello! I have at set of tnsnames.ora. I wich to make an union, e.g. a single file of it. How can I do that easy? Greetings Bjørn
3
by: Michael John | last post by:
Hey, how can I get ORA-..... error messages in languages other than english. I did a alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1'; but this only threw an ORA-00922. Or I'm wrong...
1
by: Jawahar | last post by:
All, I have a C# application with an Oracle backend. There is a fair amount of locking being used to prevent two users from update the same records. So we use the Oracle FOR UPDATE NOWAIT in our...
2
by: mpatel6 | last post by:
I had this error in alert log and my instance was down, anybody can help me? Errors in file /u01/app/oracle/admin/sotstest/bdump/sotstest_p004_626740.trc: ORA-07445: exception encountered: core...
8
by: CJM | last post by:
I have a working web application (ASP) which links to an Oracle 10g DB via OO4O. I'm trying to port it to either of two test servers, but in fact, I can't get it to work with either - 'Unable to...
2
by: prashanttarudkar9 | last post by:
Hi all, I installed oracle server 9.2.0.4.0 in Windows 2000 professional O.S. But now I am trying to connect with server, but I got the following error. ORA-12514: TNS:listener could not...
5
by: Nitvar | last post by:
When i am trying to connect to oracle it is giving me these two errors ORA-12224: TNS:no listener ORA-01034: ORACLE not available I am new to oracle ,plz help I am using solaris 5.6 and...
1
by: hoonig | last post by:
I have this traditional error "ORA-12560:TNS:Protocol Adapter Error" when trying to connect to my Oracle 8i databases on Netware (i.e when i load svrmgr31, plus81, etc...) Listener seems to work...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.