At 09:40 PM 22-05-02 +0000, you wrote:

>Hi to all,
>
>I'm using IBConsole(on IBClient) to create a database in my server, how can
>I specify the path where the file(s) of my database will reside, in the
>server.(both, server and client are running in win2000 Pro)

Locally:
CREATE DATABASE 'd:\mypath\mydatabase' page_size 8192 user 'sysdba'
password 'masterkey'

From a TCP/IP client:
CREATE DATABASE 'MyServer:d:\mypath\mydatabase' page_size 8192 user
'sysdba' password 'masterkey'

From a NetBEUI client:
CREATE DATABASE '\\MyServer\d:\mypath\mydatabase' page_size 8192 user
'sysdba' password 'masterkey'

The path MUST be a physical drive on the same machine as the server - no
mapped drives, no shares.

cheers,
Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________