急!!!ASP页面调用存储过程的问题!在线等!
tdaly 2005-03-24 04:57:24 我在ASP页面里写了如下代码:
Response.Expires = -1
Response.AddHeader "Pragma", "No-cache"
Response.AddHeader "Cache-Contorol","No-Cache"
Response.Buffer = True
set Emp_rs = Server.CreateObject("ADODB.Recordset")
set objCmd= Server.CreateObject("ADODB.Command")
set objCnn = Server.CreateObject("ADODB.Connection")
call Get_rs()
sub Get_rs()
dim strCnn
strCnn="Provider=MSDASQL.1;Password=otec;User ID=anken_use_v2;Extended Properties=""DSN=otec_it;UID=anken_use_v2;PWD=otec;SERVER=OTEC_172.17.85.160;"""
objCnn.open strCnn
objCmd.ActiveConnection=objCnn
objCmd.CommandType=adCmdStoredProc <------执行到这句,系统报错:引数错的形式,容许范围外,或竞争着
objCmd.CommandText="sp_getEmpList"
Set Emp_rs=objCmd.Execute()
objCmd.ActiveConnection=Nothing
set objCmd=Nothing
end sub
语法没有错,存储过程还没执行到,怎么会这样呢?