Subject Re: [firebird-support] Alias Connection Error
Author Helen Borrie
At 08:13 PM 2/01/2008, you wrote:
>Good day to everyone and all the best for 2008.
>
>I have a connection problem or an aliases.conf problem. When connecting
>to a database on the server using the isql tool with the following
>parameters:
>connect `SEBATA:F:\DATABASES\PORTMAN.FDB' everything works well and a
>connection to the database is established. When trying to do the same
>using the aliases.conf file (with a path on the client machine to
>E:\Firebird_2_0) by issuing the command connect PORTMAN I repeatedly
>get the following error: database unavailable (error number 904).
>
>The alias in aliases.conf on the client machine is defined as following:
>PORTMAN=SEBATA:F:\DATABASES\PORTMAN.FDB (the same as used in the
>connection string using isql).
>
>Firebird 2.0.3 is used as the SQL Server on a WindowsXP server box. Is
>there something very simple that I am missing here?

Yup. The alias has to be a filesystem path alias, not an alias for the whole connection string.

Define as:
PORTMAN = F:\DATABASES\PORTMAN.FDB

And have the application conect to SEBATA:PORTMAN

./heLen