createmdb.asp

来自「SmartCity远程数据库管理系统 本系统可使您不打开Microsoft A」· ASP 代码 · 共 17 行

<%
	dim mdbname,conn,connstr,sql
	mdbname = "testmdb"
	session("mdbname") = mdbname

   	connstr="Provider=Microsoft.Jet.OLEDB.4.0;" &_
	   	"Persist Security Info=False;" &_
	   	"Data Source=" & Server.MapPath("data/admin.mdb")
	set conn=server.createobject("ADODB.CONNECTION")
	conn.open connstr

	sql = "create schema testmdb authorization lismith"
	'conn.execute sql

	'response.redirect "tablelist.asp"
%>
<%=sql%>