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

[pauluk__]

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.

[Anil_Babu_Samineni]

May be look about "SLEEP"

[marcus_sommer]

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

[Peter_Cammaert]

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.