Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2011-10-12
5
Medium Priority
?
6,824 Views
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
    .Open
  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.

-m3mdicl
0
Comment
Question by:m3mdicl
  • 3
  • 2
5 Comments
 
LVL 4

Expert Comment

by:GeoffHarper
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

0
 
LVL 4

Expert Comment

by:GeoffHarper
ID: 36957383
0
 

Author Comment

by:m3mdicl
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.
0
 
LVL 4

Accepted Solution

by:
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:

http://www.microsoft.com/download/en/details.aspx?id=15748

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.
0
 

Author Comment

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

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