>>Connection is busy- error.<<
I consider this a 'bug' in VFP or C++ or ODBC -- whatever. There is a knowledge base in microsoft -- search for "Connection Busy". The work around is to just set your fetching to all records (-1) and the issue should go away. Microsoft says this behaviour is "by design" -- like some folks sat around and said "hey, if we is they have fetching on a view at 100 (and that view has more then 100 records) and then they re-hit the server for another view, let's put a connection busy error".
kevin