OLEDBCommand Busy Fetching,Open

Posted on 2004-11-12
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
    LVL 3

    Accepted Solution

    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

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


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    C# Install and Make Database Changes 4 42
    Delegate in C# 3 38
    SQL QUERY to Table question 32 60
    button logout not work ASP.NET C# 2 28
    Article by: Najam
    Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    731 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

    19 Experts available now in Live!

    Get 1:1 Help Now