發布日期:2017/9/26 9:49:59 訪問次數:12416
mssql_datahost = "127.0.0.1" '數據庫地址
mssql_dataname = "dataname" '數據庫名稱
mssql_username = "sa" '數據庫用戶名
mssql_password = "123" '數據庫密碼
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的方法