我检查到Recordset的RecordCount属性值为-1,但我能从Recordset中取出SQL执行后返回的数来.这是什么原因呢?
我测试的语句如下:
Set MyConn3=Server.CreateObject ("ADODB.Connection")
ls_driver = "{Microsoft ODBC for Oracle}"
ls_server = "people"
ls_uid="administrator"
ls_pwd="manager"
MyConn3.ConnectionString = "driver="&ls_driver&";server="&ls_server&";uid="&ls_uid&";pwd="&ls_pwd
MyConn3.Open
SqlString = "select * from p_base"
Set Rs4=Server.CreateObject ("ADODB.Recordset")
'Set Rs4=MyConn3.Execute(SqlString)
Rs4.Open SqlString,MyConn3
Response.Write Rs4("people_name")
Response.Write Rs4.RecordCount
Set Rs4=Nothing
我刚才又测了一下,我把配置的ODBC系统数据源删除后,还能连上数据库,RecordCount 也还是返回-1,就此问题请教一下各位,多谢了!