VB & Database, VB 6 / SQL Server 7 App gets Timeout expired (-2147217871) about every 50 minutes

VB 6 / SQL Server 7 App gets Timeout expired (-2147217871) about every 50 minutes

Author	Message
Jerry Lu #1 / 4	VB 6 / SQL Server 7 App gets Timeout expired (-2147217871) about every 50 minutes I've got a VB 6 / SQL Server 7 App that gets "Timeout expired (-2147217871)" on a SELECT statement about every 50 minutes - consistently. Any ideas?
Mon, 17 Nov 2003 02:12:54 GMT

Parthasarathy Mandaya #2 / 4	VB 6 / SQL Server 7 App gets Timeout expired (-2147217871) about every 50 minutes Check the connection timeout property on SQL Server. You need to tune your app - why is it taking 50 minutes to run a SELECT query? Brainbench certified VB6 and SQL7 developer Home Page: http://partha.tripod.com * Sent via Developersdex http://www.developersdex.com * Don't just participate in USENET...get rewarded for it!
Mon, 17 Nov 2003 03:02:37 GMT

Jerry Lu #3 / 4	VB 6 / SQL Server 7 App gets Timeout expired (-2147217871) about every 50 minutes Clarification: the application runs continuously for about three hours during which it is repeatedly doing SELECTs. Quote: >I've got a VB 6 / SQL Server 7 App that gets "Timeout expired >(-2147217871)" on a SELECT statement about every 50 minutes - >consistently. Any ideas?
Mon, 17 Nov 2003 21:41:03 GMT

Thomas Scho #4 / 4	VB 6 / SQL Server 7 App gets Timeout expired (-2147217871) about every 50 minutes Jerry, I just ran into the same problem at a clients site. All my apps get a timeout including SQL Enterprise manager. I have absolutely no idea what's happening. After rebooting machines or just waiting for 20 minutes or so everything is back to normal. If you find a solution please let me know. Thomas Schoch Quote: >I've got a VB 6 / SQL Server 7 App that gets "Timeout expired >(-2147217871)" on a SELECT statement about every 50 minutes - >consistently. Any ideas? Thomas Schoch Elephant Software AG Switzerland
Tue, 25 Nov 2003 16:57:04 GMT

Page 1 of 1

[ 4 post ]