InterBase (29)
MS-SQL (63)
mysql (163)
Oracle (327)
Exchange Links
About this site
Setup and create my first Firebird database on Windows?
12 comments. Current rating: 
(9 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
Content-type: text/html
|
||||||||
Comments:
| ||
| ||
|
thank you very much, this article helped me a lot
| ||
| ||
|
Any suggestions for a GUI to use with the Windows version of Firebird 2.0?
| ||
| ||
|
short, clear, strait to the point. thanks!
| ||
| ||
|
I like to use Marathon with Firebird. IBExpert from HK-Software works well too.
| ||
| ||
|
thanks a lot!
| ||
| ||
|
SUUUUUUUPEEEEEER!!!!!!!!!!
| ||
| ||
|
Thank you so much
| ||
| ||
|
Use Maestro Firebird as GUI for creating database in Firebird.
| ||
| ||
|
Great.
| ||
| ||
|
In the earliest database systems, efficiency was perhaps the primary concern, but it was already recognized that there were other important objectives. One of the key aims was to make the data independent of the logic of application programs, so that the same data could be made available to different applications. Thanks.
Regards, <a href='  http://www.fivebutt..m/'>WEB DESIGN COMPANY</a>
| ||
| ||
|
In the earliest database systems, efficiency was perhaps the primary concern, but it was already recognized that there were other important objectives. One of the key aims was to make the data independent of the logic of application programs, so that the same data could be made available to different applications. Thanks.
Regards, <a href=' http://www.fivebutt..m/'>WEB DESIGN COMPANY</a>
|
