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)])

But I get an error that I have more parameters than allowed. Why is there such an error? After all, it is allowed to set up to 5 parameters in this function Odbc.DataSource.

 

 

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super 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
        Community 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!