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