• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

Error 3706: ADO could not find specified provider

I receive the following when I try to install my project on someone else's computer: Error 3706: ADO could not find specified provider.  What could be causing this and how do I fix it?  This is urgent.  Please be specific in any fixes that are offered.  Thanks.


Private Sub Form_Load()
'On Error Resume Next
On Error GoTo Err1

Dim DBE As DBEngine
Set DBE = DBEngine

If Dir(App.Path & "\eits2.mdb") <> "" Then Kill App.Path & "\eits2.mdb"


DBE.CompactDatabase App.Path & "\eits.mdb", App.Path & "\eits2.mdb"


If Dir(App.Path & "\eits.mdb") <> "" Then Kill App.Path & "\eits.mdb"

   

Name App.Path & "\eits2.mdb" As App.Path & "\eits.mdb"

Err1:

Dim cn1 As ADODB.Connection
Set cn1 = New Connection

Dim cn2 As ADODB.Connection
Set cn2 = New Connection


cn1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source = " & App.Path & "\eits.mdb"
cn1.Open


On Error GoTo ErrHand

cn1.Execute ("Drop table Data_filter")

ErrHand:

sqlCreate = ("Select * into Data_filter from Data1")
cn1.Execute sqlCreate

sqlGet = "Select * from Data_filter"

cn2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source = " & App.Path & "\eits.mdb"
cn2.Open


Form1.Adodc1.ConnectionString = cn2
Form1.Adodc1.CommandType = adCmdTable
Form1.Adodc1.RecordSource = "Data_filter"
Form1.Adodc1.Refresh

End Sub
0
nfp30
Asked:
nfp30
  • 3
  • 2
1 Solution
 
nfp30Author Commented:
AzraSound,

I think you are right on target, however, being the newbie that I am, I'm having trouble implementing the fix.  When I change the connection string to OLEDB.4.0 I get errors (because I'm not using Windows 2000?).  Is there something else to change along with that?  Also, the other fix is to use MDAC 2.0 but the link they offered doesn't offer it anymore.  Can I specify MDAC 2.0 instead of MDAC 2.1 in the package and deployment wizard?
Thanks
0
 
AzraSoundCommented:
what errors are you getting?
0
 
nfp30Author Commented:
AzraSound,

I got a copy of MDAC 2.0 from the installation cd.  Thank you so much for your help.  It is working!
Thanks again.

nfp30
0
 
AzraSoundCommented:
youre quite welcome.  glad i could point you in the right direction.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now