[fpc-pascal] Re: SqlDB fails under Windows to create a new Firebird database

[Graeme Geldenhuys]

>
>
>
>
> Here is the console output of when I run the program.
>
> -----------------------
>
> c:\programming\m2_system\Scripts>makedb -d 
> '127.0.0.1:c:\programming\data\m2_dl_3019.fdb'
> Creating database... '127.0.0.1:c:\programming\data\m2_dl_3019.fdb'
> exception at 00431BD8:
> : CreateDB :
> -I/O error during "open" operation for file ""
> -database or file exists.
> -----------------------

Ah, found the problem. In Windows it seems you mustn't wrap the -d 
command line parameter value with quotes. Removing the single quotes 
in the above command line fixed the problem. Linux and FreeBSD didn't 
mind the quoted string value.

------------------------

c:\programming\m2_system\Scripts>makedb -d 
127.0.0.1:c:\programming\data\m2_dl_3019.fdb
Creating database... 127.0.0.1:c:\programming\data\m2_dl_3019.fdb
running... create_firebird.sql
running... views.sql
running... rights.sql
running... defaults.sql
------------------------


I haven't tested what happens if you specify a path under Windows that 
contain spaces, but will test it later. I would imagine quotes must be 
used, but not sure how yet.


Regards,
  Graeme