ASP 連接 MSSQL的方法

mssql_datahost = "127.0.0.1" '數(shù)據(jù)庫(kù)地址

mssql_dataname = "dataname" '數(shù)據(jù)庫(kù)名稱

mssql_username = "sa" '數(shù)據(jù)庫(kù)用戶名

mssql_password = "123" '數(shù)據(jù)庫(kù)密碼

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

上一文章：ASP 連接 ACCESS的方法

下一文章：怎樣解決IE“確實(shí)允許此網(wǎng)頁訪問剪切板嗎”提示