Visual Basic 6.0 Package and Deployment Wizard does not distribute MDAC 2.6 (310303)


The information in this article applies to:

  • Microsoft Visual Basic Professional Edition for Windows 6.0
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
  • Microsoft Data Access Components 2.8
This article was previously published under Q310303

SYMPTOMS

When your Visual Basic project references the Microsoft ActiveX Data Objects library, if you use the Package and Deployment Wizard (PDW) to build the installation package, the Package and Deployment Wizard includes the Mdac_typ.exe file to install Microsoft Data Access Components (MDAC) on the target computer. The Mdac_typ.exe is located in the following folder:

\Program Files\Microsoft Visual Studio\VB98\Wizards\PDWizard\Redist

However, every time you update MDAC, you do not guarantee that the Mdac_typ.exe file is also updated.

RESOLUTION

To distribute the correct Mdac_typ.exe file with your application, you must replace the version of Mdac_typ.exe in the \Program Files\Microsoft Visual Studio\VB98\Wizards\PDWizard\Redist folder with the correct version of that file.

MORE INFORMATION

You can use several methods to update MDAC on the development system. For example, you can use Visual Basic service packs or Microsoft SQL Server updates to update your version of MDAC. You can also download the latest version of the MDAC from the Web. However, none of these methods guarantee that the Mdac_typ.exe file is also updated.

When you install a Visual Basic service pack, the service pack may or may not update MDAC and the Mdac_typ.exe file. The following table outlines the behavior of the last three Visual Basic 6.0 service packs:

Visual Basic 6.0 Service PackIncludes MDAC UpgradeInstalls MDAC AutomaticallyUpdates Mdac_typ.exe
Service Pack 3Yes (MDAC 2.1)YesYes (2.1.1.3711.11)
Service Pack 4Yes (MDAC 2.5)NoYes (2.50.4403.12)
Service Pack 5Yes (MDAC 2.6)NoNo

If you use any method other than a Visual Basic service pack to update MDAC, the Mdac_typ.exe file is not updated automatically. You must manually copy the Mdac_typ.exe file in the above-mentioned folder for the version of MDAC that is installed.

To determine the version number of a file, follow these steps:
  1. Open Microsoft Explorer.
  2. Browse to the following folder:

    \Program Files\Microsoft Visual Studio\VB98\Wizards\PDWizard\Redist

  3. Right-click Mdac_typ.exe, and then click Properties.
  4. Click the Version tab. The file version appears at the top of this tab.
The following table lists the file versions for the Mdac_typ.exe file and its associated MDAC version.
MDAC VersionMdac_typ.exe File Version
MDAC 2.04.71.1015.0
MDAC 2.121.1.3711.11
MDAC 2.525.0.4403.121
MDAC 2.65.0.2920.0
MDAC 2.727.0.7713.4
MDAC 2.828.0.1022.0

REFERENCES

For additional information about how to distribute and install MDAC with a Visual Basic application, click the article numbers below to view the articles in the Microsoft Knowledge Base:

217754 HOWTO: Control Which MDAC Version the Package and Deployment Wizard (PDW) Distributes

213846 INFO: Deploy Database Applications with the Package and Deployment Wizard (PDW)

231943 INFO: Microsoft Data Access Components (MDAC) Release History

Modification Type:MajorLast Reviewed:1/18/2005
Keywords:kbAppSetup kbDeployment kbprb kbwizard KB310303
©2004 Microsoft Corporation. All rights reserved.