Forum Discussion

ells's avatar
ells
Icon for Helper II rankHelper II
4 years ago
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...
Need Help
  • ells's avatar
    ells
    4 years ago

    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

ells's avatar
ells
Icon for Helper II rankHelper II
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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