Forum Discussion
Solved
Query Timeout (ODBC)
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...
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
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.