Subject | Re: [firebird-support] Connecting from Excel to Firebird using ODBC |
---|---|
Author | Mark Rotteveel |
Post date | 2009-10-14T06:18:51Z |
Ann W. Harrison wrote:
poster got says 'The data connection wizard cannot obtain a list of
databases' I'd say he is using some generic wizard.
Mark
--
Mark Rotteveel
> Mark Rotteveel wrote:That is what I said in my previous email. As the error the original
>> Sure, but you can define ODBC connection from within Excel; and if for
>> instance you use SQL Server that allows you to browse the various
>> databases available to your user.
>>
>
> Unlike SQL Server or MySQL, Firebird doesn't keep a list of databases -
> a database is just a file that happens to be structured as a Firebird
> database. It's independent of file system locations, etc. There is
> an aliasing capability, but the aliases aren't guaranteed to include
> all databases - and I guess they could point to something that's not
> a database. So "browsing databases available" really isn't a Firebird
> concept.
poster got says 'The data connection wizard cannot obtain a list of
databases' I'd say he is using some generic wizard.
Mark
--
Mark Rotteveel