Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ora-2041 client doesn't begin a transaction

Posted on 2004-08-05
10
Medium Priority
?
619 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 48

Accepted Solution

by:
schwertner earned 1000 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 4

Assisted Solution

by:ramumorla
ramumorla earned 1000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

715 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