Why rs.recordcount get result=-1?

[peihun]

Hi all,

After i executed the coding, i got i=-1. why?
Is that not apply to oracle? but i tried used sqlserver can get correct result.

strConn = "Provider=MSDAORA.1;Data Source=candy"
strUser = "candy"
strPass = "candy"
Set cnnOracle =Server.CreateObject("ADODB.Connection")
cnnOracle.open strConn,strUser,strPass

sql= "select * from table1"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, cnnOracle, 3, 1

if rs.Supports(adApproxPosition)=true then
i=rs.RecordCount
response.write("The number of records is: " & i)
end if

cnnOracle.Close
Set rs = nothing
Set cnnOracle = nothing

Please help me :)

[mehere]

try this:
rs.Open sql, cnnOracle, 1, 1

you can also take a look at this link (http://classicasp.aspfaq.com/general/why-does-recordcount-return-as-1.html)

[peihun]

Thank for reply oh, but after i tried, the result still -1 :(

Please guide me...