给你个例子
<%
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = "dsn=sqlsvr;database=pubs;uid=sa;pwd=;"
cmd.CommandText = "{call mysproc}"
cmd.Execute
%>
<%
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = "dsn=sqlsvr;database=pubs;uid=sa;pwd=;"
cmd.CommandText = "{call mysproc}"
cmd.Execute
%>
Set conn = Server.CreateObject("ADODB.Connection")
DSNtemp="Provider= SQLOLEDB; Data Source=服务器名; Initial Catalog=数据库名; User ID=用户名; Password=密码"
conn.open DSNtemp
Set Cmd=server.CreateObject("Adodb.Command")
Cmd.ActiveConnection=conn
Cmd.CommandText="存储过程名"
Cmd.CommandType=4'adCmdStoredProc
cmd.prepared=true'
Cmd.execute
%>