InterBase (28)
MS-SQL (5)
mysql (32)
Oracle (1)
Exchange Links
About this site
Setup and create my first Firebird database on Windows?
6 comments. Current rating: 
(4 votes). Leave comments and/ or rate it.
Question:
How do I setup and create my first Firebird database on Windows?Answer:
Follow these instructions:##
## Setting up Firebird SQL server on Windows 2003 Server
##
## Setup, create user, create database, login
##
##
##
## I am sure this works fine on all other windows versions,
## I just happened to do this on Win2k3.
##
- Download and Install the Firebird application (as superserver and service) into %systemdrive%\fbsql I installed into d:\fbsql, and I will use this as my example, you may have another. I believe the default is c:\Program Files\Firebird SQL. When I installed I basically selected all the defaults except for my install path.
- after install start service
- Go to Start, Run, and open cmd promt:
cd d:\fbsql
bin\gsec -user sysdba -password masterkey -database
localhost:d:\fbsql\security.fdb
- Once in GSEC... you have a prompt: GSEC>
GSEC> Add dbuser -pw yourpassword -fname fullname
GSEC> display
GSEC> quit
- Next open the sample database:
bin\isql localhost:d:\fbsql\examples\employee.fdb -u dbuser -p
yourpassword
- Now lets create mydb, you now have a prompt: SQL>
SQL>create database 'localhost:d:\fbsql\mydb.fdb';
SQL>exit;
- You now have a new database created
and you should be able to log in like so:
d:\fbsql\bin\isql localhost:d:\fbsql\mydb.fdb -u dbuser -p yourpassword
- OR - from a remote host (if you installed the client)
pathto\isql servername:d:\fbsql\mydb.fdb -u dbuser -p yourpassword
-as I mentioned I used the non-default path for my server installation: d:\fbsql
-The main key for this to work for me was to use the 'host:path\to\file.fdb' syntax.
For example, the documentation stated simple commands like so:
gsec -user sysdba -password masterkey isql -u sysdba -p masterkey These did not work for me, I had to supply the host and db file for each to work. On gsec I had to supply the -database switch that specified the correct security database. So, my commands that worked:
gsec -user sysdba -password masterkey -database
localhost:d:\fbsql\security.fdb
isql localhost:d:\fbsql\mydb.fdb -u dbuser -p yourpassword
Comments:
