Timeout on "DataAdapter.Fill"

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi all

I have a timout problem when I call "DataAdapter.Fill".
When I debug, I see that all timeout settings are correct,
ConnectionTimeout is 0 and also CommandTimeout is 0.

But when I call the fill method I get:
"Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding."} System.Exception
{System.Data.SqlClient.SqlException}

Here is what I do:
Conn.ConnectionString = "Data Source=ServerXY;Initial Catalog=master;Connect
Timeout=0;Integrated Security=SSPI;"
Command.CommandTimeout = 0
System.Data.SqlClient.SqlDataAdapter local_DataAdapter = new
System.Data.SqlClient.SqlDataAdapter(Query, Conn);
System.Data.DataSet local_DataSet = new System.Data.DataSet();
local_DataAdapter.Fill(local_DataSet, DataSetTableName);

Thanks for any comments !!

Regards
Frank
.

Relevant Pages

  • RE: Remote webspace logging off.
    ... VPN timeout settings. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • CommandTimeout, ConnectionTimeout, httpRuntime executionTimeout (ASP.NET 2.0)
    ... ConnectionTimeout ... Which timeout does it set ... Is it possible to globally set CommandTimeout e.g. in web.config? ... I get this exception: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VPN Drops users sporadically
    ... Access Policy and the timeout settings on the connection manager. ... several other posts that are experiencing the same issue as well. ...
    (microsoft.public.windows.server.sbs)
  • Re: Topic Assistant in Sharepoint Portal Server 2003
    ... I have change the timeout settings. ... assistant nor can I see any difference with the topic assistant trained. ... >> completed because the document server did not respond within the ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Timeout issue in IIS 5.0
    ... Look for any timeout settings in the Application Software platform that you ... I have a data export feature on my Web site which, in some circumstances, ... In IIS 6 the MinFileBytesPerSec property sounds as if it would solve my ...
    (microsoft.public.inetserver.iis)