Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Relational Databases
Expertise: Beginner
Apr 10, 1998

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date