發(fā)布日期:2017/9/26 9:49:59 訪問次數(shù):12151
mssql_datahost = "127.0.0.1" '數(shù)據(jù)庫地址
mssql_dataname = "dataname" '數(shù)據(jù)庫名稱
mssql_username = "sa" '數(shù)據(jù)庫用戶名
mssql_password = "123" '數(shù)據(jù)庫密碼
connstr = "Provider = Sqloledb; User ID = "&mssql_username&"; Password = "&mssql_password&"; Initial Catalog = "&mssql_dataname&"; Data Source = "&mssql_datahost&";"
Set conn = Server.CreateObject("ADODB.CONNECTION")
conn.Open connstr