OleDbCommand TimeOut Not Working

[Chris Fink]

Why does this timeout after 10 secs, instead of the higher value expected?

OleDbConnection cn = new OleDbConnection(Session["DataSource"].ToString());
OleDbDataAdapter adapter = new OleDbDataAdapter();
OleDbCommand cmd = new OleDbCommand(query, cn);
cmd.CommandTimeout = 99999;
adapter.SelectCommand = cmd;
adapter.Fill(ds,"data");
cn.Close();
adapter.Dispose();

[Curt_C [MVP]]

Are you sure it is and not something else timing out (page, etc).?

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

"Chris Fink" wrote:

Why does this timeout after 10 secs, instead of the higher value expected?

OleDbConnection cn = new OleDbConnection(Session["DataSource"].ToString());
OleDbDataAdapter adapter = new OleDbDataAdapter();
OleDbCommand cmd = new OleDbCommand(query, cn);
cmd.CommandTimeout = 99999;
adapter.SelectCommand = cmd;
adapter.Fill(ds,"data");
cn.Close();
adapter.Dispose();