Time Out

[Peque]

Hi, i´m using de OWC in winform application in Net 1.1. When y query SQL and
the server takes more than 30 seconds to respond de PivotTable shows a time
out error.
Any ideas?
Thanks

 

[Alvin Bruney [ASP.NET MVP]]

there is a time out property that you can bump up from IIS.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

 

[Peque]

Like i said, i´m working in a WinForm Application, so IIS has nothing to do
here.
I finally found a work around.
I set the timeout property of the connection in the OnConnect event after i
pass the information to the control by the XMLData.
Thanks.

Private Sub AxPivotTable1_OnConnect(ByVal sender As Object, ByVal e
As System.EventArgs) Handles AxPivotTable1.OnConnect
AxPivotTable1.Connection.CommandTimeout = 240
End Sub

there is a time out property that you can bump up from IIS.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Hi, i´m using de OWC in winform application in Net 1.1. When y query SQL
and
the server takes more than 30 seconds to respond de PivotTable shows a
time
out error.
Any ideas?
Thanks