Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers

Webmaster Forum / ASP / Database Access / July 2006



Tip: Looking for answers? Try searching our database.

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.
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"

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.