Microsoft KB Archive/189650

{|
 * width="100%"|

PRB: 80040e25 Error Calling a Stored Procedure

 * }

-

The information in this article applies to:


 * ActiveX Data Objects (ADO), version 1.5

-

SYMPTOMS
When you call a SQL Server 6.5 Stored Procedure using ActiveX Data Objects (ADO) version 1.5, the following error appears:

Microsoft OLE DB Provider for ODBC Drivers error '80040e25' All HROWs must be released before new ones can be obtained.

This error occurs if the recordset is created with an adOpenKeySet (1) or adOpenStatic (3) cursor.

RESOLUTION
Here are several possible resolutions:


 * Use a CursorType of adOpenForwardOnly (0) or adOpenDynamic (3) as in the following:
 * Use a CursorLocation of adUseClient (3) as in the following:
 * Use the EXEC or CALL keywords to call the Stored Procedure as in the following:

STATUS
This error does not occur with ADO version 1.0.

This problem was corrected in ActiveX Data Objects (ADO) 2.0 and later.

You may download the latest version of ADO in the Microsoft Data Access Components (MDAC) download, available at the following site:

"http://www.microsoft.com/data/download.htm" Additional query words:

Keywords : kbADO kbADO150 kbADO150bug kbADO200fix kbDatabase kbSQLServ kbStoredProc kbGrpVBDB kbGrpMDAC kbDSupport kbADO210sp2fix kbado250fix

Version : WINDOWS:1.5

Platform : WINDOWS

Issue type : kbprb

Technology :