What is the OLE DB Multiple Step Error?

Question

I am doing a bit of work on the terrible software created by the best in Bangalore.

It is written primarily in classic ASP / VbScript, but is "ported" to ASP.NET, although most of the code is a classic ASP style in ASPX pages :(

I get this message when it tries to connect to my local database:

The OLE DB multi-step operation generated errors. Check each OLE DB status value, if available. There was no work.

Line 38:    MasterConn = New ADODB.Connection()
Line 39:    MasterConn.connectiontimeout = 10000
Line 40:        MasterConn.Open(strDB)

Does anyone know what this error means? Its connecting to my local machine (starting SQLEXPRESS) using this connection string:

PROVIDER=MSDASQL;DRIVER={SQL Server};Server=JONATHAN-PC\SQLEXPRESS\;DATABASE=NetTraining;Integrated Security=true

What connection string from which it was originally used, I just put it in my database.

UPDATE:

"Integrated Security" ADO. , .

Answer 1

, ASP. , . , .

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

, , , . :

DRIVER={SQL Server};

:

Provider=SQLOLEDB;

Answer 2

connectionstrings.com - , .

Answer 3

I ran into this problem when trying to connect to a MySQL database through a wonderful classic ASP. The above solutions did not fix it directly, but I eventually solved it by updating the ODBC driver (from long 3.51) to the latest version. Then I was able to leave the driver string (and not add the provider bit), but I had to update the connection string accordingly:

Driver={MySQL ODBC 5.1 Driver};

This worked fine. Lucky.