ASP安裝SQL資料庫和匯入資料和建立使用者

<%
'on error resume next
action=request("action")
IF action<>"install" THEN
%>
<BR>
<center>
<form method="POST" action="install.asp?action=install" name="form1">
填寫安裝資訊<BR><BR>
SQL資料庫管理員：<input name=StrUid value=sa><BR>
SQL資料庫密　碼：<input name=StrSaPwd value=40104529><BR>
SQL資料庫地　址：<input name=StrServer value=localhost><BR><BR>
<input name="cmdok" type="submit" class="form1" value="開始安裝..." >
</form>
</center>
<%
Else
StrUid=request("StrUid")
StrSaPwd=request("StrSaPwd")
StrServer=request("StrServer")
call CreateDB("info")
call RestoreDB("info","backup1.bak")
call CreateUser("bin","85228522","info")
response.write "<center><br><BR><input type='button' value='安裝完成！' onclick='javascript:windows.close()'></center>"
End if
'step1 建立資料庫
Sub CreateDB(StrDBName)
Dim Conn '資料庫連接
Dim StrDSN '資料庫連接字串
Dim StrCmd '命令字串
StrDSN="driver={SQL server};server="&StrServer&";uid="&StrUid&";pwd="&StrSaPwd&";database=master"
'建立和資料庫master的串連
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open StrDSN
'建立一資料庫
StrCmd="CREATE DATABASE "&StrDBName
Conn.execute(StrCmd)
Conn.Close
Set Conn=Nothing
End Sub
'step2 匯入資料
sub RestoreDB(StrDBName,fromBak)
SQL="Restore database " & StrDBName & " from disk='"&Server.MapPath(fromBak)&"'"