Connection String of SQL 2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We upgrade our database from 2000 to 2005.

So I use the new connection string in our newly developed web app.

"Provider=SQLNCLI;Server=server_ip;Database=db_name;UID=username;PWD=password;"

I got this error:
The 'SQLNCLI' provider is not registered on the local machine

I want to know, if I use OLEDB in my asp.net, is it necessary to use the
Native Client drive?
 
Hi Jason,

I think Provider=SQLOLEDB; should work, too.
Why don't you create a connection string using Server Explorer and see the
result.
 
Back
Top