Solved

Error 3706: ADO could not find specified provider

Posted on 2000-04-26
5
320 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

828 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