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

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