Subject Re: [firebird-support] Connecting from Excel to Firebird using ODBC
Author Mark Rotteveel
Ann W. Harrison wrote:
> Mark Rotteveel wrote:
>> 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.

That is what I said in my previous email. As the error the original
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