The information in this article applies to:
SUMMARYThere are two ways that you can install the Microsoft Data Access Components (MDAC) 1.5 components (ODBC 3.5, OLE DB 1.5, ActiveX Data Objects [ADO] 1.5, Remote Data Service [RDS] 1.5). The first way is the MDAC Standalone setup, which contains run-time components, samples, documentation, headers and libraries. The second way is the MDAC Redistribution, which contains just the run-time components. The MDAC Redistribution is bundled two ways. One MDAC Redistribution package contains just the SQL Server ODBC Driver (plus MDAC 1.5 run-time components) and is 1.7 MB in size. The second bundle adds the Microsoft Access and Oracle ODBC Drivers and is almost 4 MB in size.
MORE INFORMATIONThe MDAC Standalone setup was originally created as part of the setup for the Windows NT 4.0 Option Pack. As such, it uses a setup technology that is operating system dependent. That is, you cannot run the Windows 95 version of the MDAC Standalone on Windows NT, and vice versa. Further, the MDAC Standalone setup requires that you apply both OLE Automation and the Comctl32.dll patches on the target computer before running the setup. The MDAC Redistribution also requires OLE Automation.
Developers are often concerned about the size of the redistribution. MDAC Redistribution is at minimum 2 MB smaller than the MDAC Standalone. The bulk of the MDAC Redistribution's size is not in ADO or RDS (which are only about 500K of the total compressed size), but in ODBC and the ODBC drivers. mdacfull /q /C:"setup /QN1" The following switch runs Acme setup in the unattended mode and not automatically restart with a minimalist UI. mdacfull /q /C:"setup /QNT" With this feature, there is no significant reason why you should use the MDAC Standalone over the MDAC Redistribution. The redistribution is smaller, does not install SDK elements, and does not have as many external dependencies. Steps to Use Unattend.txt
The MDAC Standalone setup is a setup within a setup. The outer setup provides one file for the entire distribution, which is unpacked and includes a file called Dagsasu.inf. The inner setup, when called, uses both Sysocmgr and Dagsasu.inf to install the MDAC 1.5 components.
Steps to Use Unattend.txt Without a Reboot
Contents of Unattend.txt[Version] Signature = "$CHICAGO$" ; Choose one of the following, for the appropriate OS: ; Signature = "$CHICAGO$" for W95 ; Signature = "$Windows NT$" [Global] FreshMode = Custom MaintanenceMode = AddRemove UpgradeMode = AddExtraComps ; Syntax: ; FreshMode = [ Minimal | Typical | Custom ] ; ; NOTE: FreshMode is used if the registry does not contain the ; HKLM\Software\Microsoft\DataAccess\Version key. ; ; NOTE: If the computer is in FreshMode, but no "FreshMode=" line is ; specified, then Typical is the default value. ; ; MaintanenceMode = [ AddRemove | ReinstallFile | ReinstallComplete | ; RemoveAll ] ; ; NOTE: MaintenanceMode is used if the registry contains the ; HKLM\Software\Microsoft\DataAccess\Version key, and the value matches ; the current version of the MDAC setup. ; ; NOTE: If the computer is in MaintanenceMode, but no "MaintanenceMode=" ; line is specified, then ReinstallComplete is the default value. ; ; UpgradeMode = [ UpgradeOnly | AddExtraComps ] ; ; NOTE: UpgradeMode is used if the registry contains the ; HKLM\Software\Microsoft\DataAccess\Version key, and the value is less ; than the current version of the MDAC setup. ; ; NOTE: If the computer is in UpgradeMode, but no "UpgradeMode=" line is ; specified, then UpgradeOnly is the default value. ; ; WARNING: Do not manually modify the ; HKLM\Software\Microsoft\DataAccess\Version ; key - An incorrect value could result in an improper or unusable ; installation. [Components] ; Syntax: <sub-component name>=[ ON | OFF ] ; ; NOTE: The [components] section is used to control which files ; will be installed. It is used only when: ; * FreshMode = Custom or ; * MaintanenceMode = AddRemove or ; * UpgradeMode = AddExtraComps ; ; NOTE: It may not be possible to turn certain components OFF due to ; dependencies and/or the previous installed state of MDAC components. MDAC_ADO_CORE = ON ; MDAC_ADO_CORE is required, and contains ODBC, OLE DB, and ADO core ; files. MDAC_ADO_DOC = ON ; MDAC_ADO_DOC add HTML Help for ADO. MDAC_RDS_CORE = ON ; MDAC_RDS_CORE adds the Remote Data Services. MDAC_RDS_DOC = ON ; MDAC_RDS_DOC adds HTML Help for Remote Data Services (RDS). MDAC_RDS_SAMPLE = ON ; MDAC_RDS_SAMPLE adds RDS samples. MDAC_RDS_11 = ON ; MDAC_RDS_11 adds the RDS 1.1 release. MDAC_DRV_BRAZOS = ON ; MDAC_DRV_BRAZOS adds the JET database engine and the Microsoft Access ; ISAM and ODBC Drivers. MDAC_DRV_SQLSRV = ON ; MDAC_DRV_SQLSRV adds the SQL Server ODBC driver. MDAC_DRV_ORACLE = ON ; MDAC_DRV_ORACLE adds the Microsoft ODBC driver for Oracle. This is how you determine which components install in an unattended installation. If you do not want to install the Oracle driver change the Oracle driver line as follows: MDAC_DRV_ORACLE = OFF ; MDAC_DRV_ORACLE adds the Microsoft ODBC driver for Oracle. Remember, test these on a clean computer, as the install changes to maintenance mode if you are installing over a previous setup.
REFERENCESThis article is one of a series dealing with the redistribution of MDAC components; ODBC, OLE DB, ADO, RDS, the MDAC Standalone, MDAC Redistribution and the Data Access SDK. The white paper "Redistributing Microsoft Data Access Components" presents a comprehensive overview of this subject, including referencing the content of this Knowledge Base article. This white paper is located at the following Web address:
For more information on using the MDAC Redistribution, please see the following article in the Microsoft Knowledge Base:
For more information on acquiring the OLE Automation patch, please see the following article in the Microsoft Knowledge Base:
For more information on acquiring the Comctl32.dll patch, please see the following article in the Microsoft Knowledge Base:
Additional query words: Silent Install Keywords : kbcode kbHTMLHelp kbMDAC kbGrpMDAC kbDSupport kbMDAC150 kbMDAC210SP2 Version : WINDOWS:1.5 Platform : WINDOWS Issue type : kbhowto |
Last Reviewed: September 28, 1999 |