| Subject | Re: [firebird-support] Connect to FB2 with Excel and MS Word |
|---|---|
| Author | Robin Davis |
| Post date | 2007-03-21T14:39:25Z |
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
[Non-text portions of this message have been removed]
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
[Non-text portions of this message have been removed]