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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top