Thursday, March 22, 2012

OleDbCommand TimeOut Not Working

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();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();

0 comments:

Post a Comment