General discussion

Locked

VB60 - ACCESS 2000 - PROVIDER

By rraney ·
I am trying to use an Access 2000 database with VB60.
Public TheConnection as ADODB.Connection
Set TheConnection = New ADODB.Connection
TheConnection.CursorLocation = adUseClient
TheConnection.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source = <My Database>;"

Error 3706
ADO could not find the Specified Provider

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

VB60 - ACCESS 2000 - PROVIDER

by RWeight In reply to VB60 - ACCESS 2000 - PROV ...

I don't know if you've already done this, but to use the OLEDB4.0 provider, you must install MDAC release 2.1 or later. VB 6.0 SP3 included MDAC 2.0, but you need 2.1. You can download MDAC 2.1 from the Microsoft data site - http://www.microsoft.com/Data/MDAC21info/manifest_intro.htm

You can also use the MDAC 2.1 stack when using Access 97 databases as well.

Collapse -

VB60 - ACCESS 2000 - PROVIDER

by rraney In reply to VB60 - ACCESS 2000 - PROV ...

The question was auto-closed by TechRepublic

Collapse -

VB60 - ACCESS 2000 - PROVIDER

by whitney597 In reply to VB60 - ACCESS 2000 - PROV ...

Try this as your connection string:

DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=281
DefaultDir=<path to DB Dir>
DBQ=<MyDatabase>

You will need to insert the semicolons between items.

Collapse -

VB60 - ACCESS 2000 - PROVIDER

by rraney In reply to VB60 - ACCESS 2000 - PROV ...

The question was auto-closed by TechRepublic

Collapse -

VB60 - ACCESS 2000 - PROVIDER

by ckobman In reply to VB60 - ACCESS 2000 - PROV ...

The solution is kind of simple.
For some reason you have to add another period at the end of the provider string.

correct "PROVIDER=Microsoft.Jet.OLEDB.4.0."

wrong "PROVIDER=Microsoft.Jet.OLEDB.4.0"

Chad Kobman
ckobman@yahoo.com

Collapse -

VB60 - ACCESS 2000 - PROVIDER

by rraney In reply to VB60 - ACCESS 2000 - PROV ...

The question was auto-closed by TechRepublic

Collapse -

VB60 - ACCESS 2000 - PROVIDER

by rraney In reply to VB60 - ACCESS 2000 - PROV ...

This question was auto closed due to inactivity

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Software Forums