How to set Query timeout for SQL server in ODBC connection string ?

Question

How to set Query timeout for SQL server in ODBC connection string ?

Boopathy Ravi 0

I am using a ETL tool called Alteryx. It is windows based tool. I have installed Microsoft ODBC driver for the tool to interact with SQL databases. I am creating required data sources in ODBC administrator for the tool to access required databases. I would like to timeout the queries if it runs more than defined time window. I do not see a option to define the Query timeout at data source level, if the data source is created through Microsoft ODBC driver. When I create data source using Data direct ODBC driver, I am given with option to define query timeout. How can I define query timeout for the data source created with Microsoft ODBC driver ?

Shaikh Abdul Salam 0 Reputation points

2023-03-16T14:18:27.0966667+00:00
To set a query timeout for a data source created with Microsoft ODBC driver, you can add the "Query Timeout" parameter to the connection string in Alteryx. Here are the steps to follow:

Open Alteryx and go to the "Connect In-DB" tool.

Click on the "Options" button in the tool configuration panel.

In the "ODBC Connection String" field, add the "Query Timeout" parameter and set the value in seconds. For example, if you want to set the timeout to 60 seconds, add "Query Timeout=60" to the connection string.

Click "OK" to save the changes and close the options window.

Use the tool as usual and the query will timeout after the specified time window.

Note that the "Query Timeout" parameter may not be supported by all ODBC drivers, so it's possible that this solution may not work for your specific driver. If that's the case, you may need to explore other options or consider using a different ODBC driver that supports query timeouts.

2 answers

Your answer

Shaikh Abdul Salam 0 Reputation points

2023-03-16T14:18:27.0966667+00:00

To set a query timeout for a data source created with Microsoft ODBC driver, you can add the "Query Timeout" parameter to the connection string in Alteryx. Here are the steps to follow:

Open Alteryx and go to the "Connect In-DB" tool.

Click on the "Options" button in the tool configuration panel.

In the "ODBC Connection String" field, add the "Query Timeout" parameter and set the value in seconds. For example, if you want to set the timeout to 60 seconds, add "Query Timeout=60" to the connection string.

Click "OK" to save the changes and close the options window.

Use the tool as usual and the query will timeout after the specified time window.

Note that the "Query Timeout" parameter may not be supported by all ODBC drivers, so it's possible that this solution may not work for your specific driver. If that's the case, you may need to explore other options or consider using a different ODBC driver that supports query timeouts.

Answer 1

Hi @Boopathy Ravi

You could use the ODBCTimeout and QueryTimeout properties to show how the QueryTimeout setting on a Database object sets the default ODBCTimeout setting on any QueryDef objects created from the Database object.

Please refer to this doc for more details: Database.QueryTimeout property (DAO)

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Olaf Helper 47,436

I am using a ETL tool called Alteryx.

That's a 3rd party product, you may better contact the software vendor support.

I do not see a option to define the Query timeout at data source level

Of course not, at connection level you can set connect properties, like connect timeout, but not query properties.

Queriy timeouts are defined per session/query.

Share via

How to set Query timeout for SQL server in ODBC connection string ?

2 answers

Your answer