Error with OLE DB requests

[uxout]

I'm using OLE DB from CTRL Script (via CtrlADO) and getting error randomly that prevents the script to get correct data from a SQL Server 2017 DB.
The script need to be running H24 and getting data from different SQL Server DBs.
The error number is -2147217871 and error text : HYT00.
I have looked on google, it could be a low timeout issue.
How could I change this timeout setting?
Or maybe it is due to something else?

Any help would be very much appreciated.
Regards.

[Gertjan van Schijndel]

To keep the connection alive you could execute a sql statement after some time of inactivity.

[uxout]

Hello !
In fact, I don't want to keep the connection alive.
Everytime a request needs to be done, there is a connection opening, request and close.
For the moment, my only clue is that I might add some index to boost the requests.

[adaneau]

Hi,

I was reading that ADO is limiting the answer time to 30s for reply to a query. Does yours takes more?

https://stackoverflow.com/questions/175 ... ry-timeout

https://docs.microsoft.com/en-us/sql/ad ... erver-2017

I think you can set it up at the connection like said in this post but cannot guarantee...

@Gertjan: I havent seen any way to set custom answer time in WinCC OA, is it possible?

BR
Alex

[Gertjan van Schijndel]

Currently there is no option to set connection options, like this query timeout. The only way to set options is in the connection string or with a statement after the connection is established.

You could file a feature request to extend the current functionality with a possibility to set options.