Huge SQL Query problem

VeRiTo
01-08-2004, 11:59 AM
Hi people, i have a problem.
I made a VB program that executes a SQL Query and fills a mshflexgrid with the results.
WEll, this SQL query is HUGE and it has lots of sub-queries. The thing is, if i use the sql query analyzer program (MS SQL SERVER 8.0) to execute the query it is ok but from VB6 i get a timeout error!
what can i do?

Dennis DVR
01-08-2004, 12:14 PM
Hi people, i have a problem.
I made a VB program that executes a SQL Query and fills a mshflexgrid with the results.
WEll, this SQL query is HUGE and it has lots of sub-queries. The thing is, if i use the sql query analyzer program (MS SQL SERVER 8.0) to execute the query it is ok but from VB6 i get a timeout error!
what can i do?

if that's the case why don't you just put in the store procedure and retrieve it with the command objects in vb.

00100b
01-08-2004, 12:48 PM
One option would be to increase the values for the .CommandTimeout property of the ADO.Connection object.

VeRiTo
01-08-2004, 01:00 PM
thanks both! I found another way to do it and it works great:
http://support.microsoft.com/default.aspx?scid=kb;en-us;190606
bye!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum