Re: SQL Timeout Error
- From: Accesshelp <Accesshelp@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 23 Jun 2009 08:47:02 -0700
Robert,
Thanks for your response. How can I check whether SqlConnection object is
estiablished, and how do I set the CommandTimeout property? I am sorry I am
still new to SQL Server.
Thanks.
"Robert Lakinski" wrote:
Hi, AccessHelp.
If you are using .net client app to select data from the view, check the
following:
1. Whether SqlConnection object establishes connection to the sql server
successfully - check ConnectionString, ConnectionTimeout property (default
= 15 sec)
2. If the connection was established, you may need to set the CommandTimeout
property of the SqlCommand object to a value > 30 sec (default = 30 sec)
Robert Lakinski
"Accesshelp" <Accesshelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8C19B329-0148-4EDE-A1EC-A2E3A3674C47@xxxxxxxxxxxxxxxx
Good morning all,
I just created a View, and when I tried to run it, I received the
following
error message:
error message: timeout expired. the timeout elapsed prior to completion
of
the operation or the server is not responding.
error source: .Net SqlClient Data Provider
When I researched the above error message via Google, the solution is to
run
the CommandTimeout, and I don't know how to run it.
First of, if the CommandTimeout is the solution to the error, can you tell
me how to run it?
If the CommandTimeout is not the solution, can you help me with the error?
Thanks.
- Follow-Ups:
- Re: SQL Timeout Error
- From: Robert Lakinski
- Re: SQL Timeout Error
- References:
- SQL Timeout Error
- From: Accesshelp
- Re: SQL Timeout Error
- From: Robert Lakinski
- SQL Timeout Error
- Prev by Date: Re: kill the long run job automatically
- Next by Date: Re: kill the long run job automatically
- Previous by thread: Re: SQL Timeout Error
- Next by thread: Re: SQL Timeout Error
- Index(es):
Relevant Pages
|
