Re: [Firebird-odbc-devel] Using FB ODBC driver with MSOffice applications

[Michael D. S. <sp...@pa...>]

> -----Original Message-----
> From: fir...@li... 
> [mailto:fir...@li...] On 
> Behalf Of bill lam
> Sent: Wednesday, March 21, 2007 11:18 AM
> To: fir...@li...
> Subject: Re: [Firebird-odbc-devel] Using FB ODBC driver with 
> MSOffice applications
> 
> Michael D. Spence wrote:
> > I'm trying to use the FB ODBC driver (2.00.00.142) 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.> 
> Did you try setting characterset to utf8 or unicode_fss at 
> driver dsn config screen?
> 

I tried both of those, plus ASCII and none of that worked.

What should the setting be for the pulldown that says
"Set null field SCHEMA", "Remove SCHEMA from SQL query",
"Use full SCHEMA"?  What does it do?