Problems packaging a DLL using the Package and Deployment Wiz

[StevenWalsh]

<br>I am trying out a simple example of creating a COM component that will query a database and present the results in a format that an ASP page will present.<br><br>I have set a reference to the Microsoft ActiveX data objects 2.1 library within the project. This seems to work fine but when the package is deployed to an NT server and run it gives the following error message:-<br><br>An error occured while registering the file 'C:\winnt\system32\msado21.tlb'<br><br>I have no idea why it's not registering it does anyone have any pointers?

 

[Snaggs]

Steve,

ADO is packaged in MDAC (Microsoft Data Access Components). It usually goes under the name of MDAC_TYP.EXE. The latest version is 2.5 and can be downloaded from Microsoft at:

http://www.microsoft.com/data/download.htm

At the time of this posing, it looks like v2.1 is still available.

The problem you're most likely experiencing is that only part of MDAC or none of MDAC is installed on the target machine. Hence it can't reference the TypeLibrary. You may want to get a hold of the 2.1 component or upgrade your development machine to 2.5 and then install 2.5 on the target machine also.

If you're using the Microsoft Package and Deployment wizard, then you probably already have MDAC_TYP.EXE (v2.1) in your REDIST directory located in:

C:\Program FIles\Microsoft Visual Studio\VB98\Wizards\PDWizard\Redist

If you include MDAC_TYP.EXE in your P&D Wizard, the wizard will automatically do the install for you. The package is about 6.5 Meg, so your distribution size is going to increase.

Once you get the data access componets installed on the target machine, your install should be fine.