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"
please help me.
I try installing the latest mdac_tpe and vbrun60sp5.exe for VB
but no help.