How do I "Check each OLE DB status value" as instructed by the error message?

572 Views Asked by At

I am troubleshooting a very old web site that uses Classic ASP written in Visual Basic. I've narrowed the problem down to a failure when attempting to open an ADO connection.

The code looks like this:

On Error Goto 0
Set myConnection = Server.CreateObject("ADODB.Connection")
myConnection.ConnectionString = myConnectionString;
myConnection.CommandTimeout = 180
myConnection.CursorLocation = 3
myConnection.Open

The error that I see in failed request logging looks like this:

<EventData>
    <Data Name="ContextId">{80340036-0006-FF00-113F-84710C7967BB}</Data>
    <Data Name="LineNumber">194</Data>
    <Data Name="ErrorCode">80040e21</Data>
    <Data Name="Description">Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.</Data>
</EventData>

The error message is "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

My question is: How exactly do I "check each OLE DB status value?" Is there some collection I need to iterate over?

Note: I am not asking for help determining root cause. I just want to "check each OLE DB status value" as instructed, so I can investigate it myself. Answers like this one try to help determine root cause, which is not what I'm asking.

0

There are 0 best solutions below