Subject Re: [firebird-support] Re: Installing Firebird on Fedora Core 3
Author Helen Borrie
At 04:51 AM 18/05/2006, you wrote:
>Well now at the moment all is working fine i know it is working if i
>use isql localhost to login, i have a database which i want to use on
>it and i have tried it on windows it works fine.
>Windows is the application side which access's firebird, how can i
>gain access to it on linux?
>sorry for the stupid questions and i know they are basic but i am not
>getting the fundamental of it all.

A good place to start would be to download the Quick Start Guide from
the Firebird website.

On the Linux server, you must make sure that the firebird (Unix) user
has rw permissions for the database file AND has [e]x[execute]
permissions on the directory where the database is. And, to be on
the safe side, don't file-copy the database from the Windows host,
back it up, and restore it on the Linux host.

In short, with those things taken care of, suppose your database is
in /opt/data and its name is mydatabase.fdb and the hostname of the
Linux machine is mylinux. The connection string from a Windows
application will be:


and you must provide the (Firebird) username and password of a user
that (a) is present in security.fdb on the Linux server and (b) has
SQL privileges to the database.

If your application uses a database alias then declare the same alias
in aliases.conf on the Linux server. Suppose your alias on Windows is

mydb = c:\data\mydatabase.fdb

Then, using the location of the earlier example, your alias on Linux would be

mydb = /opt/data/mydatabase.fdb

The advantage of using the alias is that your application does not
have to worry about the filesystem path formats on the different
machines, only the servers' hostnames.

To connect to the database on Windows:


To connect to the database on Linux:


Don't forget everything on Linux is case-sensitive.