Subject Re: [ib-support] how create a gdb by delphi?
Author Jill Thomson
At 22:18 12/01/02 +0000, enio ? wrote:
>hi
>I'm try create a gdb from TIBDataBase.
>I'm doing the following
>
> ib.Params.Add('user_name=SYSDBA');
> ib.Params.Add('password=my_password');
> ib.Params.Add('lc_ctype=WIN1252');
> ib.DatabaseName := 'C:\FILE.GDB';
> ib.CreateDatabase;
>
>When I exec "ib.CreateDatabase" I receive this message "Your user
>name and password are not defined. Ask your database administrator to
>set up an InterBase login..."
>I'm have sure the user and password is correct.
>I already try "ib.DatabaseName := 'computer_name:C:\FILE.GDB';"
>What I must to do to create this gdb???

This is really an IBX question, but here goes:

Correct syntax is
ib.Params.Clear; // just in case
ib.Params.Add('USER "SYSDBA"');
ib.Params.Add('PASSWORD "my_password"");

rest should be OK (not sure about Ic_ctype - don't use it)

It took me a long time to find the answer to this too :>)

Peter Lawson