What is this 'Multiple-step OLE DB' error?

Question

I'm doing a little bit of work on a horrid piece of software built by Bangalores best. It's written in mostly classic ASP/VbScript, but "ported" to ASP.NET, though most of the code is classic ASP style in the ASPX pages :( I'm getting this message when it tries to connect to my local database: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. ``` Line 38: MasterConn = New ADODB.Connection() Line 39: MasterConn.connectiontimeout = 10000 Line 40: MasterConn.Open(strDB) ``` Anybody have a clue what this error means? Its connecting to my local machine (running SQLEXPRESS) using this connection string: ``` PROVIDER=MSDASQL;DRIVER={SQL Server};Server=JONATHAN-PC\SQLEXPRESS\;DATABASE=NetTraining;Integrated Security=true ``` Which is the connection string that it was initially using, I just repointed it at my database. UPDATE: The issue was using "Integrated Security" with ADO. I changed to using a user account and it connected ju…

Accepted Answer

I ran into this a long time ago with working in ASP. I found this knowledge base article and it helped me out. I hope it solves your problem.

http://support.microsoft.com/kb/269495

If this doesn't work and everything checks out, then it is probably your connection string. I would try these steps next:

Remove:

```
DRIVER={SQL Server};
```

Edit the Provider to this:

```
Provider=SQLOLEDB;
```

What is this 'Multiple-step OLE DB' error?

Solution

Problem