ADO Provider not found - Please Help!

[KellyM]

I have written an application that works with an Access database. The app. works fine on the system I wrote it on, however when I run it on a different computer I get the following message.
Note: I have installed MDAC-2.5 on the system that is giving me trouble.


Run time error '3706'
Provider cannot be found. It may not be properly installed.

Q. Once the provider is installed and the system re-started is their anything else I have to do?

Any help would be appreciated

Thanks
Kelly

[funkyd77]

Are you sure that the "Microsoft Access (*.mdb)" driver has been installed (by looking in ODBC administrator),

and also if you are using DSNs to access the database have they also been setup on the target pc? (also can be done through ODBC administrator or can be automated on install).

See, from your problem i would have answered that you need to install mdac, but since you have done that i'm a bit stuck...what platform is it (winnt/win98/win95) running on.

I had probs with an app where mdac was run but it was done so by a "user" on an NT system so it couldn't register everthing properly - this resulted in a difference between the versions of the specific drivers (like the access driver) and the ODBC administrator which apparently caused problems.

[Gen-X]

Another thing to check is that your Connection String expressly states at the start "Provider=sqloledb;"

If it isn't there it tries to use a default which might be different from your machine to the other one.

[KellyM]

I am using the following code to connect to access database:

ConnectDB.Open ("Provider = Microsoft.Jet.OLEDB.3.51;Persist Security Info = False;Data Source=c:\ecgman\data.mdb")
recDB.Open "Table1", ConnectDB, adOpenKeyset, adLockOptimistic

Both systems are running winnt 4.0

and under ODBC datasources in control panel MS Access 97 database is listed with driver.

any ideas??

Kelly

[funkyd77]

OK, i had a quick search for runtime error 3706 on the web and found some site that was talking about problems between version 3.51 and version 4 of the Jet oledb provider. I didn't read all of the posts but there was a fair bit of info there...

It was a forum type site so i had to register (username etc like on here) but i can give you the link to it, and you could do the same:

http://japan.experts-exchange.com/Co..._10193747.html