INFO: JET and MDAC (Complete) Runtime Notes

[Desmond]

INFO: JET and MDAC (Complete) Runtime Notes

Document ID: IR02051

---

The information in this article applies to:

• Setup Factory 6.0

---

SUMMARY

This document provides development notes for the JET and MDAC (Complete) runtime module that is used with Setup Factory 6.0.

DISCUSSION

Module Description

All programs that utilize Microsoft's JET 4.0 Database Engine and Microsoft's Data Access Components (MDAC) require a set of core runtime files in order to run. When this runtime module is added to a Setup Factory 6.0 project, the appropriate core set of files for both JET and MDAC will be installed with your application.

The correct version of each component will be installed based on the target operating system. Below is a summary of the versions that will be installed on each operating system if they satisfy their minimum requirements. (For more information about the minimum requirements, see the Developer Notes section of this document.):

MDAC 2.6 SP2

Windows 95

MDAC 2.8

Windows 98, Windows ME, Windows NT 4.0, Windows 2000, Windows XP

JET 4.0 SP7

Windows 95, Windows 98, Windows ME, Windows NT 4.0

JET 4.0 SP8

Windows 2000, Windows XP, Windows Server 2003

Module Configuration

After installing the Setup Factory 6.0 JET and MDAC (Complete) runtime module, the following Microsoft components must be downloaded and placed in the following locations:

• MDAC 2.6 SP2 (MDAC_TYP.EXE) can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyID=8e5f816c-4918-4250-b8bd-3794582c9089&DisplayLang=en
  
  MDAC_TYPE.EXE (version 2.6) must be saved in the following directory:
  ...Setup Factory 6.0\Runtimes\JET and MDAC (Complete)\MDAC26\MDAC_TYPE.EXE
  
  
• MDAC 2.8 (MDAC_TYP.EXE) can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en
  
  MDAC_TYPE.EXE (version 2.8) must be saved in the following directory:
  ...Setup Factory 6.0\Runtimes\JET and MDAC (Complete)\MDAC28\MDAC_TYPE.EXE
  
  
• JET 4.0 SP7 for Windows 95, Windows 98, Windows NT 4.0 (Jet40SP7_9xNT.exe) and JET 4.0 SP7 for Windows ME (Jet40SP7_WMe.exe) can be downloaded from: http://support.microsoft.com/?KBID=282010
  
  Jet40SP7_9xNT.exe must be saved in the following directory:
  ...Setup Factory 6.0\Runtimes\JET and MDAC (Complete)\Jet40SP7_9xNT.exe
  
  Jet40SP7_WMe.exe must be saved in the following directory:
  ...Setup Factory 6.0\Runtimes\JET and MDAC (Complete)\Jet40SP7_WMe.exe
  
  
• JET 4.0 SP8 for Windows 2000 (Windows2000-KB829558-x86-ENU.exe), JET 4.0 SP8 for Windows XP (WindowsXP-KB829558-x86-ENU.exe) and JET 4.0 SP8 for Windows Server 2003 (WindowsServer2003-KB829558-x86-ENU.exe) can all be downloaded from: http://support.microsoft.com/?kbid=829558
  
  Windows2000-KB829558-x86-ENU.exe must be saved in the following directory:
  ...Setup Factory 6.0\Runtimes\JET and MDAC (Complete)\Windows2000-KB829558-x86-ENU.exe
  
  WindowsXP-KB829558-x86-ENU.exe must be saved in the following directory:
  ...Setup Factory 6.0\Runtimes\JET and MDAC (Complete)\WindowsXP-KB829558-x86-ENU.exe
  
  WindowsServer2003-KB829558-x86-ENU.exe must be saved in the following directory:
  ...Setup Factory 6.0\Runtimes\JET and MDAC (Complete)\WindowsServer2003-KB829558-x86-ENU.exe

If the above seven files are not in their proper directories, or if they are incorrect versions, the Setup Factory JET and MDAC (Complete) runtime support module will not work properly and/or your build will fail.

Developer Notes

The Setup Factory 6.0 JET and MDAC (Complete) runtime support module installs these components as a "whole." Therefore it will only install if the requirements of both components are met. If any requirement fails, neither component will be installed. The following minimum requirements are needed for a successful install of both MDAC and JET:

• Windows 95 with the Y2K Update and Internet Explorer 4.01 SP2 or later
• Windows 98 with the Y2K Update 2 and Internet Explorer 4.01 SP2 or later
• Windows 98 Second Edition
• Windows ME
• Windows NT 4 SP5 (or greater) and Internet Explorer 4.01 SP2 or later
• Windows 2000 SP3 (or greater) (Note: Service Pack 3 is required for Jet 4.0 SP8 on Windows 2000)
• Windows XP
• Windows Server 2003 (Note: MDAC 2.8 will not be installed on this platform because it is installed with the OS)
• Administrator permissions
• Approximately 28 MB (29360128 bytes) free disk space

Note: The module will check all of the above requirements except for the Windows Y2K Updates and available disk space needed. If you want your install to include the module size in its disk space calculation, you can add its value (in bytes) to the built-in variable %AdditionalDiskSpace% (See the built-in variables section of the Setup Factory 6.0 Command Reference for more information about this variable).

Error handling is not performed in the module. If any of its requirements are not met, the module components will simply not be installed. However a failure variable is automatically set so you can handle the situation how you wish. If all requirements are met, the variable %IRRequirementFail% will contain the value FALSE, however if any requirement fails, this variable will contain the value TRUE. The earliest point you can check this variable is on the BEFORE actions tab of your first screen. For example, you could display an "Abort" screen with its screen condition as %IRRequirementFail% = TRUE.

If both components are installed, there will be two reboots needed in order to complete the installation. MDAC will be installed with your application. Following the installation of MDAC, an MDAC reboot screen will be displayed, prompting the user to reboot their system. Upon reboot, the installation will continue with the installation of JET. Once JET is installed, a JET screen will display notifying the user that the installation is complete, but requires a final reboot.

The Setup Factory 6.0 JET and MDAC (Complete) runtime support module uses a series of custom variables to complete its installation. In order to avoid the corruption of their data, or yours, the following variables must not be used (modified) in any install that uses this module:

%IRRequirementFail%
%IRIsDCOMInstalled%
%IRUpdateJET%
%IRUpdateMDAC26%
%IRUpdateMDAC28%
%IRUpdateJET%
%IRMDACVersion%
%IRMSJETVersion%
%IRIEVersion%
%IRNTVersion%

MORE INFORMATION

There are a number of resources available on the Internet that you can use to find out more about Microsoft's Data Access Components and Jet Database Engine. Here are a few links:

• Release Manifest for MDAC 2.8 (2.80.1022.3): http://support.microsoft.com/?kbid=828396

• Release Manifest for MDAC 2.6 SP2 (2.62.7926.1 & 2.62.7400.1): http://support.microsoft.com/default.aspx?scid=/support/servicepacks/MDAC/2.6/SP2manifest.asp

• Information About Jet 4.0 Service Pack 8: http://support.microsoft.com/?kbid=829558

• How To: Find Information about Jet 4.0 Service Pack 7: http://support.microsoft.com/?KBID=282010

• How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine: http://support.microsoft.com/default.aspx?kbid=239114

• Data Access Downloads: http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

• MDAC Utility: Component Checker: http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

KEYWORDS: Setup Factory 6.0, JET, MDAC, Runtime Module

---

Last reviewed: November 28, 2003
Copyright © 2003 Indigo Rose Corporation. All rights reserved.