devxlogo

MsSql v6.5; big result sets and disconnects

MsSql v6.5; big result sets and disconnects

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  How IoT Tech Will Transform Logistics
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