On Thursday, September 5, 2002 at 12:53, [EMAIL PROTECTED] wrote: vnc> I am facing a simple problem in ASP while vnc> connecting to Oracle through a system DSN connection. vnc> The DSN is using Oracle Driver to connect to the vnc> database. I am able to connect to the db, but when I vnc> try to read records from a table in the db I get the vnc> record count as "-1". What might be wrong in this sql vnc> query :
vnc> rsPhotocopy.open "select * from One",Con,3,2 recordcount is not supported on all cursor types and datasources. if ado cannot determine the record count then it will return -1. according to the ado docs, a static cursor should return a record count as should a keyset cursor. forward-only will return -1 and a dynamic cursor will return either -1 or the actual count depending on the datasource. i've had no problems getting the record count with a forward-only cursor on an access database, but not with a sql server database. so it's probably your datasource no supporting the recordcount property. hth, darren ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
