On Feb 13, 2008 5:53 AM, Helen Borrie <helebor@...> wrote:

> At 02:32 AM 13/02/2008, you wrote:
> >OK, now I can connect to the employee DB as SYSDBA with password masterkey
> using IBQ.
> >
> >(1) However, when I try to create a new DB using ISQL, it tells me that
> the user (SYSDBA) is not defined and that I should contact my SYS MGR.
> Something is wrong. Any ideas?
>
> Try doing COMMIT; before you attempt to create (and thus connect to) a new
> database. Then (assuming Windows):
> SQL>SET AUTO ON;
> SQL>SET SQLDIALECT 3;
> SQL>create database 'localhost:c:\path\to\database\newdb.fdb user 'SYSDBA'
> password 'xxxxxxxx';

I always do:

SQL>CREATE DATABASE 'c:\path\to\database\newdb.fdb' USER 'SYSDBA'
PASSWORD 'xxxxxxxxxx' ;

if I am connecting locally. I only use the host name if doing a remote
connection.

Fidel.