Solved

Error 3706: ADO could not find specified provider

Posted on 2000-04-26
5
319 Views
Last Modified: 2008-02-20
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
Comment
Question by:nfp30
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
AzraSound earned 30 total points
ID: 2752052
0
 

Author Comment

by:nfp30
ID: 2752124
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
 
LVL 28

Expert Comment

by:AzraSound
ID: 2752190
what errors are you getting?
0
 

Author Comment

by:nfp30
ID: 2752223
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
 
LVL 28

Expert Comment

by:AzraSound
ID: 2752236
youre quite welcome.  glad i could point you in the right direction.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question