firebird-odbc-devel

[Firebird-odbc-devel] Firebird ODBC and MS Excel 2007

[Maya O. (Home) <may...@gm...>]

Hi,

I am trying to connect to my Firebird 1.5 database from Excel 2007.

When I try to add the datasource in to Excel I get the error:

"Unable to obtain list of tables from the data source."

And no connection is made.

If I go to Tools|ODBC in IBExpert, the same ODBC connections work just fine.

I googled the error, but can only find a post by Tim Matsell to this group
in Jan 2007, which I can see no reply to..

Anyone got any ideas?

Thanks
Maya

Re: [Firebird-odbc-devel] Firebird ODBC and MS Excel 2007

[Maya O. (Home) <may...@gm...>]

>
> >>I am trying to connect to my Firebird 1.5 database from Excel 2007.
> >>When I try to add the datasource in to Excel I get the error:
> >>"Unable to obtain list of tables from the data source."
>

Just resolved my own problem. Tried one of the other non-Firebird
datasources, which gave a slightly different error. Googling that error,
found a post that said using "From Microsoft Query" rather than "From Data
Connection Wizard" works for them, and hey presto, it works for me too ;-)

Maya