The following is a list of troubleshooting steps to follow if you are having MDAC setup issues.
- Shut down all Windows NT services and Windows applications that are using MDAC.
When you run MDAC setup it installs new data access DLLs and also updates existing system DLLs. If one or more of these DLLs is in use by an application, it can lead to unsuccessful MDAC setup. Before running the MDAC setup program Mdac_typ.exe, close all applications that use MDAC with Windows NT services and close all applications on the computer. This is the number one reason that Microsoft Product Support Services has determined can cause MDAC setup to fail. In many cases, simply closing all applications and services using MDAC and re-running the MDAC installer will properly configure MDAC after a failed setup. The following Microsoft applications and services use MDAC components:
- Certificate Server
- Exchange Server
- Internet Explorer
- Internet Information Server
- Microsoft Office (All Office Applications)
- Outlook and Outlook Express
- SNA Server
- SMS Server
- SQL Server
- Visual Studio (All Development Products)
Note that the earlier list details the most common products that use MDAC. For best results, close all user applications before running MDAC.
To completely make sure that no MDAC DLLs are in use on the system, you can run a popular third-party utility called ListDLLs which is available from the following Web site: http://www.sysinternals.com
Using the search facility in this utility, search for Odbc32.dll, Oledb32.dll, and Msado15.dll. Any process that is using one of these DLLs is using MDAC components and should be closed prior to installing MDAC.
- Make sure that you are logged on as an Administrator on Windows NT and Windows 2000.
NOTE: On computers running Windows 95, Windows 98, and Windows Millennium Edition computers, this step does not apply. In order to properly install DLLs and create registry settings, the MDAC installer requires that you are logged in with Administrator privileges on a Windows NT computer. Failure to do so may result in a failed MDAC setup, because MDAC will not have the proper security privileges to write DLLs to the system folder or make registry changes.
You may see the following error messages:
Setup Error 168 - Setup has encountered a problem updating your system registry
Insufficient Privileges - You do not have sufficient privileges to install here
- Disable any anti-virus or disk security software applications running on the computer.
Many anti-virus and disk security software applications run memory resident programs that can interfere with the installation of other software. Before installing MDAC, temporarily disable any anti-virus and disk security software applications running on the computer.
- Ensure you have adequate hard drive space to install MDAC MDAC requires at least 40 MB of free hard-drive space in order to install correctly.
Note that MDAC installs files into the Program Files folder as well as into the system folder (Windows\System on a Windows 95, Windows 98, or Windows Millennium Edition-based computer or WinNT\System32 on a Windows NT computer). In most cases, these folders will be located on the C: drive, but the folders can be set up on any drive on the computer.
- Make sure you have a valid TEMP folder defined and that there is adequate space on the TEMP drive. (TEMP Drive refers to a drive where TEMP Folder is.)
When the MDAC installer starts running, it extracts all of the MDAC files into the TEMP drive defined on your system. Therefore you will need at least 40 MB of free hard-drive space on the drive where TEMP resides. You can determine the location of your TEMP drive by opening up a MS-DOS command prompt and entering SET and then clicking Enter. A list of environment variable settings should appear and in the list you should see TEMP= and TMP= followed by a folder location such as C:\TEMP or C:\WINDOWS\TEMP. The TEMP folder listed must exist and be located on a drive with at least 40 MB of free space.
- Make sure that Windows 95 computers have DCOM95 installed.
All Windows 95 computers need to have DCOM95 installed before running MDAC setup. You can download DCOM95 from the following Web location:
http://www.microsoft.com/com/resources/downloads.asp
Make sure that you fully install DCOM95 and restart the computer before attempting to install MDAC.
- Install MDAC from a mapped drive on Windows 95 computers.
There have been reported cases where installing MDAC from a UNC path has failed on Windows 95 computers. Map a network drive or copy the MDAC installer locally before installing on Windows 95.
 Back to support FAQ
E-mail This Page
Printer Friendly Version
|
