multiple-step ole db operation error opening ADO connection.

Posted on 2004-11-18
Last Modified: 2012-06-21
I am trying to Open an OLE DB connection to my Visual FoxPro connection.  On the open statement, I am getting an error saying "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done".  This exact same connection opens fine on a different PC but only on my new PC does this fail.  I went to the following link on Microsoft's website "" and the value that it says to add to my registry is arleady there.   I am at a loss.  

My connection string is as follows:

Public cn As New OleDbConnection("Provider=vfpoledb.1 ;Data Source=\\server\amw.dbc;Mode=ReadWrite|Share Deny None;Collating Sequence=MACHINE;Password=''")
Question by:britttd
    LVL 7

    Expert Comment

    Are there any errors in the error collection?  

    If so, what are they?

    Author Comment

    How do I look in this?
    LVL 7

    Expert Comment

                Catch e As System.Data.OleDb.OleDbException
                      Dim err As System.Data.OleDb.OleDbError
                      For Each err In e.Errors()
                End Try

    Author Comment

    Only error that comes up is:

    Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
    LVL 7

    Accepted Solution

    Do you have the Visual Fox Pro provider on your new machine?

    Also, the call to :
    will only be seen from inside your debugger.  If you don't have a debugger installed on the "new" machine, you may have to use a different means of showing the error... Ie, creating a messagebox and displaying each of the e.Message in it.

    Author Comment

    I ended up reformatting my machine and it works fine now.  Don't know what it was but it works now so...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Title # Comments Views Activity
    Simple (?) problem getting Rainbow Folders to run 6 73
    withoutTen challenge 14 68
    hasOne  challenge 59 62
    find a node in VST 2 36
    This article is filled with multiple code samples and explanations for mathematical calculations. They are as follows: 1. General tips 2. Quadratic formula 3. Object collision 4. Projectile path General Tips       Here are some of my tips f…
    A short article about problems I had with the new location API and permissions in Marshmallow
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    759 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

    9 Experts available now in Live!

    Get 1:1 Help Now