When I use a TQuery into a table that produces a large result set (> 100 rows), if I DON'T traverse the result set immediately, after several seconds the server will drop my connection without any notification. This doesn't happen with Interbase or Oracle. Is there a parameter (either BDE or MsSql) that I need to set, or is this just some type of known problem with MsSql? If it's a problem, is there a known fix/work-a-round? If not, is there a 3rd party BDE replacement that corrects this problem? Any additional info on this would be appreciated.
0 · ·