asked on

multiple-step ole db operation error opening ADO connection.

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 "http://support.microsoft.com/kb/269495/EN-US/" 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=''")

jacobhoover

Are there any errors in the error collection?

If so, what are they?

britttd

ASKER

How do I look in this?

jacobhoover

           Try
                  Me.Connection.Open()
            Catch e As System.Data.OleDb.OleDbException
                  Dim err As System.Data.OleDb.OleDbError
                  For Each err In e.Errors()
                        System.Diagnostics.Debug.WriteLine(e.Message)
                  Next
            End Try

britttd

ASKER

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.

ASKER CERTIFIED SOLUTION

jacobhoover

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

britttd

ASKER

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