Search code examples
iis-7asp-classicrecordset

Classic ASP returns only single record from recordset on Windows Server 2008

I have a been moved to a Windows 2008 Server where I need to host classic ASP functionality to a Oracle Database. I have configured the server to run classic ASP and have only found one issue where, when I execute a database request, only a single record is returned rather than the 999 ones available in the database. A run of the actual SQL command in SQLPlus show all records, so not sure what is going on:

selectScName = "select item from my_schema.col1"

Set dbObjT = Server.CreateObject("ADODB.Connection")
dbObjT.open =  "MY-DB-CONNECTION"
Set RSdbTest = dbObjT.Execute(selectScName)

Do while not RSdbTest.EOF
         Response.Write(RSdbTest("col1") & "<br>")
      RSdbTest.MoveNext
     loop
RSdbTest.Close
Set RSdbTest = nothing
dbObjT.Close
Set dbObjT = nothing
Solution

  • I think used .MaxReords=1 statement before this code. check it