Incresase the Excution Time?

  • Thread starter Thread starter Husam
  • Start date Start date
H

Husam

Hi EveryBod:

I have an object cmd as SqlCommand object and and I face problem with safe
large data by using this object there is an errore appear tell me that the
excution time out.

Sombody can tell me how can I increase the Excution time?

I am using SQL server 2005

any help will be appreciated

regard's

Husam
 
Hey Husam,
Looks like the execution time of your query is longer than the default
connection time out value.

Here's something that might help you:
Jus try executing the query in SQL Management Studio and in the bottom right
corner it'll show you the duration of execution.

Set the connenction timeout in the the connection string in your application.
"......; Connection timeout = 100" where the timeout is in seconds.
Refer the link given below for more details:

http://msdn2.microsoft.com/en-us/li...nt.sqlconnection.connectionstring(VS.71).aspx

Thank you,
Bala
http://code.msdn.microsoft.com/nbalagopal
 
Back
Top