我编写了一个ASP程序用来执行存储过程,程序正常,但是IE老是提示错误。
我编写了一个ASP程序用来执行存储过程,程序正常,但是IE老是提示错误。
1 Set MyConn=Server.CreateObject("ADODB.Connection")
2 Set MyCommand=Server.CreateObject("ADODB.Command")
3 MyConn.Open "DSN=zfpdmlocal;SERVER=(local);UID=yuli;pwd=yuli;DATABASE=zfpdm"
4 Set MyCommand.ActiveConnection=MyConn
5 MyCommand.CommandType=adCMDStoredProc
6 MyCommand.CommandText="hitcunt"
7 Set myParam=MyCommand.CreateParameter ("returnCode",adInteger,adParamReturnValue )
8 MyCommand.Parameters.Append myParam
9 set rs=MyCommand.Execute
10 Response.Write myCommand("returncode")
ADODB.Command 错误 '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/asp_program/displayparams.asp, 行5