SQLserver

<i><b>Originally posted by : zidane2 (hokalun@sinaman.com)</b></i><br /> if i use the SQL server to store data to run ASP, what SQL connection<br />statement is within the code of XXX.asp.<br />that mean set conn........<br /> set as..........<br />any other statement<br />please specify<br />thank you<br /><br /><br /><br />

<i><b>Originally posted by : steve</b></i><br />strconn = "Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;UID=L oginID;PWD=Password;DATABASE=Database_Name<br />set conn = server.createobject("adodb.connection")<br />conn.open strconn<br /><br />here is a dsn-less connection. you also can use a dsn entry and just pass it that.<br /><br />steve<br /><br /><br />------------<br />zidane2 at 3/26/2000 3:32:48 AM<br /><br /> if i use the SQL server to store data to run ASP, what SQL connection<br />statement is within the code of XXX.asp.<br />that mean set conn........<br /> set as..........<br />any other statement<br />please specify<br />thank you<br /><br /><br /><br />