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

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 2004. The list is daily updated.

• 285295 SQL Server 2000 changes name of RETURN_VALUE to @RETURN_VALUE Q285295 KB285295 December 15, 2004
• 286381 PRB: ORA-0600 internal error when calling Oracle external stored procedures Q286381 KB286381 December 6, 2004
• 304578 INFO: What Happens When MDAC 2.5 SP1 or SP2 Is Installed Over MDAC 2.6 Q304578 KB304578 November 17, 2004
• 309306 BUG: OLE DB HIERARCHIES Schema Rowset Incorrectly Documents the ALL_MEMBER Column Q309306 KB309306 September 10, 2004
• 278872 How To Specify Parameters for an XML Template Query from Visual Basic Q278872 KB278872 August 30, 2004
• 229884 How To Use OLE DB DBTYPE_VARNUMERIC Q229884 KB229884 August 30, 2004
• 195047 How To Call a Parameterized SQL Server Stored Procedure from ADO Q195047 KB195047 August 30, 2004
• 325277 Support WebCast: New Features in Microsoft Data Access Components 2.6 Q325277 KB325277 August 9, 2004
• 279882 SAMPLE: ODBCConfTool20.exe Obtains ODBC Driver Conformance Level Q279882 KB279882 August 9, 2004
• 272185 SAMPLE: How to Retrieve Data Using a SQL XML Query in ATL OLE DB Q272185 KB272185 August 9, 2004
• 271780 SAMPLE: How To Retrieve XML Data Using an SQL XML Query with ADO in Visual C++ Q271780 KB271780 August 9, 2004
• 271775 SAMPLE: How To Retrieve Relational Data Using OpenXML with ADO in Visual C++ Q271775 KB271775 August 9, 2004
• 271773 SAMPLE: How To Retrieve Actions, Functions and Sets Schemas from the Microsoft OLAP Provider Q271773 KB271773 August 9, 2004
• 197861 ADOCtl.Exe Demonstrates Active Documents, RDS and ADO Q197861 KB197861 August 9, 2004
• 192762 Dbf2rs.exe Converts a VFP Cursor to ADO 2.x Recordset Q192762 KB192762 August 9, 2004
• 150886 Unsup.exe Finds Commands Not Supported by ODBC Drivers Q150886 KB150886 August 9, 2004
• 288054 SAMPLE: RLockMFC.exe Demonstrates Row-Level Locking Using MFC and SQL Server Q288054 KB288054 August 5, 2004
• 272182 SAMPLE: How to Retrieve Hierarchical Rowsets from XML Data Using MSDAOSP in ATL OLE DB Q272182 KB272182 August 5, 2004
• 272181 SAMPLE: How to Retrieve Data Using a Template File in ATL OLE DB Q272181 KB272181 August 5, 2004
• 272180 SAMPLE: How to Retrieve XML Data Using a Template File with ADO in Visual C++ Q272180 KB272180 August 5, 2004
• 272177 SAMPLE: Using OLEDB Templates to Retrieve XML Data Through XPath Query Q272177 KB272177 August 5, 2004
• 272176 SAMPLE: How to Run Singleton SELECT Queries in Visual C++ Q272176 KB272176 August 5, 2004
• 271778 SAMPLE: How to Retrieve Hierarchical Recordsets from XML Data Using MSDAOSP with ADO in Visual C++ Q271778 KB271778 August 5, 2004
• 271774 SAMPLE: How To Manipulate the "Trustee PIN" Jet Property Using ADOX in VC Q271774 KB271774 August 5, 2004
• 245745 SAMPLE: RDS_Comp.exe Demonstrates How to Use the RDS.Dataspace Object from Client Script Q245745 KB245745 August 5, 2004
• 244659 SAMPLE: How to Create a Data Link File with Windows 2000 Q244659 KB244659 August 5, 2004
• 197916 How To Use GUIDs w/ Access, SQL 6.5 and SQL 7 Q197916 KB197916 August 5, 2004
• 189206 PRB: "Couldn't Find File 'Unknown'" Error When You Set Default Language to JScript Q189206 KB189206 July 20, 2004
• 237536 PRB: 80004005 Unspecified Error When Passing Disconnected Recordset from MTS to ASP Q237536 KB237536 July 16, 2004
• 309130 How To Use the ADO SHAPE Command with a DataReader in Visual C# .NET Q309130 KB309130 July 15, 2004
• 300261 How To Create an ADO Connection from a Data Link File in Data Access Components Q300261 KB300261 July 15, 2004
• 254021 How To Return an Array of Recordsets from an ADO/RDS Server Q254021 KB254021 July 15, 2004
• 240019 How To Dynamically Populate a Data Report in Visual Basic Q240019 KB240019 July 15, 2004
• 238949 How To Set the SQL Server Network Library in an ADO Connection String Q238949 KB238949 July 15, 2004
• 230496 How To Compacting Microsoft Access Database Through OLE DB Q230496 KB230496 July 15, 2004
• 308045 How To Use the ADO SHAPE Command with a DataReader in Visual Basic .NET Q308045 KB308045 July 14, 2004
• 303814 How To Use ADOX with Excel Data from Visual Basic or VBA Q303814 KB303814 July 13, 2004
• 297980 How To Use ADOX to Create an AutoNumber Field of Replication ID Field Size Q297980 KB297980 July 13, 2004
• 274536 How To Specify a UDL File as the Source of Connection Attributes for a VB Data Environment Connection Object Q274536 KB274536 July 13, 2004
• 272270 How To Retrieve XML Data in ASP with the XML OLE-DB Simple Provider Q272270 KB272270 July 13, 2004
• 272269 How To Retrieve XML Data by Using a SQL XML Query in an ASP Client Q272269 KB272269 July 13, 2004
• 272165 How To Use a Singleton SELECT from ASP Q272165 KB272165 July 13, 2004
• 271689 How To Run Singleton SELECT Queries in a Visual Basic Client Q271689 KB271689 July 13, 2004
• 271620 How To Retrieve XML Data by Using a SQL XML Query in a Visual Basic Client Q271620 KB271620 July 13, 2004
• 271619 How To Retrieve XML Data by Using an XPath Query in a Visual Basic Client Q271619 KB271619 July 13, 2004
• 271494 How To Send Batch SQL Statements to Oracle Q271494 KB271494 July 13, 2004
• 261108 How To Use ADO in VFP Interactively with the ADO Control Q261108 KB261108 July 13, 2004
• 259492 How To Use DBPROP_SERVERDATAONINSERT to Retrieve the Identity Value of a New Row Q259492 KB259492 July 13, 2004
• 258013 How To Use ADOX to Determine If a Primary Key Exists on a Table Q258013 KB258013 July 13, 2004
• 252348 How To Use IDataInitialize and Connection String Properties Q252348 KB252348 July 13, 2004
• 247380 How To Simulate Long-Running SQL Calls from ASP Q247380 KB247380 July 13, 2004
• 240838 How To Use the MSRemote Provider Through Client Script Q240838 KB240838 July 13, 2004
• 218600 How To Use Data Links to Create a Connection String at Run Time Q218600 KB218600 July 13, 2004
• 194517 How To Use Creatable ADO Recordsets in Visual FoxPro Q194517 KB194517 July 13, 2004
• 194516 How To Use ADO Hierarchical Recordsets Q194516 KB194516 July 13, 2004
• 191413 How To Use Offline ADO Recordsets in Visual FoxPro Q191413 KB191413 July 13, 2004
• 191375 HOWTO: Use COMCLASSINFO() to Check Installed ADO Version Q191375 KB191375 July 13, 2004
• 248799 How To Insert NULL Data with ODBC API Functions Q248799 KB248799 July 2, 2004
• 245359 How To Open Documents Using the Internet Publishing Provider Q245359 KB245359 July 2, 2004
• 244499 How To Install MDAC Components on Windows 2000 Platform Q244499 KB244499 July 2, 2004
• 293658 How To Force Query-Based Updates with ADO and MSDASQL Q293658 KB293658 July 1, 2004
• 283245 How To Persist Data Links Programmatically Q283245 KB283245 July 1, 2004
• 274551 How To Generate an ODBC Trace with ODBC Data Source Administrator Q274551 KB274551 July 1, 2004
• 272268 How To Manipulate the TRUSTEE PIN Jet Property with ADOX from an ASP Client Q272268 KB272268 July 1, 2004
• 263247 How To Obtain an ADO Recordset from XML Q263247 KB263247 July 1, 2004
• 260310 How To Insert NULL Data with OLE DB SDK Interfaces Q260310 KB260310 July 1, 2004
• 244040 How To Have Your ODBC Jet 3.5 and 4.0 Applications Co-exist Q244040 KB244040 July 1, 2004
• 224424 How To Implement Visual Basic COM Objects Returning Recordsets Q224424 KB224424 July 1, 2004
• 195236 How To Get ADO Default Connection Information Q195236 KB195236 July 1, 2004
• 195048 How To Determine Number of Records Affected by an ADO UPDATE Q195048 KB195048 July 1, 2004
• 194799 How To Retrieve RAW/LONG RAW Data from Oracle for ASP Page Q194799 KB194799 July 1, 2004
• 194610 How To Demonstration of ADO Bookmarks and Move Methods Q194610 KB194610 July 1, 2004
• 193947 How To Determine Recordset Field Properties Using ADO Q193947 KB193947 July 1, 2004
• 193946 How To Demo of ADO AddNew, Update, Delete, Find and Filter Q193946 KB193946 July 1, 2004
• 191717 How To Display Boolean Values in Bound DataGrid Q191717 KB191717 July 1, 2004
• 297963 How To Change Logon Information for Access Linked Tables at Run Time with ADOX Q297963 KB297963 June 29, 2004
• 291017 How To Change an Access Table Name Programmatically Q291017 KB291017 June 29, 2004
• 271772 How To Access Hierarchical XML Data with the XML OLE DB Simple Provider Q271772 KB271772 June 29, 2004
• 208208 How To Add Records with Memo Data Using the Visual FoxPro ODBC Driver Q208208 KB208208 June 29, 2004
• 203573 PRB: ASP/ADO Coding Error Produces ASP 0115 Error Q203573 KB203573 June 29, 2004
• 194960 How To Create an Asynchronous Connection in ADO Q194960 KB194960 June 29, 2004
• 159590 How To Connect to SQL Server Using a Trusted Connection in VFP Q159590 KB159590 June 29, 2004
• 110507 How To Configure ODBC Data Sources on the Fly Q110507 KB110507 June 29, 2004
• 305387 BUG: UpdateBatch Generates SQL Statement That Cannot Reuse SQL Server Query Plans Q305387 KB305387 June 28, 2004
• 196956 DOC: Visual Basic Does Not Allow You to Build OLE DB Providers Q196956 KB196956 June 24, 2004
• 190605 PRB: Binding Hierarchical Recordset in Data Environment Q190605 KB190605 June 24, 2004
• 320744 PRB: Incorrect NUMERIC and DECIMAL conversions with non-English locales Q320744 KB320744 May 25, 2004
• 326842 FIX: MDAC Installation Fails with Error 0x80070057 When Registry is at Size Limit Q326842 KB326842 April 6, 2004
• 317913 BUG: Data Loss When You Use the Save Method with adPersistADTG and adUseServer Q317913 KB317913 April 6, 2004
• 314639 BUG: Access Violation Occurs When You Open a Recordset with a Different Lock Type Q314639 KB314639 April 6, 2004
• 314635 FIX: "Catastrophic Failure" Error Message When You Use adPromptAlways to Connect to SQL Server 2000 Q314635 KB314635 April 6, 2004
• 294168 BUG: Memory Leak in OLE DB Provider for SQL Server When It Is Loaded and Unloaded Multiple Times Q294168 KB294168 April 6, 2004
• 245485 PRB: Load From Stream Fails When Specifying MSPersist Provider Q245485 KB245485 February 24, 2004
• 286245 PRB: Error Updating Records Using DB2OLEDB and Server-Side ADO Cursor Q286245 KB286245 February 16, 2004
• 296091 PRB: MFC AppWizard Does Not Show Oracle Synonyms with Microsoft ODBC Driver Q296091 KB296091 January 23, 2004