MDAC 2.5 SDK - Technical Articles


 

MDAC 1.0

The MDAC 1.0 release is now obsolete and is no longer generally available.

MDAC 1.0 Release Details

The following table describes two important releases of the OLE DB 1.x SDK.

Release Release date Major components
OLE DB 1.0 SDK August 1996
  • ODBC 2.5

  • ODBC Drivers
    • Access

    • Excel

    • Paradox

    • SQL Server

    • Text

    • Visual FoxPro

    • xBase
  • Jet ISAM Drivers
    • Excel

    • Paradox

    • Red (Jet)

    • Text

    • xBase
  • OLE DB 1.0 (new)

  • OLE DB Providers
    • ODBC (new)
  • ADO (preview)

  • ADOR (new)

  • OLE DB SDK (includes ADO and ADO/R SDK)
OLE DB 1.1 SDK December 1996
  • ODBC 3.0

  • ODBC Drivers
    • Access

    • Excel

    • Paradox

    • SQL Server

    • Text

    • Visual FoxPro

    • xBase
  • Jet ISAM Drivers
    • Excel

    • Paradox

    • Red (Jet)

    • Text

    • xBase
  • OLE DB 1.1

  • OLE DB Providers
    • ODBC
  • ADO 1.0 (new)

  • ADC (was ADOR)

  • OLE DB SDK (includes ADO and ADC)

MDAC 1.0 Release Manifests

The following table lists all of the modules that were distributed with each release, not including setup modules, sample files, and SDK tools. Version numbers in boldface indicate an update or new component. Empty cells in the table indicate that module did not ship with that release of MDAC. This is not a complete list of the files that must be redistributed; see the section in this article titled Redistributing MDAC for more information.

File Versions

Module OLE DB 1.0 SDK OLE DB 1.1 SDK
ctl3d32.dll 2.30.0.0  
dbnmpntw.dll 1996.7.15.0 1996.11.1.0
ds16gt.dll 2.10.23.23 3.0.23.1
ds32gt.dll 2.50.30.6 3.0.23.1
mfc40.dll 4.1.0.6038 4.1.0.6038
mfc42.dll   4.2.0.6068
msadc10.exe   4.71.121.0
msadcb10.dll   1.0.1211.0
msadcc10.dll   1.0.1211.0
msadcf10.dll   1.0.1211.0
msadco10.dll   1.0.1211.0
msadcs10.dll   1.0.1211.0
msader10.dll 0.99.0.826 1.0.0.994
msado10.dll 0.99.0.826 1.0.0.994
msador10.dll   1.0.0.995
msadrs10.dll 0.99.0.819  
mscpxl32.dll 2.65.2.1 2.65.2.1
msdadc.dll 1.0.2026.0 1.10.2326.0
msdaenum.dll 1.0.2026.0 1.10.2326.0
msdaer.dll 1.0.2026.0 1.10.2326.0
msdaerr.dll 1.0.2026.0 1.10.2326.0
msdasql.dll 1.0.2026.0 1.10.2326.0
msdasqlr.dll 1.0.2026.0 1.10.2326.0
msdatl.dll 1.0.2026.0 1.10.2326.0
msdatt.dll 1.0.2026.0 1.10.2326.0
msexcl35.dll   3.50.3428.0
msjet35.dll   3.50.3428.0
msjint32.dll 3.0.0.2712  
msjint35.dll   3.50.3428.0
msjt3032.dll 3.0.0.2809  
msjter32.dll 3.0.0.2712  
msjter35.dll   3.50.3428.0
mspdb41.dll 4.10.0.6038 4.10.0.6038
mspdox35.dll   3.50.3428.0
mspx3032.dll 3.0.0.2504  
msrd2x32.dll 3.0.0.2504  
msrd2x35.dll   3.50.3428.0
mstext35.dll   3.50.3428.0
mstx3032.dll 3.0.0.2504  
msvcirt.dll   4.20.0.6164
msvcprj.dll 4.10.0.6038 4.10.0.6038
msvcrt.dll   4.20.0.6164
msvcrt20.dll 2.11.0.0  
msvcrt40.dll 4.10.0.6038 4.10.0.6038
msvcshl.dll 4.10.0.6038 4.10.0.6038
msvcsrc.dll 4.10.0.6038 4.10.0.6038
msxb3032.dll 3.0.0.2504  
msxbse35.dll   3.50.3428.0
msxl3032.dll 3.0.0.2517  
mtxdm.dll   1996.11.27.137
odbc16gt.dll 2.50.30.6 3.0.23.1
odbc32.dll 2.50.30.6 3.0.23.1
odbc32gt.dll 2.50.30.6 3.0.23.1
odbcad32.exe 2.50.30.6 3.0.23.1
odbccp32.cpl 2.50.30.6 3.0.23.1
odbccp32.dll 2.50.30.6 3.0.23.1
odbccr32.dll 2.50.30.6 3.0.23.1
odbcint.dll 2.50.30.6 3.0.23.1
odbcji32.dll 3.40.28.29 3.50.3428.0
odbcjt32.dll 3.40.28.29 3.50.3428.0
odbcstf.dll 3.0.21.27 3.0.23.1
odbctl32.dll 3.40.28.29 3.50.3428.0
odbctrac.dll   3.0.23.1
oddbse32.dll 3.40.28.29 3.50.3428.0
odexl32.dll 3.40.28.29 3.50.3428.0
odfox32.dll 3.40.28.29 3.50.3428.0
odpdx32.dll 3.40.28.29 3.50.3428.0
odtext32.dll 3.40.28.29 3.50.3428.0
oleaut32.dll 2.20.4049.1 2.20.4054.1
regsvr32.exe   4.0.0.0
sqlsrv32.dll 2.65.2.13 2.65.2.36
vbajet32.dll 2.0.0.5924 3.0.0.6824
vbar2232.dll 2.0.0.5924  
vbar332.dll   3.0.0.6824
ven2232.olb 2.0.0.5924  

MDAC 1.0 Release Notes

The first major release of MDAC wasn't exactly a major release. It wasn't even called MDAC, and it wasn't a single release. Before MDAC 1.0, the ODBC SDK had existed for several versions and over several years. The first version shipped in September 1992. The ODBC SDK continued to be a separate product until version 3.5 in April 1998. Meanwhile, Microsoft released the OLE DB 1.0 SDK in August 1996, which began to point the way toward an integrated MDAC version. Later in 1996, the MDAC 1.0 stack was released through a variety of distribution mechanisms. However, centralized and coordinated MDAC did not arrive until version 1.5.

ODBC 3.0 shipped with the ODBC 3.0 SDK (available at the time by Web download) as well as with Internet Information Server 3.0 and the OLE DB SDK. The ODBC SDK was not included with the OLE DB SDK, although redistributable files from the ODBC SDK were included to support the OLE DB Provider for ODBC. The only ODBC driver installed by the ODBC 3.0 SDK was the SQL Server Driver. ODBC drivers for Microsoft® Access or Oracle were available only as part of development products such as Microsoft Visual Basic®, Microsoft Visual C++®, and Microsoft Access 97.

The OLE DB SDK contained the earliest versions of most of the components that form the current version of MDAC: ODBC, OLE DB, and ADO. OLE DB 1.1 and ADO 1.0 shipped with the OLE DB 1.1 SDK, which was available with Microsoft Visual Studio® 97 or by Web download, and with Internet Information Server 3.0. The Advanced Data Connector (ADC), which is now part of ADO, shipped with Internet Information Server 3.0 as well as being available on the Web as a downloadable cabinet (.cab) file. The ADC used a subset of the ADO Recordset and was generally independent of ADO.

ODBC 3.0 was tested and supported on Microsoft Windows NT® 3.51 and 4.0 and on Microsoft Windows® 95. OLE DB 1.1, ADO 1.0, and ADC 1.0 all were tested and supported on Windows NT 4.0 and Windows 95. However, these products have dependencies that prevent them from being supported on Windows NT 3.51.

Besides being distributed on the Web, MDAC 1.0 was also distributed through two other Microsoft products: Microsoft Active Server Pages (ASP), which was included with Microsoft Internet Information Server (IIS) 3.0 and Microsoft Visual InterDev® 1.0, and through Microsoft Visual Studio 97. These products integrated the MDAC components into their own setup programs.

In Microsoft Visual Studio 97, individual products installed different versions of ODBC and potentially OLE DB and ADO. Visual Interdev, for example, included ASP, which installed ODBC 3.0, OLE DB 1.1, and ADO/ADC 1.0. However, Microsoft Visual Basic 5.0 installed ODBC 2.65 and did not install OLE DB or ADO/ADC components. Microsoft Visual C++ 5.0 installed ODBC 2.65 and included the option to install the OLE DB 1.5 SDK, which provided the entire MDAC 1.0 stack.

Redistribution of ADC 1.0, and later 1.1 components, was accomplished by a .cab file installation. However, in some scenarios it was impossible to upgrade from ADC 1.0 to 1.1 because of registry problems with the .cab files.

MDAC 1.0 Redistribution Notes

Neither release of the OLE DB SDK contained a redistributable setup program. Redistribution instructions were partially documented in the installed doc folder, in the file sdkguide.hlp under the topic titled "Redistributable Components." These instructions did not make it clear enough that if you distribute either OLE DB or ADO, you must also distribute the other.