Run-time Error '3706' Provider cannot be found

Star007 · April 6th, 2006, 07:06 AM

hi,

the error msg is : Run-time Error '3706'
Provider cannot be found. It may not be properly installed.

I am having problem with my VB application. I was using sql server 2000 local on my pc with VB and it was working fine. NOw I have sql server 2005 express on a network pc.

when I changed the connection string for that, I am getting the above error

here is my connection string:

Dim cn As ADODB.Connection
    Set cn = New Connection
    cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
        "Persist Security Info=False;" & _
        "AttachDBFileName=" & App.Path & "\xstar_Data.mdf;Data Source=starsql\sqlexpress"
    cn.Open

please help me.

I try installing the latest mdac_tpe and vbrun60sp5.exe for VB

but no help.

please help?????????

***************

***************

pammyy · August 10th, 2006, 05:02 AM

Did you solve your problem yet?
I got the same error after implementing one of my VB app that connecting to SQL2005 using SQLNCLI provider. What version of MDAC do the machine need?
Please help.