Problems with Visual and SQL!!!

[Ivan24]

Hello,I have problems with the Visual Basic 3.0 and the MSSQL 6.5 ,the thing is that the when I want to pick up a lot of data from a table it send me a ODBC call failed timeout expired, and I don´t know how to repair it, when I have few data in a table like this:
Name Analog Date
W1Q01 45 09/12/2000 04:00:00
W1T01 34 09/12/2000 04:00:00
W1P01 22 09/12/2000 04:00:00
W1Q01 66 09/12/2000 04:30:00
W1T01 55 09/12/2000 04:30:00
W1P01 44 09/12/2000 04:30:00
I didn´t have problems but when the rows go up to 30,000 I have problems.
The thing is that I have to make a report like the one is down:
Hour W1Q01 W1T01 W1P01
04:00:00 45 34 22
04:00:00 66 55 44

I made it in Visual but I have a lot of problems, how can I do to make it by the SQL, to send it to a printer to have the report of the data like the report I show you, PLEASE HELP ME, I don´t find the way to do it.
Thanks for all your help!!!

 

[bvoelp]

Try setting the .QueryTimeOut property of you db or query object to 0 (zero) [sig]<p>Bruce Voelp<br><a href=mailto:bvoelp@if.rmci.net>bvoelp@if.rmci.net</a><br><a href= > </a><br>Earn AS in 1976 and BS in 1986. Learn to talk with computers when the only interface was 80 column punch cards, and paper tape.[/sig]