Question

急求ASP连接SQL SERVER的例子, 要简单点的,给个注释吧, 谢谢了!在线等

急求ASP连接SQL SERVER的例子, 要简单点的,给个注释吧, 谢谢了!在线等

Answer 1

set conn=server.createobject("ADODB.connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=myweb"

Answer 2

strconn = "Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;PWD=Password;DATABASE=Database_Name

set conn = server.createobject("adodb.connection")

conn.open strconn