Subject | Re: [firebird-support] Re: Firebird location |
---|---|
Author | Helen Borrie |
Post date | 2003-09-11T00:31:45Z |
At 08:20 PM 10/09/2003 +0000, you wrote:
where you choose what kind of install you want. The client-only option is
"Minimum client install - no tools".
server the database file is located, and pass that information to the
client. So, if you don't have DHCP running, you need an entry in the HOSTS
file of the client, so that it can find the host server.
A simple example: I have Firebird Classic server running on my notebook,
under Linux. The IP address of the notebook is 10.12.13.5 and its
broadcast name is "mini". So, in the HOSTS file on the client, I include
this entry:
10.12.13.5 mini #Firebird Classic Linux server
I have a lot of database files on the server, in a filesystem named "data",
including one called ffoundation.fdb. My application can connect to this
database by passing this connection string to the client:
mini:/data/ffoundation.fdb
I also have a Firebird server running on another machine in Win2k. Its
network name is duck and its IP address is 10.12.13.2. In my HOSTS file, I
have an entry for it:
10.12.13.2 duck # Firebird SS Win2K server
My databases are on drive D, in a folder named data. To connect to a
database there named documentation.fdb, as a TCP/IP client, I can use this
connection string:
duck:D:\data\documentation.fdb
That's fine - but in 1.5 I can use database aliases, which has a lot of
benefits. In particular, it means I can soft-code the database path into
my application without knowing where the database file actually lives.
In aliases.conf, on the servers, I have these entries:
On the Linux server:
ff = /data/ffoundation.fdb
On the Win2K server:
doc = D:\data\documentation.fdb
Now, this means that my applications, tools, etc. just connect to the
alias, without being concerned whether the database file is on the Linux or
the Win2K server. With 1.5, my connection strings actually look like this:
mini:ff
duck:doc
Now, if I decide to move ffoundation.fdb onto the win2k server and
documentation.fdb onto the Linux server, I do that and alter the
aliases.conf files accordingly:
On the Linux server:
doc = /data/documentation.fdb
On the Windows server:
ff = D:\data\ffoundation.fdb
My applications don't have to change anything.
More than you asked for, I know - but it might save us from six more
questions to get your client connected. <g>
Helen
>I used the Firebird-1.5.0.3744-RC4-Win32.exe install. I don't rememberYes. At about the third page of the installer, there is a drop-down box
>a choice. Was there one?
where you choose what kind of install you want. The client-only option is
"Minimum client install - no tools".
>So my application connects to the Firebird client software which thenThat's exactly right. Your client application has to know where on the
>connects to the Firebird Server software, which then connects to the data?
server the database file is located, and pass that information to the
client. So, if you don't have DHCP running, you need an entry in the HOSTS
file of the client, so that it can find the host server.
A simple example: I have Firebird Classic server running on my notebook,
under Linux. The IP address of the notebook is 10.12.13.5 and its
broadcast name is "mini". So, in the HOSTS file on the client, I include
this entry:
10.12.13.5 mini #Firebird Classic Linux server
I have a lot of database files on the server, in a filesystem named "data",
including one called ffoundation.fdb. My application can connect to this
database by passing this connection string to the client:
mini:/data/ffoundation.fdb
I also have a Firebird server running on another machine in Win2k. Its
network name is duck and its IP address is 10.12.13.2. In my HOSTS file, I
have an entry for it:
10.12.13.2 duck # Firebird SS Win2K server
My databases are on drive D, in a folder named data. To connect to a
database there named documentation.fdb, as a TCP/IP client, I can use this
connection string:
duck:D:\data\documentation.fdb
That's fine - but in 1.5 I can use database aliases, which has a lot of
benefits. In particular, it means I can soft-code the database path into
my application without knowing where the database file actually lives.
In aliases.conf, on the servers, I have these entries:
On the Linux server:
ff = /data/ffoundation.fdb
On the Win2K server:
doc = D:\data\documentation.fdb
Now, this means that my applications, tools, etc. just connect to the
alias, without being concerned whether the database file is on the Linux or
the Win2K server. With 1.5, my connection strings actually look like this:
mini:ff
duck:doc
Now, if I decide to move ffoundation.fdb onto the win2k server and
documentation.fdb onto the Linux server, I do that and alter the
aliases.conf files accordingly:
On the Linux server:
doc = /data/documentation.fdb
On the Windows server:
ff = D:\data\ffoundation.fdb
My applications don't have to change anything.
More than you asked for, I know - but it might save us from six more
questions to get your client connected. <g>
Helen