At 09:16 AM 04-11-02 -0800, you wrote:

>Hello Marco,
>
>Thank you for the info. I regret that my first post was not clear. I am
>needing to know how to make a new database from a clean install of
>Firebird WITHOUT any GUI tool. It will need to be done from a script or EXE.
>
>Again thank you for trying and I apologize for not being clear,

Well, I'm still not certain that it's clear. You can use the isql
command-line tool to run a script (hint: read the OpGuide) or you can write
an EXE (for use on a Windows server) using a toolset designed to create an
exe with capability to run a Firebird script; or you can use an already
existing tool that can do that (but most if not all such offerings are GUI
tools...)

If you want to go the isql route, take yourself through a "Teach Yourself
isql" program (about 3 minutes' reading) and write a script something like
the following, for use with the INPUT statement:

/* beginning of script */
SET AUTO ON ; /* <---------- terminator character */
CREATE DATABASE 'D:\Path\db.gdb' /* for a Windows server */
or
/* CREATE DATABASE '/filepath/db.gdb' for a Linux server */
USER 'user' PASSWORD 'pass'
/* PAGE_SIZE = 1024 not recommended: too small */
PAGE_SIZE = 8192
DEFAULT CHARACTER SET WIN1251 ; /* <---------- terminator character */
SET AUTO ON ; /* <---------- terminator character */
/* Other definitions */
[include a page feed here]

If you run this script inside the interactive shell of isql, you will be
connected to the database once it is created.

If you run it using the command-line switches, you will need a CONNECT
statement to connect to the database subsequently. The syntax for
connecting from the command line is slightly different to that for
connecting from within the isql shell - see the docs.

Good luck!
heLen