I was wondering if there are any know issues between VB6 apps, connecting to a Sybase 11 db using an rdoConnection. In short I have a flexigrid which is populated by a simple query which retrieves records from a sybase table. A sql query is built up and this is passed using an rdoConnection. I then open up a rdoResultset and loop through this, and for each record returned the flexigrid increments by one row. The problem is that sometimes, it doesn't display all the records that should be returned, even though when i do a count of the records returned it is correct. It can sometimes take 3 requeries of the database to retrieve/display the full set. There seems to be no general pattern as to why this occurs and I have tried various drivers from old Sybase 11 drivers to new Merant 3.5 but no go. In addition I have put a counter that increments each time the code loops through, it seems to spit out the first 299 records fine, and then stalls for a few seconds after every successive hundred record, till it reaches the end of the resultset.
any help would be appreciated.
any help would be appreciated.
