How to query SQL Server 2005 in ASP

Hi,
We are moving over to SQL Server 2005.

Could anyone give me a simple code to connect SQL Server 2005 in ASP.

What's the connection string?
Is
"Provider=SQLNCLI;Server=127.0.0.1;Database=dbName;UID=UserN ame;PWD=User
Pas­sword;" right?

Thanks.








*** Sent via Developersdex http://www.developersdex.com ***

Re: How to query SQL Server 2005 in ASP

XY Li wrote:
> Hi,
> We are moving over to SQL Server 2005.
>
> Could anyone give me a simple code to connect SQL Server 2005 in ASP.
>
> What's the connection string?
> Is
> "Provider=SQLNCLI;Server=127.0.0.1;Database=dbName;UID=UserN ame;PWD=User
> Pas­sword;" right?
>
> Thanks.
>
www.connectionstrings.com

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"