[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


OLEDBCommand Busy Fetching,Open

Posted on 2004-11-12
Medium Priority
Last Modified: 2010-04-15
I have a C# windows application that opens up an MDB file and allows to search for a term and then delete all of the rows after it.  On my development box, I can run the code in the debugger and also install the application and run it.  But if I try to install and run the application on a users PC I get the "OLEDBCommand busy fetching,open" error message.
I have been working with 3 machines:
1 - Development box - Win2k prof running Visual Studio 2002 with .Net Framework 1.1 SP1. MS Acccess  2002 installed.
2 - Win 2k Prof with .Net Framework 1.1 SP1.  MS Access Not installed.
3 - Win 2k Prof with .Net Framework 1.1SP1 MS Access 2002 installed.

At first I didn't have Framework 1.1 sp1 installed on the devleopment dox, so I installed it and updated at the .net references and re-compiled it.  But this did not work.

I don't know where to look in the code of the problem since it works fine on my dev box.  I have researched the error and found that it usually means the oledbcommand is being called twice simutaneously, but why would it work on the development box.

Any ideas on what the problem could be?

Question by:patriotsfan

Accepted Solution

_kiwi_ earned 1000 total points
ID: 12568263
Did you check the MDAC versions on your development boxes ?

Since you use a MDB file, I guess Access has to be installed on all of your deployment boxes (I see one of them doesn't have it).

Visual Studio 2002 works for .Net Framework 1.0, not 1.1, so having the .Net Framework 1.0 SP2 installed instead of the .Net Framework 1.1 may be also an idea.

Author Comment

ID: 12569782
I needed to install .Net 1.0 SP3 on the workstations but did not need MS Access to be installed.


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 introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Loops Section Overview
Suggested Courses

834 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