Database & Package Wizard

Im at my wits end. I have an app that uses ADO, i.e. in code I have this:

set con = new ADODB.Connection
con.ConnectionString = "DRIVER=(Microsoft Access Driver (*.mdb));
DBQ=servicewizard.mdb; ..."
con.Open



The open method gives an error: "Class not registered"

I created the install for this app with the Package and Deployment Wizard. The install itself did get an error: "Unable to load file MSDADC.DLL to register it". Clicking OK (only option) continues the install. The app will then load the main frame; but running any option that has the above code in the form load gets the error mentioned above and then aborts.

Is there an ADO file missing or is there something just not registered? I feel that its probably a registration issue because I have installed it on 1 machine and it works fine but on another machine all these problems. The working machine likely already has the necessary things registered.

Why did the error occurr during the install? The install was created with the Package and Deployment Wizard.

If I run the mdac_typ.exe to install Microsoft Data Access 2.0 I get a message that the machine does not have and will need DCOM95 installed. Im not directly using DCOM anywhere and it seems that the wizard should include everything necessary to run the app.

Pleeeeeeese Help. I am completely stumped. I am not new to VB but this is the first Install that I have done.



Lee Barnard
Atlanta, GA

Add this line of code before all these you posted!!!:

dim con as ADODB.Connection



Make sure that you have checked at Project-References the Microsoft ActiveX Data Object 2.0!!!

P.S. Before installing mdaq_typ.exe you must install DCom98 first! Add these two files to the package installation...

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece

I do have the Dim in the appropriate place.

What files are you referring to to add to the package installation?

Lee Barnard
Atlanta, GA

Add these files:

1)MDAQ_TYP.EXE
2)DCOM98.EXE

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece