--- In firebird-support@yahoogroups.com, Robin Davis <Ro.Davis@...>
wrote:

>
> Hi,
>
> mspencewasunavailable <firebird@...> 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?
>
> Michael D. Spence
> Mockingbird Data Systems, Inc.
> It would help if we knew which version of Office you are using. I

use Firebird and Office 97 - excel, word and ms access - every day
and the performance is flawless on the local network. Over the wire
I think we have to wait for 2.1 to arrive for things to speed up. My
first suggestion would be to check the table permissions i.e. what
user name and password are you using to try and connect to the DB
from the DSN?

>
> Hope this helps,
>
> Rob Davis
>

Sorry, I should've said before: Office 2002, FB ODBC 2.00.00.142
I'm using SYSDBA and its password.