Microsoft KB Archive/203905

-

The information in this article applies to:


 * Microsoft Data Access Components version 2.0
 * Microsoft OLE DB Provider for SQL Server, version 7.0
 * Microsoft OLE DB Provider for ODBC, version 2.0
 * ActiveX Data Objects (ADO), version 2.0

-

SUMMARY
Service Pack 1 for Microsoft Data Access Components (MDAC) Version 2.0 is available with the Windows NT 4.0 Service Pack 4. Service Pack 1 includes the MDAC core components, ActiveX Data Objects (ADO), Remote Data Service (RDS), OLE DB, and ODBC. The Service Pack also ships an update to the Microsoft Access ODBC Driver and the OLE DB Provider for Jet (as well as the Jet engine). It does not include either the SQL Server OLE DB Provider or Oracle OLE DB Providers found in MDAC version 2.0.

NOTE: MDAC 2.0 Service Pack 1 is intended just for users of Windows NT 4.0 SP4, and is not to be redistributed.

MORE INFORMATION
The Microsoft Data Access Components (MDAC) comprise a package of components integrated to provide a complete data access solution. These components have been developed and tested together to ensure the most reliable data access for the customer.

ALL COMMUNICATIONS OR CONVEYANCES OF INFORMATION TO YOU CONCERNING MICROSOFT AND THE YEAR 2000 REFLECTS INFORMATION THAT IS CURRENTLY AVAILABLE AND SUBJECT TO CHANGE AT ANY TIME WITHOUT NOTICE. ALL SUCH INFORMATION IS PROVIDED TO YOU PURSUANT TO THE TERMS AND CONDITIONS SET FORTH AT MICROSOFT'S YEAR 2000 WEBSITE LOCATED AT http://microsoft.com/year2000. MICROSOFT THEREFORE RECOMMENDS THAT YOU CHECK THE YEAR 2000 WEBSITE REGULARLY FOR ANY CHANGES TO ANY MICROSOFT YEAR 2000 STATEMENT. ALL SUCH INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND PROVIDED AS A YEAR 2000 READINESS DISCLOSURE.

MDAC 2.0 SP1 and Year 2000 Compliance
MDAC 2.0 SP1 is for year 2000 remediation of Windows NT SP4. Per the license agreement of MDAC 2.0 SP1, you cannot redistribute MDAC 2.0 SP1 except to computers that have Windows NT 4.0 SP4 already installed.

Use the following steps to acquire further year 2000 compliance information:

  Navigate to the following Web site: "http://www.microsoft.com/technet/topics/year2k/default.htm" Select "Product Guide" (which is listed both on the main page, as well as under "Year 2000" in the menu on the left side of the Web page). On the Product Guide page, scroll down to the section labeled "Compliance Information for Microsoft Products", and find the Microsoft Products list box. Within the list box, scroll down to the section labeled "Data Access".

Currently, there is Year 2000 Compliance information posted under "Data Access" for the following data technologies: ADO, DAO, RDS, Microsoft OLE DB, ODBC Core Components, and the Microsoft Oracle ODBC Driver. Microsoft continues to update this technology list and plans to add Y2K information for the following versions of MDAC:

MDAC 1.5

MDAC 2.0

MDAC 2.0 Service Pack 1

MDAC 2.1

Bug Fixes Found in MDAC 2.0 SP1
The following hot fixes are available for MDAC 2.0 and are included with MDAC 2.0 SP1:

  Conflict between ADO 2.0 and Internet Information Server (IIS) 3.0.

For additional information, please see the following article in the Microsoft Knowledge Base:

"Q193310 FIX: ADO 2.0 Generates Error 0115 When Used with IIS 3.0" When opening a rowset (or ADO Recordset), the OLE DB Provider for ODBC would reserve a block of memory 64K times the size of a single row. This memory would be released correctly, but the size of the allocation can help memory become overly fragmented.  When opening a server side, Keyset cursor with the SQL Server Provider, a hash table is created for holding bookmark values for all the rows in the opened rowset. This size was reduced from 64K to 1K.

For additional information, please see the following article in the Microsoft Knowledge Base:

"Q203726 BUG: OLE DB Provider for ODBC Allocates 64K Hash Table for Serve"</li></ul>

You can obtain NT version 4.0 SP4, and with it MDAC 2.0 SP1, from the following Web site:

http://support.microsoft.com/support/ntserver/content/servicepacks

Note: This Web site does require registration prior to access. If you are already registered you will be taken directly to this page.

MDAC 2.0 SP1 is available under the heading "Optional Components."

If you have installed Windows NT version 4.0 SP4 and have been directed to install MDAC 2.0 SP1, go to the Windows NT 4.0 Service Pack 4 License Agreement:


 * 1) Accept the license agreement. (You must accept the License Agreement to be able to download the Service Pack.)
 * 2) Click Year 2000 Service Pack 4 Download.
 * 3) Click Microsoft Data Access Components version 2.0 Service Pack 1 in the Optional Components section.

The Windows NT 4.0 Service Pack 4 License Agreement is located at the following URL:

"http://support.microsoft.com/support/ntserver/content/servicepacks/sp4_eula_128.asp" Additional query words: kbDSupport kbSweepNext kb2000 y2k kbcrossref

Keywords         : kbDatabase kbMDAC Version          : WINDOWS:2.0,7.0 Platform         : WINDOWS Issue type       : kbinfo Last Reviewed: August 9, 1999