--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
>
>
>
> > I'm trying to use the FB ODBC driver to connect MS Office

applications

> > to an existing FB2 database. I can create the DSN (and the Test
> > Connection button says all is well) but when I try to actually

use

> > this connection, the Office app says "Unable to obtain list of

tables

> > from the data source".
> >
> > Does anyone have any advice?
>
> Well, there's "some" error. You can turn on ODBC trace logging
> to see what the driver is returning. You can do this from the
> ODBC Control Panel applet.
>

Thanks, I had no idea there was such a thing. I wish there was a way
to actually see the data, though, instead of just the calls.

Looking at the trace, there doesn't seem to be any error, just no
tables:

---- Asks for a lot of other info first, and gets answers
---- AFAICT, this asks for a list of tables
excel e28-1340 ENTER SQLTablesW

excel e28-1340 EXIT SQLTablesW with return code 0
(SQL_SUCCESS)

---- Stuff about column binding has been removed, it all worked
excel e28-1340 ENTER SQLBindCol

excel e28-1340 ENTER SQLFetch
HSTMT 026F2100

---- No data????
excel e28-1340 EXIT SQLFetch with return code 100
(SQL_NO_DATA_FOUND)
HSTMT 026F2100

---- Drops connection, since no tables are reported
excel e28-1340 ENTER SQLFreeStmt