Query Timeout (ODBC)

[ells]

I am querying using the ODBC connector. 

In the M code we have the connection:

Odbc.DataSource("dsn="ww", [HierarchyNaviagtion = true, ConnectionTimeout-#duration(0,0,30,0)

I was hoping this would allow the Odbc connector to time out at 30 minutes. However it still seems to timeout at 15 minutes regardless of the duration? Is this a setting in the ODBC Data Source Adminstrator on my PC or a native timeout? Or am I missing something. Error message below.

Thanks

E

OLE DB or ODBC error: [DataSource.Error] ERROR [ ] ERROR: Error executing query. Total time 900.18 seconds. QUERY [VIRTUAL] [QUERY_TIMEOUT] QUERY [JDBC WRAPPER] [PROCESSING] QUERY [JDBC ROUTE] [PROCESSING] java.sql.SQLException: Error executing query. Total time 900.18 seconds. QUERY [VIRTUAL] [QUERY_TIMEOUT] QUERY [JDBC WRAPPER] [PROCESSING] QUERY [JDBC ROUTE] [PROCESSING] ; Error fetching next row.

[ells · Accepted solution]

Thanks,
It looks the the ODBC data source will automatically timeout at 15 minutes. I have changed the setting in the ODBC Sata Sources and this appears to heave reqolved the issue.

Many thanks

[Anonymous]

Hello, hope you are well.

How did you do that? I'm having the same error of timeout but I don't know how to set it in the ODBC.

Thanks in advance

[lbendlin]

There are two timeouts

- connection timeout : time to negotiate a connection successfully

- command timeout : time until the first data is returned (or sometimes a brute force hard limit on when the last of the data has to be returned.

Specify the command timeout value.