CREATE DATABASE 'C:\virtualtarget.fdb' USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192;

try lake this. (Order like syntax)

CREATE {DATABASE | SCHEMA} ' filespec'

[USER ' username' [PASSWORD ' password']]

[PAGE_SIZE [=] int]

[LENGTH [=] int [PAGE[S]]]

[DEFAULT CHARACTER SET charset]

[ <secondary_file>];

<secondary_file> = FILE ' filespec' [ <fileinfo>] [ <secondary_file>]

<fileinfo> = [LENGTH [=] int [PAGE[S]] | STARTING [AT [PAGE]] int }

[ <fileinfo>]



But the problem un ISQL is the same. I always create database using .sql
file and run as ISQL IN C:\myFile.sql in command pront.



Best regards.

----- Original Message -----
From: "Bahadir ARMAGAN" <barmagan@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday,01 December, 2003 03:18 AM
Subject: [firebird-support] unavailable database


I have started isql.exe and tried to create a database:

SQL> CREATE DATABASE 'C:\VIRTUALTARGET.FDB' page_size 8192 user 'SYSDBA'
password 'masterkey';
Statement failed, SQLCODE = -904

unavailable database
SQL>

Database service seems to be running:
"Freebird Server - DefaultInstance Started Automatic"

what is the problem?

TRANSVARO Elektron Aletleri San. ve Tic. A.S.

Address: Fatih Cad. Dereboyu Sok. No:12
34660 Halkali - Istanbul - Turkey
Phone: +90 (212) 473 0100
Fax: +90 (212) 473 0155
URL: http://www.transvaro.com.tr
E-Mail: mail@...

NOT: Bu elektronik posta mesaji gizli olup, ayni zamanda ayricalikli
olabilir; sartlar ne olursa olsun, gondericinin onceden onayini almaksizin,
baskalarina iletmemeniz, icerigini kopyalamamaniz veya baskalarina
aciklamamaniz gerekmektedir. Bu mesajin muhatabi degilseniz, bu durumu
derhal tarafimiza bildirmenizi rica ederiz. Internet üzerinden yapilan
iletisim guvenli olmayip, verilerin kasten veya tesadufen bozulmasi ve virus
icermesi olasiligi vardir. Ayrica, elektronik posta, resmi olmayan ve
cogunlukla kisaltilmis bir iletisim yontemidir. Dolayisiyla, burada yer alan

bilgi veya tavsiyelere, gonderici ile ayrica gorusmeden guvenmeniz normal
sartlar altinda uygun olmayabilir.

NOTE: This e-mail is confidential and may also be privileged; under no
circumstances should you forward it, or copy or disclose its contents, to
any other person without the prior consent of the sender. If you are not an
intended recipient of this e-mail, please notify us immediately. Internet
communications are not secure and subject to possible data corruption,
either accidentally or on purpose, and may contain viruses. Furthermore
e-mail is an informal and often abbreviated method of communication. For
these reasons, it will normally be inappropriate to rely on any nformation
or advice contained herein without also discussing it with the sender.




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/