PDA

Click to See Complete Forum and Search --> : ado could not find the specifiec provider


Bebe
Mar 26th, 2000, 05:30 AM
ado could not find the specified error is what i am getting

that's the error im receiving here is my code:

Set mCN = New Connection

With mCN
.ConnectionString = "Provider=Microsoft.jet.oledb.4.00;datasource='c:\my documents\people.mdb'"
.CursorLocation = adUseClient
.Open


does anyone have an ideas what the problem could be; i would appreciate any help.

i have mdac 2.1 installed

i was using the same provider but with 3.51 and received an isam error and then i changed it to 4.00; which is what i need it to be as i am using an access 2000 database.

Clunietp
Mar 26th, 2000, 06:49 AM
change datasource to data source

Clunietp
Mar 26th, 2000, 06:50 AM
Oh yeah, and Microsoft.jet.oledb.4.00 to Microsoft.jet.oledb.4.0

Bebe
Mar 26th, 2000, 07:01 PM
You were right on both accounts. I have to change recordsource to record source and 4.00 to 4.0 for to work and now it works!!!

thanks!!!