Pease help! - ADO Question

[KellyM]

I`ve just written an application that works with an Access 97 database file.
When I try to run it on a different computer other than the one I wrote it on I get the following message...
Run time error '3706'
ADO could not find the specified provider.


Can anybody help me?


Kelly

[mlewis]

You may need to register the data source via the ODBC icon in Control Panel. Make sure to use the same DSN name as the one on the original machine.

[KellyM]

I still seem to get the same message. Have I missed anything with my code...

'To initialize database.

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


Thanks

Kelly

[mattbrown]

You don't have Microsoft Data Access Components (MDAC) installed on the other computer.

MDAC contains the Jet Database engine that your code is trying to use.

Get MDAC from

[url]www.microsoft.com/data[url]

Under the ADO section.

I believe the current release is MDAC2.5 which uses Jet 4.0 but it is compatible with previous version as far as I can determine.

Hope this helps

[KellyM]

Thanks for your help guys...

I noticed that the lastest MDAC release is for windows 2000.
Will I run into problems with NT4.0 and win98.

Thanks
Kelly

[mattbrown]

My understanding is that it is compatible with all platforms from 95+, I run MDAC 2.4 on my Win95 box with no problems. MDAC 2.5 was released with Win2000 so therefore it gets labelled with it but will work fine elsewhere as well.

I believe you can still download MDAC 2.4 if you prefer however.

[KellyM]

I still seem to be having trouble. I installed MDAC 2.5 and received the following error message...

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


Apart from running the installation program, does anything else have to be changed? ie. controll panel, registery??


Thanks
Kelly

I believe you would have to install the same version of MDAC as referenced in your project.

[Bregalad]

Looks like you need MDAC20 to be able to use Jet 3.51

http://support.microsoft.com/default...;en-us;Q197902

[JazzBass]

Hi Kelly,

Why don't you install MDAC 2.5 on your system (Development)first, then reference the 2.5 library for your program, change your connection string, and reinstall your app.

That should get it running. Good call on the knowledgebase article.

JazzBass