	AllExperts > Experts
	Search

Ask a question about Active Server Pages Programming (ASP)
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

About Jeff Allen
Expertise
I can answer basic to intermediate questions related to Classic ASP.I can answer Intermediate to Advanced questions CSS& HTML, and basic questions about JavaScript and Ajax. I can also answer questions related to web page accessibility under US Section 508.

Experience
I have 8 years experience with HTML. I have been developing in ASP, VBScript and CSS for two years each. I also currently work as web developer.

Organizations
IWA-HWG

Education/Credentials
I have a BA in English with minors in Web Design and Scientific and Technical Writing

You are here: Experts > Computing/Technology > Business Software > Active Server Pages Programming (ASP) > ASP with SQL Server

Topic: Active Server Pages Programming (ASP)

Expert: Jeff Allen
Date: 7/22/2006
Subject: ASP with SQL Server

Question
How to give the sql server database connection from asp programming in pc?

Answer
Do you mean how to construct the connections string?

If so, here's the standard SQL Server Connection string:
Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;

If you're asking how to use it to form a connection in a Classic .asp page then this would be an example:

<%
   Dim objConn, objRS, strConn, strSQL, Email_Number, Template
   strConn = "Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
   Set objConn = Server.CreateObject("ADODB.Connection")
   objConn.Open strConn
%>

Add to this Answer Ask a Question

About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.