- •Firebird 1.5 Quick Start Guide
- •Table of Contents
- •About this guide
- •What is in the kit?
- •Classic or Superserver?
- •Default disk locations
- •Installing Firebird
- •Installing the Firebird server
- •Installation drives
- •Installation script or program
- •Windows platforms
- •Posix platforms
- •Testing your installation
- •Pinging the server
- •Checking that the Firebird server is running
- •Windows NT4, 2000 and XP
- •Windows 9x or ME
- •Windows Control Panel applets
- •Posix servers
- •Other things you need
- •A network address for the server
- •Default user name and password
- •How to change the SYSDBA password
- •An Admin tool
- •Performing a client-only install
- •Windows
- •Linux and some other Posix clients
- •Working with databases
- •Connecting to the sample database
- •Server name and path
- •The CONNECT statement
- •Using isql
- •Using a GUI client
- •Creating a database using isql
- •Starting isql
- •The CREATE DATABASE statement
- •Firebird SQL
- •Division of an integer by an integer
- •Things to know about strings
- •String delimiter symbol
- •Apostrophes in strings
- •Concatenation of strings
- •Double-quoted identifiers
- •Expressions involving NULL
- •More about NULLs
- •Safety measures
- •Security options on the server
- •Backup
- •How to corrupt a database
- •Modifying metadata tables yourself
- •Disabling forced writes on Windows
- •Disabling Forced Writes on a Linux server
- •Restoring a backup to a running database
- •Allowing users to log in during a restore
- •How to get help
- •The Firebird Project
- •Alphabetical index
Firebird 1.5 Quick Start
the installation process.
Note
We've not been completely honest with you. Firebird has a third flavor: Embedded Server, but this is an entirely different beast and not intended for your typical client-server setups. Consult the Release Notes for details.
Default disk locations
The following table describes the default disk locations for the components on Windows and Linux.
In the major codebase revision starting at v.1.5, the old hard links to InterBase artifacts were removed and many of the major components were renamed. As a result, Firebird 1.5 permits a running InterBase® server to be present, provided the two servers don't listen on the same TCP/IP port. If you need this feature, read Configuring the port service in the Release Notes that came with your Firebird installation (look in the doc subdir).
Table 2. Components of the Firebird 1.5 installation
Platform |
Component |
File Name |
Default Location |
|
|
|
|
32-bit and |
Installation directory |
|
C:\Program Files\ |
64-bit Windows |
(referred to hereafter as |
|
Firebird\Fire- |
|
|
bird_1_5 |
|
(Windows 95, |
<InstallDir>) |
|
|
98, ME, NT, |
|
|
|
|
|
|
|
2000, XP, ...) |
Firebird server |
fbserver.exe (SS) or |
<InstallDir>\bin |
|
|||
|
|
fb_inet_server.exe |
|
|
|
(CS) |
|
|
|
|
|
|
Command-line tools |
gbak.exe, gfix.exe, |
<InstallDir>\bin |
|
|
gstat.exe, etc. |
|
|
|
|
|
|
Sample database |
employee.fdb |
<InstallDir>\exam- |
|
|
|
ples |
|
|
|
|
|
User-defined function |
ib_udf.dll & |
<InstallDir>\UDF |
|
(UDF) libraries |
fbudf.dll |
|
|
|
|
|
|
Firebird client |
fbclient.dll |
<InstallDir>\bin |
|
|
(with an optional |
(with an optional copy in |
|
|
gds32.dll, to support |
the Windows System dir |
|
|
legacy apps) |
– see note below table) |
|
|
|
|
5