At 12:49 PM 16/09/2003 +0530, you wrote:

>Thanks Helen,
>
>But I find some problems creating the database
>When I execute in IB_WISQL, I get an error which reads "Invalid database
>handle"
>When I execute in IB Expert, I get an error which reads "unknown win 32
>error 3"
>I have IB 6.0 installed on my PC. I have tried changing the file ext to gdb
>even then the I could not create the DB.
>
>Thanks for help
>VigneZ
>
>2.How to create a multi file DB ,each of size 1Gb and with Dialect 3?
>
>On a Windows server, the following will create a database of three files,
>each able to store up to 1 Gb:
>CREATE DATABASE 'd:\data\MyData.fdb'
> USER 'SYSDBA' PASSWORD 'masterkey'
> PAGE_SIZE 8192
> FILE 'd:\MyData1.fdb' <--- sorry, should be same directory path as
> primary file - 'd:\data\MyData1.fdb'
> STARTING AT PAGE 128001 /* pages */
> FILE 'd:\MyData2.fdb' <--- sorry, should be same directory path as
> primary file - 'd:\data\MyData2.fdb'
> STARTING AT PAGE 256001 LENGTH 128000; /* length on last file only */

Sorry, bad copy/pasting, I omitted the /data/ subdir from the filespecs of
the two secondary files. (This is only an example - use your own filespecs!!)

btw, you must create the directory yourself. CREATE DATABASE doesn't do it
for you.

heLen