devxlogo

MsSql v6.5; big result sets and disconnects

MsSql v6.5; big result sets and disconnects

Why Trust Us

Question:
I have an app that runs on IB 4 & 5; Oracle v7.x workgroup server, and MsSql v6.5. With SQL Server, when we open a TQuery that produces a result set of more than 100 or so rows; if I don’t do a TQuery.Last, or Open, or Close within 5 to 10 seconds, my server connection is being dropped on the server, without the client app (me) getting any notification. Then, as soon as we attempt to access the TQuery object again, we ‘hang’.

In other words, with MsSql (v6.5), when a large result set is generated, it appears that if you do NOT traverse the ENTIRE result set right away, after several seconds your connection is dropped. Obviously, this does NOT happen on IB or Oracle. Is there a way around this problem using the standard BDE/SqlLinks Drivers? Or will I have to go to a 3rd party product to solve this problem?

Answer:
You might check the KeepConnection property of the database object you’re using. If you want a persistent connection, you’ll have to set this to true.

See also  Why ChatGPT Is So Important Today
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More