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

Hmm, odd. In that case, ask the author of the driver :)

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com