Re: Why OraDynaset always returns nothing???

In article <660ec58c.0210272216.59ccd7e4_at_posting.google.com>, yangcolt_at_hotmail.com says...
> 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
> '=========================================================================
> %>

You are connecting as user SYSTEM. Is there a table "MyTest1" in that user's schema? Probly not.

• Tom