"Provider can't be found" Message 1

[DK47]

I have created an investment tracking program on VB6. It has been debugged, saved and executed.
No problems occured when I packaged and deployed (to a directory for burning to CD's). The setup program worked fine when it was installed on my PC and the program worked as it should.
I tranferred the three files (.CAB, .LST, EXE) to my son's PC, his machine, like mine, his is running Windows XP Pro.
His installation went well with no error messages but when the program starts and when each form is loaded we get a message "Provider can't be found".
I have checked all my references and am quite sure they are all set properly. I used ADO controls and connected them to the Jet data base. Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\VISUAL BASIC FILES\PROGRAMS\INVEST-TRACK\NEWINVESTMENTS.mdb
It seems to me that the data base may not be setting up on the user's machine. How can I tell if this is so?
When I package the project should I use the "Add File" button to add the data base "mdb" file? Shouldn't the wizard find it and include it? If it did include it should it be listed in the Support sub-directory?
I have tried everything I can think of, any help or suggestions will be greatly appreciated.
Thanks
Dwight (DK47)

 

[BobRodes]

If the provider can't be found, the problem is not with setting up the db, it's with finding the proper dll. Your problem is probably with the version of provider you are using. Access 2000 and XP won't run with the OLEDB 3.51 provider; you need to have version 4.0. You should be able to just change the provider part of your string to oledb.4.0 instead of 3.51. If that doesn't work on your machine, you need to install the VS service pack 5.

Although you didn't say which versions of Access you're working with, I expect that your machine has an older version of access than your son's.

HTH

Bob Rodes

 

[DK47]

Bob Rodes,
Thank you very much.
I'll give this a try and let you know how it works.

Dwight (DK47)

 

[DK47]

Bob,
I changed all the ADO connection references to the Jet 4 as you suggested.
As before the program runs on my PC but not my son's.
I went to Microsoft and downloaded VS6SP5 and ran the setup.
What do I do now???
I could find no difference in my Visual Studio directories. Does this Service PAck 5 just install the .dll's that I need?
Thanks again for all your help so far.
Dwight (DK47)

 

[CCLINT]

What OS is your son running?

You will need to install MDAC 2.5 onto the second computer (your VB SP5 installed it to your system, so do a file search on Mdac_typ.exe). If the computer has a higher MDAC version already installed, then download and install the Jet 4 service pack for the OS in question:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q239114

This will update and register the Native Jet 4 dbms along with DAO 3.6 and the ADO OLEDB JET 4 provider.

 

[DK47]

CCLINT,
Thanks, I'll try this later today and post results.
DK47

 

[DK47]

CCLINT'
I included the MDAC_TYP.exe file in the installation folder.
When I clicked it before trying the installation, it installed my application. Was that supposed ot happen?

By the way, we still got he provider could not be found error.

Isn't the Packaging Wizard supposed to gather all the files required? Why is it not doing it?
Thanks,
DK

 

[CCLINT]

The MDAC goes into the VB\PDWizard\Redist folder where your VB6 program is.

P&D will then automatically include this.

Did you download the service pack for JET and install it on the 2nd PC?

http://www.microsoft.com/downloads/...65-2bab-4ae5-b001-42840473ef39&DisplayLang=en

And, see if the registry key exists (use START-RUN-Regedit:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0

 

[DK47]

CCLINT,
I just FTP'd the Jet 4 pack to my son's computer. He is going to execute it shortly and check to see if this finally works.


OK Great news. It works.

I have placed the Jet Pack and the MDAC_TYP files in the REDIST folder of Visual Basics wizard directory.

Thank you so very much.
Dwight

 

[JonJacobik]

Just a note to say thanks. I've fought a very similar problem for about 3 weeks. . .following your directions exactly solved the last problem I had before shipping. .

Thanks again.

Jon Jacobik
Donna Halper & Associates
Results2K3 Music Scheduling System

 

[barryna]

I need a provider string that will work with an Access 2 database. Yes, that right, Access 2. Old stuff, but we need to be able to plug into it with ADO. 3.51 isn't old enough.

What is the connection string I need on an ADODC data control in order to plug into an Access 2 database? A connection in code is different than the connection string on the data control.

Nick