91) 12/7/2003 195491195491  195491.html">PRB: ADO Run-Time Error with Update/Delete and SET NOCOUNT ON
(195491) - The following run-time errors may occur when you try to Update/Delete data with an ActiveX Data Objects (ADO) server-side cursor: Cursor operation conflict. -or- Errors occurred. Using ADO 2.1 Service Pack 2 (SP2) and earlier versions, the MSDASQL...

92) 12/7/2003 197449197449  197449.html">PRB: Problems Reusing ADO Command Object on Multiple Recordsets
(197449) - When you use a single command object to open multiple recordset objects with one or more of those recordset objects open at the same time, you encounter unexpected behavior. This is most noticeable when you open stored procedures with output or return...

93) 12/7/2003 195487195487  195487.html">FIX: OpenSchema Method Generates Error 3251
(195487) - Using server-side cursors to open a recordset with OpenSchema, such as "Set rs = Connection.OpenSchema" generates error 3251: Application-defined or object-defined error.

94) 12/7/2003 189948189948  189948.html">BUG: NextRecordset Fails on Remoted or Disconnected Records
(189948) - When you call the NextRecordset method on a remoted or disconnected recordset, one of the following error message appears: Run-time error: '3251': The operation requested by the application is not supported by the provider. -or- The object or provider...

95) 12/7/2003 191572191572  191572.html">INFO: Connection Pool Management by ADO Objects Called From ASP
(191572) - When using ActiveX Data Objects (ADO) within an Active Server Pages (ASP) page, it is important to know how to utilize connection pooling effectively. When using different combinations of implicit and explicit ADO connections with ADO recordsets and...

96) 12/7/2003 189838189838  189838.html">PRB: NextRecordset Never Returns Null or Nothing
(189838) - If you declare your recordset variable with the New keyword in the declaration on the object, the variable never returns nothing. This behavior could cause problems when using multiple recordsets and looping through the recordsets using the...

97) 12/7/2003 190726190726  190726.html">FIX: Visual C++ 5.0 #import Causes Errors with ADO Version 2.0
(190726) - On a clean Windows 95 or Windows 98 machine with DCOM95 or DCOM98 installed, compile the following in a .cpp file: #import "c:\program files\common files\system\ado\msado15.dll" RESULT: You get the following error messages: error C2504:...

98) 12/7/2003 188858188858  188858.html">PRB: "Command Time Out" Property Does Not Work
(188858) - Setting the Recordset's dynamic Command Timeout Property does not time out the query.

99) 12/7/2003 193096193096  193096.html">PRB: Invalid Certificates Cause RDS Problems
(193096) - NOTE : This article assumes that you are familiar with Remote Data Services (RDS) Visual Basic and Secured Sockets Layer (SSL). When using Visual Basic and RDS to retrieve data from an SSL Web site, the following errors might appear: Internet Client...

100) 12/7/2003 190450190450  190450.html">PRB: Error Message 3421 Passing a BLOB Argument to a Stored Procedure
(190450) - When you use the CreateParameter method to pass a Binary Large Object (BLOB) data to a stored procedure you need to specify the Maximum size of the data to be passed. However, when specifying the exact size of blob data the following error is...

101) 12/7/2003 185979185979  185979.html">HOWTO: Use ADO OpenSchema to Retrieve Table Index Information
(185979) - If you need to retrieve index information for a table using ActiveX Data Objects (ADO) you must use a custom stored procedure or the ADO OpenSchema method. The ADO OpenSchema method simplifies access to the indexes of a table and provides a universal...

102) 12/7/2003 187871187871  187871.html">PRB: Cannot Filter ADO Recordsets for Nulls
(187871) - Using the Filter property of an ActiveX Data Objects (ADO) 2.0 Recordset to filter out records containing NULLs always fails. It may fail with the following error or may accept the Filter property, but fail to apply the filter: Run-time error '3001':...

103) 12/7/2003 194005194005  194005.html">HOWTO: Use ADO to Return a Summary Row
(194005) - The sample code in this article demonstrates how to extract the value of summary rows using ADO. Summary rows are produced when you use a COMPUTE BY clause with any row aggregate functions in a SQL statement. These summary values appear as additional...

104) 12/7/2003 189406189406  189406.html">HOWTO: Populating a FlexGrid Control with ADO and ASP
(189406) - The FlexGrid ActiveX control is a powerful control to display and manipulate data from a database in Internet Explorer. This sample uses Visual InterDev's DataCommand Design-time control to access the datasource. The client-side script uses a call to...

105) 12/7/2003 180843180843  180843.html">PRB: Error Creating More Than One Recordset in a Transaction
(180843) - When you try to create more than one recordset in the middle of a transaction, the following error occurs: Cannot create a new connection because in manual transaction mode The HRESULT is 0x80004005. Alternatively, you may receive the following, more...