Paul Schmidt schrieb:

>
> Hello List:
>
> Finally got this to work, and BTW it should be:
>
> CREATE DATABASE 'servername:/path/file.gdb' USER 'username' PASSWORD
> 'password';
>
> However I now have a problem, I need to create it using SQL DIALECT
> 1, and that presents a problem, how do I tell it to use dialect 1?
> Sending the "SET SQL DIALECT 1' command in the script, doesn't pass
> this on to the server.
>
> The reason for this is I am using Firebird, and the client has to use
> IB 5.6, and I don't want to have to create seperate versions of the
> SQL.

CREATE DATABASE
'servername:/path/file.gdb'
PAGE_SIZE 4096
DIALECT1
USER 'SYSDBA' PASSWORD 'masterkey'
DEFAULT CHARACTER SET WIN1252;

HTH
Luc.