Microsoft Data Access Components (MDAC) 2.5 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.5 that have been released in Year 2004. The list is daily updated.

• 194206 FIX: Jet drivers do not support bitwise operators Q194206 KB194206 December 9, 2004
• 286381 PRB: ORA-0600 internal error when calling Oracle external stored procedures Q286381 KB286381 December 6, 2004
• 325172 Support WebCast: MDAC and ADO Review and What's New in MDAC 2.5 Q325172 KB325172 November 17, 2004
• 304578 INFO: What Happens When MDAC 2.5 SP1 or SP2 Is Installed Over MDAC 2.6 Q304578 KB304578 November 17, 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
• 147875 How To Use "DSN-Less" ODBC Connections with RDO and DAO Q147875 KB147875 August 30, 2004
• 196379 Xslatezp.exe Data Translation using JET as a Medium Q196379 KB196379 August 10, 2004
• 325180 Support WebCast: XML Data Access Development with MDAC 2.5 Q325180 KB325180 August 9, 2004
• 279882 SAMPLE: ODBCConfTool20.exe Obtains ODBC Driver Conformance Level Q279882 KB279882 August 9, 2004
• 197861 ADOCtl.Exe Demonstrates Active Documents, RDS and ADO Q197861 KB197861 August 9, 2004
• 193332 FILE: MDACCON.EXE Using Connection Strings with ODBC/OLEDB/ADO/RDS Q193332 KB193332 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
• 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
• 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
• 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
• 272165 How To Use a Singleton SELECT from ASP Q272165 KB272165 July 13, 2004
• 271494 How To Send Batch SQL Statements to Oracle Q271494 KB271494 July 13, 2004
• 266886 How To Use a Remote Data Service (RDS) Handler with an RDS Data Control Q266886 KB266886 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
• 194516 How To Use ADO Hierarchical Recordsets Q194516 KB194516 July 13, 2004
• 192857 How To Use Index Files with Offline Views Q192857 KB192857 July 13, 2004
• 191413 How To Use Offline ADO Recordsets in Visual FoxPro Q191413 KB191413 July 13, 2004
• 156061 How To Use the FoxPro SQLPrepare() Function Q156061 KB156061 July 13, 2004
• 155809 How To Use the SYS(3053) Function Handle with ODBC Q155809 KB155809 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
• 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
• 252767 How To Get XML Representation Of an ADO Recordset in Visual Basic Q252767 KB252767 July 1, 2004
• 245524 How To Ensure Jet 3.5 Is Installed Correctly (Part II) Q245524 KB245524 July 1, 2004
• 244040 How To Have Your ODBC Jet 3.5 and 4.0 Applications Co-exist Q244040 KB244040 July 1, 2004
• 240434 How To Improve Performance of Applications Using Jet 4.0 Q240434 KB240434 July 1, 2004
• 240377 How To Ensure Jet 3.5 Is Installed Correctly (Part I) Q240377 KB240377 July 1, 2004
• 225131 How To Implement Visual C++ COM Objects Returning Recordsets Q225131 KB225131 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
• 142216 How To Create ODBC Data Sources Using SqlConfigDataSource Q142216 KB142216 July 1, 2004
• 130507 How To Logical Values Must Be Sent to SQL Server as 1 or 0 Q130507 KB130507 July 1, 2004
• 297963 How To Change Logon Information for Access Linked Tables at Run Time with ADOX Q297963 KB297963 June 29, 2004
• 293823 How To Configure ADO to Ignore Duplicates During a Bulk Insert into an Access Database Q293823 KB293823 June 29, 2004
• 291017 How To Change an Access Table Name Programmatically Q291017 KB291017 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
• 200190 How To Call a Parameterized Query to an Access Database with ADO Q200190 KB200190 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
• 254822 ACC2000: Find Dialog Box or Find Methods Jump to Incorrect Record in Linked ODBC Table Q254822 KB254822 June 28, 2004
• 254816 ACC2000: Like "String*" Criteria Is Incorrect on Indexed (Duplicates OK) Fields That Have DBCS Characters Q254816 KB254816 June 28, 2004
• 196333 PRB: Not Null Field Returns Error Using VFPODBC SQL Insert Q196333 KB196333 June 28, 2004
• 306435 PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60 Q306435 KB306435 June 25, 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
• 829744 FIX: Non-localized version of the sqlsrv32.dll file is installed during the installation of the MS03-033 security update Q829744 KB829744 May 27, 2004
• 320744 PRB: Incorrect NUMERIC and DECIMAL conversions with non-English locales Q320744 KB320744 May 25, 2004
• 314639 BUG: Access Violation Occurs When You Open a Recordset with a Different Lock Type Q314639 KB314639 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
• 293876 FIX: Memory Leak When You Use Now Function in SQL with Jet 4.0 Provider or Driver Q293876 KB293876 January 6, 2004