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

[bill l. <cbi...@gm...>]

FB works fine for me, but I'm not familiar with calling FB from ms office. Could 
you give a simple test script to demostrate the problem?

Michael D. Spence wrote:
> 
>> -----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?
> 
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
> 


-- 
regards,
bill