in vb i make an rdo connection i specify to use a server side cursor. this program has been working for ages. However we have just had our SQL 6.5 servers hardware upgraded and sql re-installed. when i run now with a server side on a query a resultset with two rows never hits eof. therfore it just loops around on the last record. i changed the cursor type to client side and it works fine.
What could have changed on the server to make this happen.