奇怪问题,麻烦高手指点
<!-- #INCLUDE VIRTUAL="/adovbs.inc" -->
<%set conn=server.CreateObject("adodb.connection")
conn.Provider="sqloledb"
conn.open "User ID=sa;database=Sickness;Data Source=123.123.123.5"
set cmmd=server.CreateObject("adodb.command")
set rs=server.CreateObject ("adodb.recordset")
cmmd.ActiveConnection=conn
cmmd.CommandType=adCmdStoredProc
cmmd.CommandText="sp_sickness"
cmmd.Parameters.Append cmmd.CreateParameter("SicknessName",adChar,adParamInput,50)
cmmd.Parameters("SicknessName")=Request("SicknessName")
RS.CursorType=adOpenDynamic
RS.LockType = adLockOptimistic
'rs.CursorType=adOpenStatic
'rs.CursorLocation =3
RS.Open cmmd%>
存储过程是:
Create procedure sp_Sickness
@sicknessName char(50)
as
Select * from Sickness
where SicknessName=@sicknessName
为什么显示出错
<%=rs("SicknessAlias")%>
错误信息
Microsoft OLE DB Provider for SQL Server 错误 '80020009'
Errors occurred
而显示其他字段没问题(其他字段是char型,SicknessAlias为Text型)
请高手指点!!