BalagopalNNair
Mon Feb 25 05:17:01 CST 2008
By the way the default timeout value is 15 seconds
"Balagopal N. Nair" wrote:
> 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/library/system.data.sqlclient.sqlconnection.connectionstring(VS.71).aspx
>
> Thank you,
> Bala
>
http://code.msdn.microsoft.com/nbalagopal
>
>
>
>
> "Husam" wrote:
>
> > 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