Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.open "Driver={SQL Server};Server=sm;Database=date;Uid=sia;Pwd=123456;"
set rs=server.CreateObject("adodb.recordset")
rs.open"select * from smhl",3,3
response.write rs("sh")运行后显示参数类型不正确,或与其它类型冲突..这是什么原因?????谢谢
MyConn.open "Driver={SQL Server};Server=sm;Database=date;Uid=sia;Pwd=123456;"
set rs=server.CreateObject("adodb.recordset")
rs.open"select * from smhl",3,3
response.write rs("sh")运行后显示参数类型不正确,或与其它类型冲突..这是什么原因?????谢谢
rs.open"select * from smhl",3,3
//后面的参数是否用对,查查资料
rs.open"select * from smhl",MyConn,3,3
//这里可能要对数据集做个判断是否到了末尾,若无数据,会出错的
response.write rs("sh")
dim myconn,connstr,rs,sql
Set myconn=Server.CreateObject("ADODB.Connection")
connstr="Driver={SQL server};Server=sm;Database=date;UID=sia;PWD=123456"
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from smhl"
myconn.open connstr
rs.open sql,myconn,3,3
while no rs.eof
response.write rs("sh")
rs.movenext
wend
rs.close
set rs=nothing
set myconn=nothing
%>