Subject Re: [firebird-support] before creating a database
Author Helen Borrie
At 10:00 AM 9/03/2005 +0800, you wrote:


>guyz is there i want to be aware before successfully creating a
>database? any dll's needed to put in a proper places?

The client dll is called fbclient.dll. By default, on the server, it is in
Firebird's bin directory. Third-party tools and -- depending on your
programming environment - your applications, need it to be in the %system%
directory, renamed as gds32.dll. It contains the application programming
interface. However, isql doesn't use the client library as it has it talks
to the API directly.


>i have just downloaded Firbird1_5 and installed as classic into a
>windowsXP and as a process

Then the service fb_inet_server should appear in your Services display.

>i had read the pdf on how to create a database but have no luck.

It is not a question of "luck". Were you able to start ISQL?

>i have googled but still the net goes back to the pdf file ..

That's good, because that's what you need.


>there is no error messages (at this time) but i can't see the created
>database

You should go back to the PDF and follow the instructions there. However,
because Classic won't do a "local connect", you have to include the server
name 'localhost':. and we assume here that you *already* created the
folder where the database file will be written.

SQL>CREATE DATABASE 'localhost:D:\data\test.fdb' page_size 8192
CON>user 'SYSDBA' password 'masterkey';

SQL> and CON> are prompts in the ISQL shell - you are not meant to type them.

>aside from the pdf i also have this one as my reference
>http://www.firebirdsql.org/manual/qsg15-creating.html

They are the same: the doc project generates both the PDF and the html
from the same XML source.

./hb