Connection String of SQL 2005

[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?

 

[Miha Markic [MVP C#]]

Hi Jason,

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