MsSql v6.5; Large Result Set Problems - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

MsSql v6.5; Large Result Set Problems

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.


Sign In or Register to comment.