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

hanjeu

New Member
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:\[code\]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 loopRSdbTest.CloseSet RSdbTest = nothingdbObjT.CloseSet dbObjT = nothing\[/code\]
 
Back
Top