topic Re: How do I enforce a timeout on a SQL query/connection? in QlikView

How do I enforce a timeout on a SQL query/connection?

pauluk__ — Fri, 01 Sep 2017 09:33:21 GMT

Hi all

I'm trying to enforce a timeout in QlikView on a query which executes a stored procedure in Microsoft SQL Server.

In the connection string builder I have put both a connection timeout and general timeout but neither of these appear in the connection string that is built when I press OK.

After looking around I have tried the below parameters in the string but none seem to work:

QueryTimeout=10

Timeout=10

Connection Timeout=10

I have tried this on OLE DB SQL and ODBC and none of these seem to affect the timeout. Has anyone managed to do this successfully?

Thanks,

Paul.

Re: How do I enforce a timeout on a SQL query/connection?

Anil_Babu_Samineni — Fri, 01 Sep 2017 09:49:14 GMT

May be look about "SLEEP"

Re: How do I enforce a timeout on a SQL query/connection?

marcus_sommer — Fri, 01 Sep 2017 13:33:59 GMT

If I look on this: Re: Qlik Sense - Timeout loading data from SQL it should be in general possible but both the oledb/odbc-driver and the database must support these commands whereby it's important that the database sends an error to qlikview and not just silently exit the query.

- Marcus

Re: How do I enforce a timeout on a SQL query/connection?

Peter_Cammaert — Fri, 01 Sep 2017 13:54:51 GMT

Most options and parameters in OLE DB/ODBC connection strings belong specifically to the RDBMS you are trying to talk to, and are of no meaning to QlikView.

You can check whether MS SQL Server supports a connection timeout option by either visiting all "advanced" configuration tabs in the driver (by preference the Native SQL Driver) or by visiting a web site like http://www.connectionstrings.com and navigating to the proper forums/pages for your RDBMS. There are different areas for different SQL Server releases.