|
Subject:
|
Run-time Error '3706' Provider cannot be found. It
|
|
Posted By:
|
Star007
|
Post Date:
|
4/5/2006 4:53:34 PM
|
hi,
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?????????
***************
|
|
Reply By:
|
Star007
|
Reply Date:
|
4/5/2006 4:55:46 PM
|
the error msg is : Run-time Error '3706'
Provider cannot be found. It may not be properly installed.
***************
|
