Learn how to a build a cloud-first strategyRegister Now


Run-time error 3706: Provider cannot be found.  It may not be properly installed.

Posted on 2011-10-12
Medium Priority
Last Modified: 2012-05-12
Hi Everyone!

I'm having a run time error 3706 on my test machine with an application made from VB6 with SQL Server 2005 database.

Below is the connection string I am using.

Public Sub Open_Connection()
  Set con = New ADODB.Connection
  With con
    .ConnectionString = "Provider=SQLNCLI;Server=xx.xxx.xxx.xx\instance;Database=myDbase;Uid=admin; Pwd=myPword1234;"
    .CommandTimeout = 0
    .CursorLocation = adUseClient
  End With
End Sub

Open in new window

On my developer's machine there's no problem connecting.  Any ideas?

Any help is greatly appreciated.

Question by:m3mdicl
  • 3
  • 2

Expert Comment

ID: 36957307
If you don't have them, you'll need to install SQL Server drivers on your test machine.

Try this:

.ConnectionString = "Driver={SQL Server};Server=xx.xxx.xxx.xx\instance;Database=myDbase;Uid=admin; Pwd=myPword1234;"

Open in new window


Expert Comment

ID: 36957383

Author Comment

ID: 36957425
Thanks for the quick response.  

Is there any other way or workaround not to install that drivers or MDAC on the test machines?
Because I will deploy that app to like 20 computers.

Is there something i can do with the connection strings?

Or if there's no other way, is it possible to create an installer that will install that SQL drivers and MDAC automatically on the client PC?

Let me know what you think guys.  Thank you.

Accepted Solution

GeoffHarper earned 2000 total points
ID: 36957615
You can leave the code as is and install the SQLNCLI client on the test machine from here:


If you get that far and still have problems make sure the Windows Firewall on the test machine doesn't get in your way to connect.

Author Comment

ID: 36963060
Thanks for the help guys I guess that's the only way to make it work.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

810 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