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","backup\1.bak")
call CreateUser("bin","85228522","info")
response.write "<center><br><BR><input type='button' value='安裝完成！' "
Conn.execute(StrCmd)
conn.close
set conn=nothing
End sub
%>