community.borland.com

Article #25615: A possible solution for "unavailable database" errors on Database Create

Problem:
I am getting these errors when I try to create a database:
Use CONNECT or CREATE DATABASE to specify a database
Statement failed, SQLCODE = -904
unavailable database

I know the database is "unavailable".  It doesn't exist yet.   I am not sure what I am doing wrong. 
Here is my create statement:
CREATE DATABASE 'd:temptest2.gdb' USER 'SYSDBA' PASSWORD 'masterkey';

Solution:
*************************************************************************************

Your create statement is fine.   You need to make sure you have the InterBase server
running locally when you try to create a local database.   If  you are connecting to a 
remote server, make sure the InterBase server is running on the remote machine. 
 If you do not have InterBase server running on your machine, it will not allow you to 
create a database on your machine's hard drive and you will get the series of errors 
you experienced.

Last Modified: 26-OCT-00