Timeout on "DataAdapter.Fi ll"

[=?Utf-8?B?RnJhbmsgVXJheQ==?=]

Hi all

I have a timout problem when I call "DataAdapter.Fi ll".
When I debug, I see that all timeout settings are correct,
ConnectionTimeo ut 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.Exceptio n
{System.Data.Sq lClient.SqlExce ption}

Here is what I do:
Conn.Connection String = "Data Source=ServerXY ;Initial Catalog=master; Connect
Timeout=0;Integ rated Security=SSPI;"
Command.Command Timeout = 0
System.Data.Sql Client.SqlDataA dapter local_DataAdapt er = new
System.Data.Sql Client.SqlDataA dapter(Query, Conn);
System.Data.Dat aSet local_DataSet = new System.Data.Dat aSet();
local_DataAdapt er.Fill(local_D ataSet, DataSetTableNam e);

Thanks for any comments !!

Regards
Frank

[Alberto Poblacion]

"Frank Uray" <Fr*******@disc ussions.microso ft.comwrote in message
news:91******** *************** ***********@mic rosoft.com...

I have a timout problem when I call "DataAdapter.Fi ll".
When I debug, I see that all timeout settings are correct,
ConnectionTimeo ut 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."}

One case where this happens is if you are opening connections but not
closing them. Every time this happens, a connection is consumed, and when
you reach the configured maximum (typically 100), the next time that you
attempt to open a connection the system waits for one of the open
connections to be freed. Since this doesn't hapen, you finally get a timeout
error. The problem is that the faulty code is somewhere else (in the part of
the program that is opening and not closing the connections), and not in the
piece of code that displays the error, so it's difficult to debug.

[=?Utf-8?B?RnJhbmsgVXJheQ==?=]

I have found the problem:
On The DataAdapter there is also a CommandTimeout within
SelectCommand. This has to be set also ...

System.Data.Sql Client.SqlDataA dapter local_DataAdapt er = new
System.Data.Sql Client.SqlDataA dapter(Query, return_SQLNATIV EConnection);
System.Data.Dat aSet local_DataSet = new System.Data.Dat aSet();
local_DataAdapt er.SelectComman d.CommandTimeou t = 0;
local_DataAdapt er.Fill(local_D ataSet, DataSetTableNam e);


"Frank Uray" wrote:

Hi all

I have a timout problem when I call "DataAdapter.Fi ll".
When I debug, I see that all timeout settings are correct,
ConnectionTimeo ut 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.Exceptio n
{System.Data.Sq lClient.SqlExce ption}

Here is what I do:
Conn.Connection String = "Data Source=ServerXY ;Initial Catalog=master; Connect
Timeout=0;Integ rated Security=SSPI;"
Command.Command Timeout = 0
System.Data.Sql Client.SqlDataA dapter local_DataAdapt er = new
System.Data.Sql Client.SqlDataA dapter(Query, Conn);
System.Data.Dat aSet local_DataSet = new System.Data.Dat aSet();
local_DataAdapt er.Fill(local_D ataSet, DataSetTableNam e);

Thanks for any comments !!

Regards
Frank