Forum Discussion

kcoyle11's avatar
kcoyle11
New Member
10 years ago

Data Source Only showing one table

Hello I am connecting to a data source through odbc connection. The connection previously worked fine but it is now showing only one of the tables in the Database. Any ideas??
Need Help
marcopaulo's avatar
marcopaulo
New Member
10 years ago

Frown sent.

Please tell me if you do not get it.

 

Thanks.

 

kcoyle11's avatar
kcoyle11
New Member
10 years ago

Did anyone find anything more on this?

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    Hi kcoyle,

     

    We'll investigate why the Firebird ODBC driver is acting like this :) Meanwhile, you can turn off the HierarchicalNavigation, and it should work fine. To do that:

     

    Go to "Get Data" > "Blank Query" and then type this to the formula bar:

    = Odbc.DataSource("dsn=YOURDSNNAME")

    Thanks

    • facampos's avatar
      facampos
      Regular Visitor
      10 years ago

      Hi Arify, 

       

      I did your suggestion , 

      = Odbc.DataSource("dsn=YOURDSNNAME")

      And the tables appering on the thatsheet as a table data but , How can I do to It Show on Get Data Window?

       

      Thanks in advanced

    • facampos's avatar
      facampos
      Regular Visitor
      10 years ago

      Hi Arify, 

       

      I did your suggestion , 

      = Odbc.DataSource("dsn=YOURDSNNAME")

      And the tables appering on the thatsheet as a table data but , How can I do to It Show on Get Data Window?

       

      Thanks in advanced

      • arify's avatar
        arify
        Microsoft Employee
        10 years ago

        I don't understand what you mean by making it show up in the Get Data window. Do you mean you want Firebird button to appear under "Get Data" > "Databases", like SQL Server or MySQL?