- •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
Platform |
Component |
File Name |
Default Location |
|
|
|
|
Linux and pos- |
Installation directory |
|
/opt/firebird |
sibly other |
(referred to hereafter as |
|
|
UNIX distros |
|
|
|
|
<InstallDir>) |
|
|
|
|
|
|
|
Firebird server |
fbserver (SS) or |
<InstallDir>/bin |
|
|
fb_inet_server (CS) |
|
|
|
|
|
|
Command-line tools |
gbak, gfix, gstat, etc. |
<InstallDir>/bin |
|
|
|
|
|
Sample database |
employee.fdb |
<InstallDir>/exam- |
|
|
|
ples |
|
|
|
|
|
UDF libraries |
ib_udf.so, fbudf.so |
<InstallDir>/UDF |
|
|
|
|
|
Firebird client |
libfbclient.so.- |
/usr/lib |
|
|
1.5.n (binary); |
(actually, the real stuff is |
|
|
libfbclient.so.1, |
|
|
|
libfbclient.so |
in <InstallDir>/lib, |
|
|
(symlinks) |
but you should use the |
|
|
Legacy libgds* sym- |
links in /usr/lib) |
|
|
|
|
|
|
links are also installed. |
|
|
|
|
|
Note
The exact path to the Windows System directory depends on your Windows version. Typical locations are:
•for Windows 95/98/ME: C:\Windows\System
•for Windows NT/2000: C:\WINNT\System32
•for Windows XP: C:\Windows\System32
Installing Firebird
Installing the Firebird server
Installation drives
Firebird server – and any databases you create or connect to – must reside on a hard drive that is physically connected to the host machine. You cannot locate components of the server, or any database, on a mapped drive, a filesystem share or a network filesystem.
6