Does it Works CommandTimeOut?

I

Ixabre

Hi friends, I would like me that long querys, which generates expanding
my axis 'X', stops using CommandTimeOut, but I setting this property
using this code line.

AxPivotTable1.Connection.CommandTimeout = 10

...and doesn´t work,

Am I right?, Does CommandTimeOut use for break long querys?.

David
 
A

Alvin Bruney [MVP]

How do you know it doesn't work? I believe it should just kill the query
after the timeout has expired. I'm not sure if it will throw an exception.
You'd need to look at the data store to see if the query is still running.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


Hi friends, I would like me that long querys, which generates expanding
my axis 'X', stops using CommandTimeOut, but I setting this property
using this code line.

AxPivotTable1.Connection.CommandTimeout = 10

...and doesn´t work,

Am I right?, Does CommandTimeOut use for break long querys?.

David
 
Top