Subject | Newbie trying to create databas |
---|---|
Author | andrewstuartxx2000 |
Post date | 2004-09-26T06:05:47Z |
Hello I am a FGirebird newbie trying to create a database. ere's
what happens. (Firebird 1.5 Linux redhat Fedora core 2, lots of
diskspace)
[root@xseappserver fb]# isql -h
Unknown switch: h
isql [<database>] [-e] [-t <terminator>] [-i <inputfile>] [-o
<outputfile>]
[-x|-a] [-d <target db>] [-u <user>] [-p <password>]
[-page <pagelength>] [-n] [-m] [-q] [-s <sql_dialect>]
[-r <rolename>] [-c <num cache buffers>] [-z] -nowarnings -
noautocommit
[root@xseappserver fb]# isql -u sysdba -p xRviTb7O
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE './xsecore.gdb' DEFAULT CHARACTER SET UNICODE;
Statement failed, SQLCODE = -902
I/O error for file "/home/sshlogin/fb/xsecore.gdb"
-Error while trying to create file
-Permission denied
SQL>
Any help would be much appreciated.
Could you please email a copy of any responses to
a n d r e w . s t u a r t @ x s e . c o m . a u
Thanks
Andrew Stuart
what happens. (Firebird 1.5 Linux redhat Fedora core 2, lots of
diskspace)
[root@xseappserver fb]# isql -h
Unknown switch: h
isql [<database>] [-e] [-t <terminator>] [-i <inputfile>] [-o
<outputfile>]
[-x|-a] [-d <target db>] [-u <user>] [-p <password>]
[-page <pagelength>] [-n] [-m] [-q] [-s <sql_dialect>]
[-r <rolename>] [-c <num cache buffers>] [-z] -nowarnings -
noautocommit
[root@xseappserver fb]# isql -u sysdba -p xRviTb7O
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE './xsecore.gdb' DEFAULT CHARACTER SET UNICODE;
Statement failed, SQLCODE = -902
I/O error for file "/home/sshlogin/fb/xsecore.gdb"
-Error while trying to create file
-Permission denied
SQL>
Any help would be much appreciated.
Could you please email a copy of any responses to
a n d r e w . s t u a r t @ x s e . c o m . a u
Thanks
Andrew Stuart