asked on

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

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

GeoffHarper

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

GeoffHarper

To get MDAC 2.8:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=5793

m3mdicl

ASKER

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.

ASKER CERTIFIED SOLUTION

GeoffHarper

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

m3mdicl

ASKER

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