Board index » delphi » Creating databases using scripts from within IBConsole.

Creating databases using scripts from within IBConsole.


2007-02-15 04:40:00 AM
delphi157
Hi all,
Could anybody tell me why this doesn't work?
---------------------------------
SET SQL DIALECT 3;
CREATE DATABASE
'127.0.0.1/gds_db:D:\Paul_bis\Hungarian\TestProject1\szot.gdb' DEFAULT
CHARACTER SET UNICODE_FSS PAGE_SIZE 4096 USER 'SYSDBA' PASSWORD
'MASTERKEY';
-------------------------------
Error is
--------------------------------
Error at line 3
Your user name and password are not defined. Ask your database
administrator to set up an InterBase login
SQL - CREATE DATABASE
'127.0.0.1/gds_db:D:\Paul_bis\Hungarian\TestProject1\szot.gdb' DEFAULT
CHARACTER SET UNICODE_FSS PAGE_SIZE 4096 USER 'SYSDBA' PASSWORD
'MASTERKEY'
-------------------------------
TIA.
Paul...
--
plinehan __at__ yahoo __dot__ __com__
XP Pro, SP 2,
Oracle, 10.2.0.1 (Express Edition)
Interbase 6.0.2.0;
When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.
 
 

Re:Creating databases using scripts from within IBConsole.

Paul writes:
Quote


Hi all,


Could anybody tell me why this doesn't work?


---------------------------------
SET SQL DIALECT 3;

CREATE DATABASE
'127.0.0.1/gds_db:D:\Paul_bis\Hungarian\TestProject1\szot.gdb' DEFAULT
CHARACTER SET UNICODE_FSS PAGE_SIZE 4096 USER 'SYSDBA' PASSWORD
'MASTERKEY';
-------------------------------

Error is
--------------------------------
Error at line 3
Your user name and password are not defined. Ask your database
administrator to set up an InterBase login
SQL - CREATE DATABASE
'127.0.0.1/gds_db:D:\Paul_bis\Hungarian\TestProject1\szot.gdb' DEFAULT
CHARACTER SET UNICODE_FSS PAGE_SIZE 4096 USER 'SYSDBA' PASSWORD
'MASTERKEY'
-------------------------------

TIA.


Paul...
Passwords are casesensitive.
Try 'masterkey'
--
 

Re:Creating databases using scripts from within IBConsole.

Paul <XXXX@XXXXX.COM>writes:
Doh <slaps forhead and reaches for a Duff>
After much grinding of teeth and Googling, I found it.
Quote
Paul...
--
plinehan __at__ yahoo __dot__ __com__
XP Pro, SP 2,
Oracle, 10.2.0.1 (Express Edition)
Interbase 6.0.2.0;
When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.