Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Function Odbc.DataSource error with Timeout settings.

I want to set a max timeout for ODBC connection to 15 minutes. I add another parameter like: Source = Odbc.DataSource("dsn=Production", [HierarchicalNavigation=true], [Timeout=#duration(0, 0, 15, 0...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Use "ConnectionTimeout" instead:

    Source = Odbc.DataSource("dsn=Production", [HierarchicalNavigation=true, ConnectionTimeout=#duration(0, 0, 15, 0)])

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Too many square brackets.

 

Source = Odbc.DataSource("dsn=Production", [HierarchicalNavigation=true, Timeout=#duration(0, 0, 15, 0)])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi lbendlin ,
    This way I also get an error:

     

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi  Anonymous ,

       

      Use "ConnectionTimeout" instead:

      Source = Odbc.DataSource("dsn=Production", [HierarchicalNavigation=true, ConnectionTimeout=#duration(0, 0, 15, 0)])

       

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!