Microsoft Data Access Components (MDAC) 2.5 articles, fixes and updates - letter H

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 starts with letter H that have been released. The list is daily updated.

• 301202 How to check for MDAC version Q301202 KB301202 August 20, 2020
• 248255 How to use the ADO recordset, record and stream objects to open documents Q248255 KB248255 June 10, 2019
• 276488 How To Use the ADODB.Stream Object to Send Binary Files to the Browser through ASP Q276488 KB276488 June 9, 2019
• 175261 How To Retrieve Bitmap from Access and Display It in Web Page Q175261 KB175261 April 22, 2018
• 195951 How To Query and Update Excel Data Using ADO From ASP Q195951 KB195951 April 20, 2018
• 173308 How To Display Images Stored in a BLOB Field Q173308 KB173308 April 20, 2018
• 228843 How To Implement Session Pooling from Visual Basic ADO Program Q228843 KB228843 January 11, 2015
• 196384 How To Perform Bulk Inserts Using SQLSetPos Q196384 KB196384 January 7, 2015
• 870669 How to disable the ADODB.Stream object from Internet Explorer Q870669 KB870669 June 20, 2014
• 194678 How to use SQL Server identity, OLE DB templates, and OLE DB for ODBC in Visual C++ Q194678 KB194678 December 27, 2013
• 229919 How To Retrieve a Recordset from an Oracle Stored Procedure Using ADO on ASP Q229919 KB229919 July 18, 2012
• 293312 How to obtain the latest MDAC 2.5 service pack Q293312 KB293312 July 4, 2007
• 255084 How To Troubleshoot an ASP-to-Oracle Connectivity Problem Q255084 KB255084 June 14, 2007
• 217754 How To Control Which MDAC Version the Package and Deployment Wizard (PDW) Distributes Q217754 KB217754 May 17, 2007
• 315823 How To Execute Distributed Transaction Using ODBC API with SQL Server Q315823 KB315823 February 23, 2007
• 237844 How To Enable ODBC Connection Pooling in a Visual Basic ADO Application Q237844 KB237844 February 15, 2007
• 233539 How To Programmatically Reset the Compatibility Level Setting of SQL Server ODBC Driver Version 3.70 Q233539 KB233539 November 23, 2006
• 231812 How To Programmatically Set the Compatibility Level of the SQL Server ODBC Driver Q231812 KB231812 November 23, 2006
• 150552 How to avoid the ODBC login dialog box when using MFC in Visual C++ Q150552 KB150552 November 21, 2006
• 137814 How to use predefined queries that take parameters and do not return a result set with the MFC ODBC classes Q137814 KB137814 November 21, 2006
• 127734 How to make sure that the ODBC.DLL and the ODBCCURS.DLL have the same cursor level in Visual C++ Q127734 KB127734 November 21, 2006
• 126131 How to speed up the applications that use the Access ODBC driver Q126131 KB126131 November 21, 2006
• 119064 How To Retrieving a List of All ODBC Data Sources Q119064 KB119064 November 21, 2006
• 295646 How To Transfer Data from ADO Data Source to Excel with ADO Q295646 KB295646 August 23, 2006
• 249819 How to pass a timestamp value to or from SQL Server with ODBC API Q249819 KB249819 July 31, 2006
• 195082 How to use ADO disconnected and persisted recordsets Q195082 KB195082 July 6, 2006
• 166279 How To Lifetime of a COM Component Under IIS, ASP, and RDS Q166279 KB166279 May 10, 2006
• 175426 How To Populate a Combobox from Active Server Pages Q175426 KB175426 May 2, 2006
• 165156 How To Determine Parameter Requirements for a Stored Procedure in ASP Q165156 KB165156 May 2, 2006
• 152534 How to use ODBC in an ActiveX control by using Visual C++ Q152534 KB152534 September 30, 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
• 200427 How To Export and Import Access Tables Using DAO or ODBC Q200427 KB200427 August 11, 2005
• 188713 How To Change Information in a Database from ASP Q188713 KB188713 August 11, 2005
• 195913 How To Generate ODBC & OLEDB Connection Strings with Data Links Q195913 KB195913 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
• 186086 How To Get a File DSN in the Connection Designer Q186086 KB186086 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
• 176086 How To Retrieve Recordsets from Oracle Stored Procedures Using ADO Q176086 KB176086 March 14, 2005
• 155392 How To Creating a Connection to SQL Server Without a Datasource Q155392 KB155392 March 14, 2005
• 150716 How To DAO: Attach to and Create QueryDefs on ODBC Tables Q150716 KB150716 March 14, 2005
• 150550 How To Obtain Windows 3.1/Windows 95 Btrieve ODBC Interface Q150550 KB150550 March 14, 2005
• 149882 How To Execute a Stored Procedure on an Oracle Server Q149882 KB149882 March 14, 2005
• 148406 HOWTO: How to Create a Microsoft Excel Remote View from Visual FoxPro Q148406 KB148406 March 14, 2005
• 146224 HOWTO: Use SQL Pass Through to Connect to ASCII Text Files Q146224 KB146224 March 14, 2005
• 142930 HOWTO: RDO: Use ODBC Escape Clauses in Your SQL Syntax Q142930 KB142930 March 14, 2005
• 138998 HOWTO: How to Use SQL Pass-Through to Send Results to a Table Q138998 KB138998 March 14, 2005
• 137944 HOWTO: How to Create a Remote Connection or View Programmatically Q137944 KB137944 March 14, 2005
• 176830 How To Create a Connection Programmatically Q176830 KB176830 March 11, 2005
• 195262 How To Delete ODBC Data Source Using SqlConfigDataSource Q195262 KB195262 March 7, 2005
• 191694 How To Add a User and Set User Privileges to SQL Server Q191694 KB191694 March 3, 2005
• 189918 How To Administer SQL Server Users from Visual FoxPro Q189918 KB189918 March 3, 2005
• 187720 HOWTO: How to Disable ODBC Login Prompt at Run-Time Q187720 KB187720 March 3, 2005
• 196084 How To Retrieve Foreign Key Information from SQL Server Q196084 KB196084 March 2, 2005
• 195526 How To Retrieve Primary Keys for SQL Server Tables Q195526 KB195526 March 2, 2005
• 190411 How To Bind a DataReport To an ADO Recordset at Run Time Q190411 KB190411 March 2, 2005
• 190371 HOWTO: Use Bound Controls with an ADO Recordset Q190371 KB190371 March 2, 2005
• 165671 HOWTO: Use ASP/ADO to Query an ODBC Datasource (SELECT) Q165671 KB165671 March 2, 2005
• 161288 How To Get More Information on the ODBC Call Failed Error Q161288 KB161288 March 2, 2005
• 191638 How To Programmatically Access the Registry in Visual FoxPro Q191638 KB191638 March 1, 2005
• 191502 HOWTO: Use Component Gallery to Build an Application Q191502 KB191502 March 1, 2005
• 187909 HOWTO: How to Prevent UI in an Out of Process Server Q187909 KB187909 March 1, 2005
• 165775 HOWTO: Set up a Visual FoxPro Internet Server Q165775 KB165775 February 24, 2005
• 134721 HOWTO: How to Handle Visual FoxPro Connectivity Errors w/o DBERROR() Q134721 KB134721 February 22, 2005
• 130506 HOWTO: Use AERROR() in Place of DBERROR() for ODBC Errors Q130506 KB130506 February 22, 2005
• 130463 HOWTO: How to Import Microsoft Access Data Q130463 KB130463 February 22, 2005
• 130137 HOWTO: How to Use ODBC to Run SQL SELECT on Microsoft Excel Data Q130137 KB130137 February 22, 2005
• 129847 HOWTO: How to Use the Upsizing (SQL) Wizard in Visual FoxPro Q129847 KB129847 February 22, 2005
• 174689 HOWTO: Set a Primary Key to Updateable in a View Q174689 KB174689 February 16, 2005
• 194434 HOWTO: Using the Setup Wizard in Visual FoxPro 6.0 Q194434 KB194434 February 11, 2005
• 133286 HOWTO: Use Microsoft Access Data in Visual FoxPro Q133286 KB133286 February 11, 2005
• 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
• 197916 How To Use GUIDs w/ Access, SQL 6.5 and SQL 7 Q197916 KB197916 August 5, 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
• 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
• 222831 HOWTO: Retrieving Numeric Data with SQL_NUMERIC_STRUCT Q222831 KB222831 December 5, 2003
• 179670 HOWTO: Specifying a Catalog Name with SQL Query Q179670 KB179670 October 15, 2003
• 151797 HOWTO: How To Create an SQL Outer Join Using the View Designer Q151797 KB151797 October 15, 2003
• 129399 HOWTO: How to Convert FoxPro 3.0 Tables to FoxPro 2.x Format Q129399 KB129399 October 15, 2003
• 321714 HOW TO: Use the SQLOLEDB "Preserve on Commit" and "Preserve on Abort" Dynamic Properties Q321714 KB321714 May 8, 2003