How to query SQL Server 2005 in ASP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

XY Li - 21 Jul 2006 15:05 GMT

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=UserName;PWD=User
Pas?sword;" right?

Thanks.

Reply to this Message

Bob Barrows [MVP] - 21 Jul 2006 15:33 GMT

> Hi,
> We are moving over to SQL Server 2005.
[quoted text clipped - 7 lines]
>
> Thanks.

www.connectionstrings.com

Signature

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"

Reply to this Message

Webmaster Forum / ASP / Database Access / July 2006

How to query SQL Server 2005 in ASP