Solved

ora-2041 client doesn't begin a transaction

Posted on 2004-08-05
10
594 Views
Last Modified: 2012-06-27
actully  im using simple select query in access application and connection with oracle sdatabase through dsn but it is giving me error odbc calls failed
2041 error client doesn't begin a transaction. But thsi simple query is ruuning in oracle but nor running when i m using in access
so could you plse help me out
0
Comment
Question by:optimist
10 Comments
 
LVL 8

Expert Comment

by:annamalai77
ID: 11733001
hi

what is ur oracle and ur access version. and also paste the sql query ur using.

regards
annamaai
0
 
LVL 47

Accepted Solution

by:
schwertner earned 250 total points
ID: 11733258
Control Panel -> ODBC Data Sources

Please locate your DSN in the ODBC Data Sources Administrator, click on Configure an dlocate the check box that says

Disable Microsoft Transaction Server and select it to disable the
Microsoft Transaction Server.

Try your MS Access connection again.
If this doesn’t  help, look for patch to the ODBC driver.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 11734384
Optimist:

Don't leave all your threads open, this is against the forum policy.

spend your time reading other's solution, if it does help solve your problem, close it and assign the points to show respect and courtesy.

thanks for your cooperation!
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 4

Assisted Solution

by:ramumorla
ramumorla earned 250 total points
ID: 11734678
PROBLEM:
1. Can't use db_link when connected through ODBC. .  

2. When trying a basic select statement through a db_link you get     ORA-2041 : client database did not begin a transaction .  

3. This fails using 8.1.5.2 odbc driver connected to various versions     of the database.  

4. This will succeed with the 8.0.5.0.0 driver.  

 DIAGNOSTIC ANALYSIS: .     Ct has a Visual C++ application on NT which connects to PO 8.1.5,     which has a db_link to a 7.3.2 database on SCO-Unix.     When doing a simple select from a linked table ct reports ora-2041. .     I managed to reproduce this with 8.1.5 EE as well as various other     versions. .     A sqlnet trace level 16 doesn't show any useful information      between the select and the error message. . .

WORKAROUND:     Use the 8.0.5.0.0 odbc driver.  This is the only other one that I've     tested, I'm not sure whether 8.0.5.x work as well.
0
 
LVL 4

Expert Comment

by:ramumorla
ID: 11734684
If the above doesnt work then

Upgrade to the latest ODBC driver and enable the option 'Disable MTS  support' in the DSN configuration.  

To do this, perform the following steps:  

1. Click Start -> Settings -> Control Panel -> ODBC Administrator

2. Select the DSN you are using, then click the Configure button.

3. You should see the 'Disable MTS support 'option listed in the 'Workarounds'  section.  If you do not see this option, you are probably not on the latest  version.

4. It is sometimes necessary to either drop and recreate the DSN and/or  table link in MSAccess, as MSAccess appears to cache DSN settings.  The latest version can be obtained from MetaLink, by clicking on the following:        Technical Libraries -> Tools -> Programmatic Interfaces ->           ODBC -> Latest Versions  
0
 
LVL 4

Expert Comment

by:ramumorla
ID: 11737095
did you try working ion this at all?
0
 
LVL 4

Expert Comment

by:ramumorla
ID: 11774910
Hi Are we going ahead on this?

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now