1) 10/1/2004 418820418820  418820.html">Some files in the Dllcache folder may not be updated when you run the Setup program for Microsoft Data Access Components
(418820) - Explains that, during the MDAC setup process, some files in the Dllcache folder may not be updated. To resolve this problem, upgrade your MDAC components to the latest version.

2) 9/28/2004 295194295194  295194.html">ADO help does not work if you reference ADO 2.6 object library in Access 2002
(295194) - Explains that you will see a blank help window if you try to bring up context sensitive Help for ADO 2.6 by pressing F1 since the ADO 2.6 help file is not included with the core MDAC 2.6 installation file.

3) 9/11/2004 883503883503  883503.html">FIX: You receive an "Invalid character value" error message when you use the bcp utility to import dates
(883503) - Explains that you may receive an error message when you try to import dates by using the bcp utility, and the day or the month contains one digit and the other contains two digits. Provides a list of files that are updated in the hotfix.

4) 9/3/2004 278872278872  278872.html">How To Specify Parameters for an XML Template Query from Visual Basic
(278872) - The functionality to specify parameters for a T-SQL or XPath query is provided by enhancements in ActiveX Data Objects (ADO) 2.6. This article presents a sample of how to specify parameters to a templated query against SQL Server 2000 from an MDAC 2.6...

5) 9/1/2004 234218234218  234218.html">How To Reuse ADO Connections Within MTS Transactions
(234218) - When you use a single ADODB Connection object multiple times within an MTS transaction, other ADO objects must be cleaned up after use. Also, client cursors should be used when possible. If ADO objects are not cleaned up properly, ADO may raise an...

6) 9/1/2004 229884229884  229884.html">How To Use OLE DB DBTYPE_VARNUMERIC
(229884) - When you use OLE DB with databases that support very large numeric types (for example, Oracle's NUMBER data type which supports up to 38 digits), OLE DB returns DBTYPE_VARNUMERIC as the column's data type. These large numbers can be stored and...

7) 7/20/2004 150716150716  150716.html">HOWTO: DAO: Attach to and Create QueryDefs on ODBC Tables
(150716) - This article describes how to attach and create Querydefs on external ODBC tables. The method for opening external ODBC tables is to attach the tables to an .mdb file. Jet does not support named QueryDefs on a non-attached ODBC database. A non-...

8) 7/16/2004 831832831832  831832.html">Oracle ODBC driver returns SQL_DECIMAL for all convert function calls
(831832) - Describes a fix for queries that are run on Oracle databases bz using the convert function and are not using the default Oracle convert type.

9) 7/15/2004 272165272165  272165.html">How To Use a Singleton SELECT from ASP
(272165) - This article demonstrates the use of a singleton SELECT to retrieve a single record from the SQL Server IRow interface from ASP.

10) 7/15/2004 240838240838  240838.html">How To Use the MSRemote Provider Through Client Script
(240838) - This article describes how to use the MSRemote provider to connect to and retrieve data from a remote database. The MSRemote provider allows the user to access OLE DB providers running on remote computers or in separate processes on the same computer....

11) 7/15/2004 875285875285  875285.html">TechNet Support WebCast: Known connectivity issues related to "General Network Error" error messages
(875285) - This Support WebCast session provides information about the most common issues that are known to cause "General Network Error" error messages in client-side applications when connecting to SQL Server.

12) 7/15/2004 836830836830  836830.html">FIX: Query performance declines when you use the SET FMTONLY Hint in the Microsoft ODBC Driver for SQL Server and the Microsoft OLE DB Provider for SQL Server
(836830) - Fixes the performance of the SET FMTONLY Transact-SQL query hint.

13) 7/15/2004 192857192857  192857.html">How To Use Index Files with Offline Views
(192857) - The introduction of Offline views in Visual FoxPro 5.0 enabled users to work with selected data sets while disconnected from the server. Use of indexes and functions that take advantage of Rushmore Optimization provide a highly efficient method of...

14) 7/15/2004 194517194517  194517.html">How To Use Creatable ADO Recordsets in Visual FoxPro
(194517) - Often, you find a need for temporary storage for data. ADO 2. x enables you to create recordsets on the fly for this purpose.

15) 7/15/2004 174689174689  174689.html">HOWTO: Set a Primary Key to Updateable in a View
(174689) - By default, when creating a view on a table, any field with a primary key index is not marked as updateable. This article illustrates how you can mark the primary key as updateable through the View Designer, and programmatically.