Subject | Re: [firebird-support] Setting up a network server |
---|---|
Author | Thomas Steinmaurer |
Post date | 2010-10-31T19:36:48Z |
Hi Andy,
refer the machine as 'myserver'
- Open aliases.conf in the root directory of the Firebird installation
on myserver and add a line which defines an alias name for your physical
database file on myserver. E.g.:
mydatabase.fdb = c:\data\firebird\mydatabase.fdb
- Install the Firebird client (simply run the Firebird setup again,
altough with Client Tools only) and the ODBC driver on the 5 clients.
- Make sure that myserver is pingable from the clients
ping myserver
- Use myserver:mydatabase.fdb as connect string in your ODBC DSN entry
on the clients
Don't create a Windows share on myserver for the directory where the
database file is located. The clients don't need to know about that!
Well, a very short primer.
HTH.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/
> I have a quick question that may sound daft.- Install Firebird Server on a machine (server, desktop ...). I will
>
> How do I set up Firebird to service 5 computers? I want to have a central database server (firebird) and then my other machines (windows using the ODBC connection) would use the database
>
> do I have to point the ODBC link to the database file on the central server or is there another way of doing it?
refer the machine as 'myserver'
- Open aliases.conf in the root directory of the Firebird installation
on myserver and add a line which defines an alias name for your physical
database file on myserver. E.g.:
mydatabase.fdb = c:\data\firebird\mydatabase.fdb
- Install the Firebird client (simply run the Firebird setup again,
altough with Client Tools only) and the ODBC driver on the 5 clients.
- Make sure that myserver is pingable from the clients
ping myserver
- Use myserver:mydatabase.fdb as connect string in your ODBC DSN entry
on the clients
Don't create a Windows share on myserver for the directory where the
database file is located. The clients don't need to know about that!
Well, a very short primer.
HTH.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/