View Single Post
  #1 (permalink)  
Old April 5th, 2006, 04:53 PM
Star007 Star007 is offline
Authorized User
Join Date: Aug 2004
Location: toronto, ontario, Canada.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Star007
Default Run-time Error '3706' Provider cannot be found. It

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.

please help?????????