OLEDB.3.51 error

[michelle]

Dear Vb users,

I am trying to open a database with the next instruction:

Dim ConnectDB As New ADODB.Connection
ConnectDB.Open ("Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=DATABASENAME.mdb")

This gives the next error: "ADO could not find the specified provider"

Can someone give me answer on the next questions:

- wich referenes do I have to choose?
- if I can't find, wich DLL file do I need?
- if I can't find the DLL file, where can I find this file on internet?

I am using VB5.

Thanks for reading or maybe answering.

Michelle.


[Edited by michelle on 08-22-2000 at 03:08 AM]

try installimg MDAC20 (VB6 CD1), MDAC21 (SP3) and MDAC25 (SP4) on your machine. I think MDAC20 is the one required for JET.OLEDB.3.51, but install all of it anyway.

another option could be using JET.OLEDB.4.0 drivers.

hope that helps, best regards

Sascha

[Edited by Sascha on 08-22-2000 at 05:09 AM]

[orasbot]

maybe Visual Basic 5.0 does not support ADO

[michelle]

Hello orasbot & Sascha for your information

Nice regards,

Michelle.

[Red Thread]

Hi there,

I have almost the same problem here !

Can you tell me if your problem is solved and if so... how did you did it ?