76) 12/7/2003 231351231351  231351.html">DOC: ADO VC Tutorial in MSDN Has Compile/Run-Time Errors
(231351) - The ADO Visual C++ Tutorial in MSDN has problems in the code that can cause one or more compilation or run-time errors. To get to this tutorial, do the following: Start MSDN, click the Contents tab. Navigate as follows: Platform SDK, Data Access...

77) 12/7/2003 224591224591  224591.html">PRB: SQL Server Stored Procedure's Out Parameters Can Return Incorrect Values
(224591) - When using ADO and the default server side cursor is out, parameters return NULL values.

78) 12/7/2003 230276230276  230276.html">FIX: ADO Recordset GetString() Function Throws an Access Violation in Oleaut32.dll
(230276) - Calling the GetString() function on a _RecordsetPtr object may cause the following error to occur: Unhandled Exception in <application name> (OLEAUT32.DLL) : 0xC0000005: Access Violation

79) 12/7/2003 235282235282  235282.html">INFO: SQL Server Spawns Additional Connections When You Open Multiple ForwardOnly ADO Recordsets
(235282) - When you try to open more than one ForwardOnly ADO recordset on a single Connection object at a time, only the first ADO recordset is actually opened on the Connection object. New, separate connections are created for subsequent ForwardOnly recordsets...

80) 12/7/2003 238163238163  238163.html">HOWTO: Implement Nested Transactions with ADO and SQL Server
(238163) - ADO, with both SQLOLEDB and MSDASQL providers, does not support nested transactions with SQL Server. However, native T-SQL commands can still be used with ADO to implement nested transactions against SQL Server. This can be accomplished in two...

81) 12/7/2003 229654229654  229654.html">PRB: ADO adMarshalModified Causes Problem with Late Binding
(229654) - Using disconnected recordsets in ADO, it is possible to encounter a problem when passing recordsets out of process to a custom business object for updating. The problem occurs when you use the adMarshalModifiedOnly option before you pass the...

82) 12/7/2003 229612229612  229612.html">SAMPLE: Mfceqado.exe Shows How to Use English Query with MFC and ADO
(229612) - Mfceqado.exe is an English Query ADO Visual C++ sample that uses ADO in a Visual C++ MFC application to query SQL Server statements generated by the English Query engine. The sample uses DataGrid Control version 6.0 (OLEDB) to display the results.

83) 12/7/2003 232144232144  232144.html">INFO: Jet OLE DB Provider Version 4.0 Supports SELECT @@Identity
(232144) - The Jet OLE DB version 4.0 provider supports the SELECT @@Identity query that allows you to retrieve the value of the auto-increment field generated on your connection. Auto-increment values used on other connections to your database do not affect the...

84) 12/7/2003 219029219029  219029.html">HOWTO: Retrieving Calculated Fields from SQL Server 7.0
(219029) - Using the DBPROP_SERVERDATAONINSERT property on a rowset retrieves calculated fields and identity values immediately when they are inserted. DBPROP_SERVERDATAONINSERT makes the retrieval of this data a one step process, and improves the performance of...

85) 12/7/2003 216822216822  216822.html">PRB: Index Server: "ADO Could Not Find the Specified Provider"
(216822) - When you use ActiveX Data Objects (ADO) in a Visual Basic application to query an Index Server, you may receive the following error message: ADO could not find the specified provider

86) 12/7/2003 194981194981  194981.html">PRB: Unable to Delete from Table Having Cascade Delete Trigger
(194981) - Deleting a record from a SQL Server table with a cascade delete trigger causes the following error message when there are no matching rows in the child table if the OLE DB provider is used for SQL Server: -2147217864 The specified row could not be...

87) 12/7/2003 194799194799  194799.html">HOWTO: Retrieve RAW/LONG RAW Data from Oracle for ASP Page
(194799) - This article explains how to insert and retrieve RAW or LONG RAW data from an Oracle database for use in an Active Server Pages (ASP) page.

88) 12/7/2003 197528197528  197528.html">PRB: ADO Does Not Return Records After an Update
(197528) - When you issue an Update, Insert, or Delete statement followed by a Select statement from an ADO client application, if you reference the ADO Recordset object, you receive the following error: Run-time error '3265': ADO could not find the object in...

89) 12/7/2003 198535198535  198535.html">PRB: "No Such Interface Supported" Error Calling ADOX Method
(198535) - When you attempt to add a Foreign Key to an SQL Server table, the following error is generated: Run time error '-2147467262 (800004002)': No Such Interface Supported. Alternatively, under ADO 2.6 and later, you may see the following error: Run-time...

90) 12/7/2003 191793191793  191793.html">HOWTO: Intercept UpdateBatch and Call a Stored Procedure
(191793) - It may be desirable to call a stored procedure to insert data rather than having the client-batch cursor do straight Inserts by means of the UpdateBatch method. The WillChangeRecord event provides a place to intercept pending changes.