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
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?

  • facampos's avatar
    facampos
    Regular Visitor
    10 years ago

    I want to connect with one of my firebird's tables or views . For it , I beleve that  have to : Get Data> ODBC> "Mydns" and at this moment all of my tables and views for this dsn will show below.  How can i connect if it doesn´t shows . Just the firts table is showing.

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    Hi,

     

    Doing

    = Odbc.DataSource("dsn=YOURDSNNAME")

    is equivalent to that ODBC button, the only difference is that it disables HierarchicalNavigation (groups tables under schemas etc. instead of showing all of them in same list). When you do the work around I give you, you don't need the ODBC button anymore :)

  • kcoyle11's avatar
    kcoyle11
    New Member
    10 years ago

    This work around gets me a listing of all my tables. How would you load multiple tables as you do when you use the traditional odbc method.

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    Oh, I see what you mean. When you pick multiple tables, basically what it does is creating multiple queries from scratch. I think you'll have to do this one by one with different queries for each table you want to import.