I have tried simple stored procedures to return recordset
Select * From bTable
It is running good, giving proper out put.
dim rsTemp, strSql
strSql = “Exec test1”
set rsTemp = erver.CreateObject(“ADODB.Recordset”)
rsTemp.Open strSql, con, 1 , 3
Response.Write rsTemp.RecordCount
con.close
set con = nothing
This code is returning me 15 record count
But If I am making it bit complicated then recordset is returning -1 recordcount
Select Count(bId) as cntBid from bTable
This stored procedure is running well in SQL Server 2005, but if I am caling them in ASP pages it is returning me -1 recordcount.
It is very urgent, Please Help me
