Prev: Clear connection history Answer
Next: The provided statistics stream is corrupt
From: Michal Valent on 21 Dec 2009 02:54
Definitelly this timeout has to do with IIS worker process idle mode.
The wake up of IIS worker process and the following attempt connect to the
database,
takes more than 15 seconds.
miso


"Michal Valent" <valent(a)spirit.sk> wrote in message
news:0D140B6E-3A6A-429E-B692-0C69BD8BDC5C(a)microsoft.com...
> Hello,
> I have full SQL 2008 server on Windows 2008 server
> and try to connect via ADO NET, ASP NET application on IIS7
>
> protected void Application_BeginRequest(Object sender, EventArgs e)
> {
> .
> .
> .
> try
> {
> string ent = SPUZ.classes.Globals.ent();
> conString = Globals.Decrypt(conString, ent);
> SqlConnection con = new SqlConnection(conString);
> con.Open();
> HttpContext.Current.Items.Add("con", con);
> SqlCommand command = con.CreateCommand();
> command.CommandText = "SET DATEFORMAT ymd";
> command.ExecuteNonQuery();
> }
> catch (Exception ex)
> {
>
> sometimes I get :
>
> Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding.
>
> but at this time the server is up and running.
>
> Can someone help me to find what is going on ?
> thanks
> miso

First  |  Prev  | 
Pages: 1 2
Prev: Clear connection history Answer
Next: The provided statistics stream is corrupt