Forum Discussion

ells's avatar
ells
Helper 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
Helper 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