How do I enforce a timeout on a SQL query/connection?
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?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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.
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.
