设好后就可这样:
sConn = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID = yourID; Password = yourPWD;Initial Catalog = DBname;Data source = SQLserverName;"
set conn = Server.CreateObject("ADODB.Connection")
conn.open sConn
sConn = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID = yourID; Password = yourPWD;Initial Catalog = DBname;Data source = SQLserverName;"
set conn = Server.CreateObject("ADODB.Connection")
conn.open sConn
Application("ConString")="provider=SQLOLEDB;driver={SQL server};DSN=数据源 名;UID=用户名;pwd=密码;database=数据库名"
然后在要连接数据库的asp页面程序中写:
dim conn,rst,sql
set conn = server.CreateObject("adodb.Connection")
set rst = server.CreateObject("adodb.Recordset")
conn = Application("ConString")
sql = "select * from table"
rst.open conn
http://www.csdn.net/expert/topic/325/325698.shtm
帮我吧。