No time limit for SQL query

[koolrc812 (RC)]

Hi

for the below execute query, how to do the set up no limit time until get the sql results. because sometimes it shows timeout. everytime I have to increase the numbers but it still gets timeout.

Do I put output_2 in the circle area?

Thanks

[Gokul_Jayakumar (Gokul Jai)]

Hello @koolrc812
Try to give the timeout value in the Properties of Execute query as 60000 or above.

[Anil_G (Anil Gorthi)]

@koolrc812

Try giving a very high value for timeout…so it executes till there is no error

Cheers

[kali]

You can try increasing the connection timeout.

"Data Source=localhost;Integrated Security=SSPI;Connection Timeout=120;"

for example.

[koolrc812 (RC)]

Thanks. Conneciton Timeout been set to 60000000. still the same. will keep increase it. Thanks

[koolrc812 (RC)]

thought there would be a way to set no limit. will keep increase the time out limit. Thanks heaps

[Anil_G (Anil Gorthi)]

@koolrc812

Try setting -1 i guess that might take as maximum value allowed for the connection

Cheers

[koolrc812 (RC)]

you mean the connect timeout set to -1?

[Anil_G (Anil Gorthi)]

@koolrc812

Try setting timowout property to -1 yea

Cheers

[koolrc812 (RC)]

Thanks but it says the value has to be greater than 0.