Why OraDynaset always returns nothing???

From: Frank <yangcolt_at_hotmail.com>
Date: 27 Oct 2002 22:16:02 -0800
Message-ID: <660ec58c.0210272216.59ccd7e4@posting.google.com>

Please have a look at the following ASP code. RecordCount is ALWAYS 0. OraDynaset.BOF and OraDynaset.EOF are all ALWAYS True. Could anyone tell me why ?

This is just a copy from the sample code. and I am 100% sure the database can be connected successfully.

Platform: IIS 5.0, Oracle 9.2, NT 200 Advanced Server.

<% '=========================================================================

Set OraSession = CreateObject("OracleInProcServer.XOraSession") Set OraDatabase = OraSession.OpenDatabase("", "system/password", cint(0))

Set OraDynaset = OraDatabase.CreateDynaset("select * from MyTest1", cint(0))

Response.write ("RecordCount = " & OraDynaset.RecordCount & "<BR>")

Response.write ("OraDynaset.BOF = " & OraDynaset.BOF & "<BR>") Response.write ("OraDynaset.EOF = " & OraDynaset.EOF & "<BR>")

OraDynaset.MoveFirst

'remove OraSession
Set OraSession = Nothing

'=========================================================================

Many Thanks!!!

Frank Received on Mon Oct 28 2002 - 00:16:02 CST