Microsoft Data Access Components (MDAC) 2.6 articles, fixes and updates - Year 2005

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Data Access Components (MDAC) 2.6 that have been released in Year 2005. The list is daily updated.

• 306649 Error message when you implement a nested transaction with the OLE DB Provider for SQL Server: "Could not start a transaction for OLE DB provider" Q306649 KB306649 December 9, 2005
• 271621 How To Retrieve XML Data with a Template File from a Visual Basic Client Q271621 KB271621 November 22, 2005
• 247202 Cannot set Empty to Date field using Oracle, SQL Provider, or Kagera Q247202 KB247202 November 22, 2005
• 329414 MS02-065: Buffer overrun in Microsoft Data Access Components can lead to code execution Q329414 KB329414 October 21, 2005
• 277711 FIX: Updates to Linked ODBC Tables Causes Access Violation in Msjet40.dll Q277711 KB277711 October 19, 2005
• 315761 FIX: SQLTables() with a Server-Side Cursor Returns No Data Q315761 KB315761 October 12, 2005
• 314125 FIX: AV When You Call MSXML 2.6 Parser from a Stored Procedure Q314125 KB314125 October 12, 2005
• 312495 FIX: SQLManageDataSources Fails When Connection Pooling Is Turned On at Process Level Q312495 KB312495 October 12, 2005
• 312085 FIX: When You Disconnect a Hierarchical Recordset the Connection Is Not Released Q312085 KB312085 October 12, 2005
• 304329 FIX: Application Using Microsoft Oracle ODBC Driver Crashes When TNS Does Not Exist Q304329 KB304329 October 12, 2005
• 327964 FIX: High Critical Section Contention in MSWSTR10.dll under Stress Q327964 KB327964 October 11, 2005
• 327723 FIX: Access Violation Occurs with ODBC BCP and Connection Pooling Q327723 KB327723 October 11, 2005
• 321989 Access Violation in OLE DB When You Use ADO to Retrieve Data Q321989 KB321989 October 11, 2005
• 320698 OLE DB Session Pooling Causes 100 Percent CPU Usage (MDAC 2.6) Q320698 KB320698 October 11, 2005
• 320498 Fix: ODBC PerfMon Pooling Counters Disappear if Other Non-ODBC Counters Are Present in PerfMon Q320498 KB320498 October 11, 2005
• 319246 FIX: Error Dialog Box During SQL Server Database Backup Q319246 KB319246 October 11, 2005
• 237977 INFO: OLE DB Session Pooling Timeout Configuration Q237977 KB237977 October 7, 2005
• 152534 How to use ODBC in an ActiveX control by using Visual C++ Q152534 KB152534 September 30, 2005
• 322149 FIX: ADO Client Cursor Engine Leaks Memory If Provider Does Not Support Some DBPROP or Rowset Properties Q322149 KB322149 September 27, 2005
• 318606 FIX: SQL Server ODBC Driver Resets Connection Attributes When Used in Connection Pooling Q318606 KB318606 September 27, 2005
• 312994 FIX: MSDAORA Incorrectly Returns Padded Data for a CONSTANT CHAR(x) Field Q312994 KB312994 September 26, 2005
• 311155 FIX: "ODBC SQL Server Driver" Error Message When You Use the MDAC 2.6 ODBC Driver from SP1 or SP2 Q311155 KB311155 September 26, 2005
• 308401 FIX: SQLExecute on a Prepared Statement with SQL_NOSCAN_ON Causes Client-Side AV Q308401 KB308401 September 26, 2005
• 308262 FIX: Access Violation Occurs on the Filter Property in ADO Q308262 KB308262 September 26, 2005
• 308037 FIX: ADO GetValue Does Not Check DBSTATUS_S_ISNULL for VARIANT Q308037 KB308037 September 26, 2005
• 305983 FIX: OLE DB Simple Provider Does Not Issue Notifications on the aboutToChangeCell and cellChanged Functions Q305983 KB305983 September 26, 2005
• 303643 FIX: Internet Explorer Stops Responding When You Open a Corrupted XML Document Q303643 KB303643 September 26, 2005
• 303446 FIX: SQLOLEDB Returns No Data When Using AutoFetch Option with Fast Forward Cursors Q303446 KB303446 September 26, 2005
• 302995 FIX: Memory Leak in MDAC SQLOLEDB Provider on SERVERDATAONINSERT and Column Size That Is Larger Than 255 Q302995 KB302995 September 26, 2005
• 302248 FIX: SQLOLEDB Does Not Work with DBACCESSOR_OPTIMIZED Flag and SSPROP_ENABLEFASTLOAD Q302248 KB302248 September 26, 2005
• 301953 Unenlisting from active transaction using SQLOLEDB provider of MDAC 2.6 release against SQL Server 7.0 causes hang and drain abort entry Q301953 KB301953 September 26, 2005
• 301679 FIX: Access Violation in IDBProperties::GetProperties When You Use OLE DB Service Components Q301679 KB301679 September 26, 2005
• 301497 FIX: The adAsyncExecute Flag Fails with VFPODBC After You Install MDAC 2.6 Q301497 KB301497 September 26, 2005
• 301199 FIX: Access Violation Passing ADO Command Object to ADO Recordset Open() with MDAC 2.6 Q301199 KB301199 September 26, 2005
• 300420 FIX: Connection to SQL Server Database Using IP Address Is Unusually Slow Q300420 KB300420 September 26, 2005
• 299765 FIX: SQL Server 2000 ODBC Driver fails to return SQL Server 7.0 server names on client computers that have MDAC 2.6 installed Q299765 KB299765 September 26, 2005
• 297266 FIX: SQLOLEDB: Incorrect Transaction Enlistment Causes Hang and Drain Abort Entry Q297266 KB297266 September 26, 2005
• 297035 FIX: Correlation Error Using Parameters.Refresh with SQLOLEDB Q297035 KB297035 September 26, 2005
• 295757 FIX: Second SQLExecute on Prepared Statement with SQL_NOSCAN_ON Causes Client-Side AV Q295757 KB295757 September 26, 2005
• 295538 FIX: Resetting ADO Parameter Object Properties in Loop Causes Memory Leak Q295538 KB295538 September 26, 2005
• 295054 FIX: Insert with OPENXML Statement Generates Duplicate Key Error Q295054 KB295054 September 26, 2005
• 294138 FIX: Outer Join Syntax with Parameter Fails Against SQL Server 6.5 Q294138 KB294138 September 26, 2005
• 291838 FIX: Crash in SQLXMLX Hangs Web Service Threads Q291838 KB291838 September 26, 2005
• 291545 FIX: Multithreaded Java Applications Using ADO Fail with Access Violation Q291545 KB291545 September 26, 2005
• 286359 FIX: SQL Server ODBC Driver Generates Error When Executing a Stored Procedure on SQL Server 2000 Q286359 KB286359 September 26, 2005
• 285006 FIX: You receive error message 6603 or text data may be truncated when you select a text data type through the OPENXML provider in SQL Server 2000 Q285006 KB285006 September 26, 2005
• 283106 FIX: Aggregating ADO Recordsets or Commands May Cause Memory Leak Q283106 KB283106 September 26, 2005
• 281646 FIX: Buffer Overrun When Using SQLConnectW with ODBC Pooling Q281646 KB281646 September 26, 2005
• 281633 FIX: SQLOLEDB Provider incorrectly leaves transaction open Q281633 KB281633 September 26, 2005
• 279526 FIX: SQL Server ODBC Driver Ignores Authentication Setting Q279526 KB279526 September 26, 2005
• 277033 FIX: SQL_BIGINT in 2.x ODBC Driver is mapped to SQL_C_SBIGINT 3.0 datatype Q277033 KB277033 September 26, 2005
• 274265 FIX: AV Marshalling the Same ADO Recordset on Multiple Threads Q274265 KB274265 September 26, 2005
• 273813 FIX: "Incorrect Syntax near the Keyword 'by' " Error Message with Column Names of "C", "CA" or "CAS" Q273813 KB273813 September 26, 2005
• 185821 How to retrieve the automatic @@IDENTITY value from an insert to a SQL Server database in Visual C++ Q185821 KB185821 September 1, 2005
• 188713 How To Change Information in a Database from ASP Q188713 KB188713 August 11, 2005
• 189408 FIX: ASP Fails to Access Network Files Under IIS 4.0 and IIS 5.0 Q189408 KB189408 July 8, 2005
• 280067 PRB: Retrieving very large XML Documents from SQL Server 2000 by using ReadText method of ADO stream object may be slow Q280067 KB280067 June 30, 2005
• 222664 PRB: Call to SQL Stored Procedure Returns 'Invalid Column Name' Q222664 KB222664 June 23, 2005
• 253157 BUG: Identity field remains read-only after executing SET IDENTITY_INSERT ON statement Q253157 KB253157 April 29, 2005
• 248287 INFO: Understanding ADO Marshaling Q248287 KB248287 March 29, 2005
• 196968 PRB: SHAPE Provider Pulls Down All Records in Child Table Q196968 KB196968 March 14, 2005
• 196958 INFO: Most MDAC Components Are Not Supported on Windows NT 3.51 Q196958 KB196958 March 14, 2005
• 195049 How To Maintain Binary Compatibility in Components Exposing ADO Q195049 KB195049 March 14, 2005
• 194005 HOWTO: Use ADO to Return a Summary Row Q194005 KB194005 March 14, 2005
• 193347 PRB: Error When You Use MS Data Shape Provider in Data Environment Q193347 KB193347 March 14, 2005
• 191741 INFO: RDS Registry/Security Settings for Custom Business Objects Q191741 KB191741 March 14, 2005
• 183329 How To Populate an ActiveX TreeView Control Using ASP Q183329 KB183329 March 14, 2005
• 182290 HOWTO: Return Multiple Recordsets with Column Names and Values Q182290 KB182290 March 14, 2005
• 179326 FILE: Idxadovb.exe: Using Index Server OLE DB Provider and ADO in Visual Basic Q179326 KB179326 March 14, 2005
• 178038 PRB: Implicit Conversion Error Calling Second Stored Procedure Q178038 KB178038 March 14, 2005
• 176086 How To Retrieve Recordsets from Oracle Stored Procedures Using ADO Q176086 KB176086 March 14, 2005
• 191695 You receive an ODBC driver error message when you set a Left Outer Join between two tables in Visual FoxPro Q191695 KB191695 March 10, 2005
• 195470 PRB: ODBC 3.0 Requirements for Numeric Fields Q195470 KB195470 March 2, 2005
• 192227 INFO: ADO 2.0 Command Object ConnectionString Property Changes Q192227 KB192227 March 2, 2005
• 190473 CreateRS.exe Uses the CreateRecordset Function in VC++ Q190473 KB190473 March 2, 2005
• 190411 How To Bind a DataReport To an ADO Recordset at Run Time Q190411 KB190411 March 2, 2005
• 190410 PRB: Error Assigning Non-Opened Recordset to ADODC Q190410 KB190410 March 2, 2005
• 190371 HOWTO: Use Bound Controls with an ADO Recordset Q190371 KB190371 March 2, 2005
• 189415 AdoChunk.exe Using GetChunk and AppendChunk in Visual C++ Q189415 KB189415 March 2, 2005
• 189220 BUG: "Syntax Error in INSERT INTO..." on ADO Recordset.Update Q189220 KB189220 March 2, 2005
• 165671 HOWTO: Use ASP/ADO to Query an ODBC Datasource (SELECT) Q165671 KB165671 March 2, 2005
• 282604 ACC2000: Microsoft Jet Does Not Pass WHERE Clause to ODBC Data Source Q282604 KB282604 January 26, 2005
• 310303 Visual Basic 6.0 Package and Deployment Wizard does not distribute MDAC 2.6 Q310303 KB310303 January 18, 2005
• 243069 INFO: List of Useful Articles Related to MDAC Setup Q243069 KB243069 January 12, 2005