Board index » delphi » Creating databases using scripts from within IBConsole.
Paul
Delphi Developer |
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. |