ADO connection to MS Access problem

[Giraffe69]

I'm building an application in VB6 on NT4 using the ADO (MDAC version 2.7) to pull data from a MS Access 97 DB. The provider string im using is "Microsoft.Jet.OLEDB.4.0". When I open the connection it works fine on some machines here but on others I'm getting the errors:

"3706 - ADO could not find the specified provider."
or
"3706 - Provider cannot be found. It may not be properly installed."

All the machines have Access 97 installed, and have MDAC 2.7 or higher. I found a good article on updating the Microsoft Jet 4.0 Service Pack (

http://support.microsoft.com/kb/239114/)

but, on the machines here, there doesnt seem to be a good relationship between the service pack version (some have different versions of msjet40.dll, some msjet35.dll, and others none at all) and the errors generated - although I could be wrong!

Has anybody come across this before? Any advice would be appreciated!

 

[AGIMA]

Yes I have come across this and the problem was different version of the MDAC on the computers, even through all of them were the same (I was told they were the same). I manually went around and check the version on each of the files on the affected machines and the machines that worked.

We then created a setup application to apply all the same DLL and once this was deployed every thing worked a well.

Not the answer that you wanted to hear i bet.



AGIMA - professional web hosting is our business.

AGIMA Computing

http://www.agima.com.au