INFO: Deploy database applications with the Package and Deployment Wizard (PDW)

Article translations Article translations
Article ID: 213846 - View products that this article applies to.
This article was previously published under Q213846
Expand all | Collapse all

On This Page

SUMMARY

The Microsoft Data Object Libraries may be referenced in your Visual Basic project. When the Package and Deployment Wizard (PDW) is used to build the installation, the PDW scans the project files and determines which dependency files need to be distributed.

This article provides the general information you need to distribute any of the following Data Object Libraries with your Visual Basic project:
  • Microsoft Data Access Objects (DAO) 3.51 Object Library
  • Microsoft Data Access Objects (DAO) 3.6 Object Library
  • Microsoft Remote Data Object (RDO) 2.0
  • Microsoft ActiveX Data Objects (ADO) 2.0, 2.1, 2.5, or 2.6 Library

MORE INFORMATION

The files are listed in the Setup's file that is created by the PDW for distribution.

For additional information on how each section in the Setup.lst file is used, click the following article number to view the article in the Microsoft Knowledge Base:
189743 Description of Setup.lst sections
The following sections describe points to be aware of when you distribute any of the Data Object Libraries.

Microsoft Data Access Objects (DAO) 3.51 Object Library

Intrinsic data control incompatibility with Microsoft Access 2000 (Jet 4.0)

If you use the intrinsic data control in your project and you attempt to connect to a Microsoft Access 2000 database, you may receive the following error message:
Unrecognized Database Format
This error message occurs because the DAO generic data control is based on Jet 3.51 and does not recognize Jet 4.0 database formats. Access 2000 is a Jet 4.0 format database. Prior to Microsoft Visual Studio 6.0 Service Pack 4 (SP4), the workaround for this problem was to open a recordset with DAO code, and then assign it to the recordset property of a data control. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
238401 PRB: Unrecognized database format error message when upgrading to Access 2000
This problem does not exist with the data control that ships with Microsoft Visual Studio 6.0 Service Pack 6.

Visual Studio 6.0 Service Pack 6 can be obtained at the Visual Studio 6.0 Service Pack Web site:
http://msdn2.microsoft.com/en-us/vstudio/aa718364.aspx

Jet 3.51 OLE DB Provider is not included in MDAC 2.1 or later

The Jet OLE DB Provider requires the version number of the provider in order to connect to an Access database. If your application specifies Version 3.51 of the Jet OLE DB provider in a connection string or a UDL, and you install ADO by redistributing MDAC 2.1, you are likely to receive the following error message:
3706: ADO could not find the specified provider
This error message occurs because MDAC 2.0 installs version 3.51 of the Jet OLE DB provider while MDAC 2.1 installs version 4.0 of the Jet OLE DB Provider, but does not install version 3.51. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
197902 PRB: Jet 3.51 OLE DB Provider is not installed with MDAC 2.1 or later

Microsoft Data Access Objects (DAO) 3.6 Object Library

DAO version 3.6 is required for applications that use DAO to read and write to Access 2000 databases. If Access 2000 (or DAO 3.6) is already installed on the destination computer, then no additional steps are required. If it is not, it is necessary to distribute DAO 3.6. However, there is currently no redistributable for DAO 3.6. In order to redistribute DAO 3.6, it is necessary to install DCOM, redistribute MDAC 2.1(GA) or later, and ensure that the DAO DLL is also distributed and registered on the destination computer.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
233002 How to redistribute DAO 3.6

Microsoft Remote Data Object (RDO) 2.0

In order for RDO to be properly distributed and installed, ODBC must already be installed on the destination computer. ODBC can be installed through the odbcst32.exe file, which is located in the ODBC Folder under the SQL/i386 directory on Visual Basic 6.0 Disk 2. ODBC can also be installed by including the MDAC redistributable in the distribution that is outlined in the "References" section covering distributing ADO/MDAC. To determine all of the files needed to distribute for RDO to work successfully on a computer that does not have Visual Basic installed, you can generate a dependency (.dep) file with the Package and Deployment Wizard. To generate a dependency file that shows the files needed for RDO when running the PDW, complete the following steps:
  1. Create a Standard EXE project in Visual Basic. Form1 is created by default.
  2. Add a reference to Microsoft Remote Data Object 2.0.
  3. Save this project and run the Package and Deployment Wizard on it.
  4. Select the Package option.
  5. On the Package Type, choose Dependency File, and then proceed through the wizard to completion.
When you are finished, you have a file with a .dep extension that can be opened with Microsoft Notepad. MSRDO20.dll and its dependencies are shown in this file.

You want to ensure that these files are included with the distribution. If these files are not listed on the Included Files dialog box when you run the Package and Deployment Wizard, include them by clicking Add in the dialog box.

Microsoft ActiveX Data Objects (ADO) 2.0, 2.1 or 2.5 Library

The PDW does not distribute mdac_typ unless there is a specific reference to an ADO Library (any version) in the project.

You can also add mdac_typ.exe manually by clicking Add in the Included Files dialog box when you run the Package and Deployment Wizard. The wizard uses the MDAC_Typ.exe file in the ...\Wizards\PDWizard\Redist folder. Obtain the MDAC Components at the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/data/aa937695.aspx
For additional information how the PDW distributes MDAC, click the following article number to view the article in the Microsoft Knowledge Base:
217754 How to control which MDAC version the Package and Deployment Wizard (PDW) distributes
The installation of Microsoft Data Access Components (MDAC) requires that DCOM be already installed on the destination computer: If DCOM is not already installed on the destination computer, you may receive one of the following error messages:
Unable to load file 'msdadc.dll' to register it
-or-
DLL registration failed
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
191704 PRB: Unable to load file to register it during setup

REFERENCES

For additional information on distributing and installing MDAC/ADO, click the following article numbers to view the articles in the Microsoft Knowledge Base:
255986 PRB: Improper installation of MDAC may return error at run time
184265 How to distribute ADO with the VB5 Application Setup wizard
For additional information on Data Report in distributed applications, click the following article number to view the article in the Microsoft Knowledge Base:
248055 BUG: Run-time error 713 opening data report in distributed app
For additional information on distributing the DAO JET Engine, click the following article numbers to view the articles in the Microsoft Knowledge Base:
192934 PRB: Error "The Jet VBA file...Failed to initialize when called"
240377 How to insure Jet 3.5 is installed correctly (Part I)
245524 How to insure Jet 3.5 is installed correctly (Part II)
214854 Improved ODBC datatype mappings with Jet 4.0
197110 ACC2000: References that you must set when you work with Microsoft Access
For additional information on DAO to ADO migration, click the following article number to view the article in the Microsoft Knowledge Base:
225048 Issues migrating from DAO/Jet to ADO/Jet
For additional information on PDW, click the following article numbers to view the articles in the Microsoft Knowledge Base:
190173 How Setup Wizard and PDW compare file versions and dates
178354 How Setup Wizard and PDW use dependency files

Properties

Article ID: 213846 - Last Review: May 17, 2007 - Revision: 3.3
APPLIES TO
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
Keywords: 
kbdeployment kbfaq kbfix kbhowto kbinfo kbprb kbrdo KB213846

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com