in vb i make an rdo connection i specify to use a server side cursor. this program has been working fo 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.
What could have changed on the server to make this happen.