Problem after deploying application...

[EdRev]

After I had packaged and deployed my vb application on one of the user's PC, I got an error message when I tried to open the database through the application. The error message reads:

Run-time error "3706"
ADO could not find the specified provider

Is there anything that I missed during the packaging.

Any help will be greatly appreciated.

 

[RAtkison]

In the directory where the setup files are stored should be a file called mdac_typ.exe. For ADO to work properly on the users machine, this file must be installed.
Hope it works!
RKA

 

[EdRev]

thanks a lot for your immediate response. I checked the files that were created when I packaged the application. On one of the cabs, there was a file called mdac_type.exe.
I guess that file was installed (or should I do anything more with this file.)

thanks again.

 

[Beesknees]

Depends what database you were accessing and whether the client had that driver. Does this happen on all installations?

 

[EdRev]

my application is using an access database and the user has access installed in his PC. This is the first install that I did.

 

[Beesknees]

This is what microsoft has to say about this error:
3706 adErrProviderNotFound Provider cannot be found.
It may not be properly installed.
The name of the provider might be incorrectly specified, the specified provider might not be installed on the computer where your code is being executed, or the installation might have become corrupted.
Might just be the spelling or version of provider you have specified.

 

[EdRev]

I looked at my pdw LOGFILE and saw this entry:

"You have included mdac_typ.exe in your installation package. If you will be installing this package on a Windows 95/98 system, it will require DCOM98 to install properly."

Where can I get this DCOM98 and when I get it what do I do with it?

 

[RAtkison]

I always install the mdac_typ.exe file myself.
RKA

 

[Ophicleide]

Greetings:

You should also ensure that the version of MDAC_TYP.EXE that you compiled you VB project under (the one on your system) is the same as the one in you VB distribution folder (typically [your boot drive letter]:\Program Files\Microsoft Visual Studio\VB98\Wizards\PDWizard\Redist).

If you updated your system to 2.6 for example, your Product Deployment Wizard may still be distributing version 2.5. You can rename the old "MDAC_TYP.EXE" to "MDAC_TYP 2.5.EXE" for example and then place the 2.6 version in the folder.