VB6/ADO/JET

Scenario: VB6 app using ADO runs 100% on development box (Win98). Likewise, compiled and installed on the development box runs 100%.
First thing the app does is access an Access97 database via hard-coded connection string. When app is run on test machine (Win98) it bombs when trying to open the db.

Error message is #3706 - ADO could not find the specified provider.

Latest versions of jet35sp3, jet40sp3, DCOM98, and MDAC have been applied.

Any suggestions will be highly appreciated. Thanks in advance.

Addendum:
Connection string is: "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=c:\datafolder\databasename.mdb"

[L Finch]

I have had a similar problem myself, use the "DRIVER=Microsoft Access Driver (*.mdb)" instead of the provider, works every time!!


Example from my conection:

.ConnectionString = "DRIVER=Microsoft Access Driver (*.mdb);" & _
"DBQ=c:\datafolder\databasename.mdb;Exclusive = 0;ReadOnly = 1"