connection to sql server

Hi,

Im using asp code. how to i connect to sql server. could anyone provide me the coding to connect. and how to setup the connection.Hi
You can find the resources Here or Here|||hi,

im using this coding for the connection to sql server

<%
Set demoConn = Server.CreateObject("ADODB.Connection")
demoPath="DRIVER={SQLServer};" & _
"SERVER=servername;UID=username;" & _
"PWD=password;DATABASE=database"
demoConn.open demoPath
%>

but still couldnt, is there any setup that i have to do. something like odbc setup or any else setup. thanks