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
arify's avatar
arify
Microsoft Employee
10 years ago

Oh, sorry for the unclear reply.

 

Here's how you send a frown email:

 

 

In the email you can mention this thread & put the screenshots.

 

About the other thing, this is a simpler way: Go to "Get Data" > "Blank Query" and then type this to the formula bar:

= Odbc.DataSource("dsn=YOURDSNNAME")

Thanks

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