Hi Lucas,

I can not remember the documentation saying that you can't create a database
on a remote server. I think there are some limitations to creating secondary
database files on a remote server. I stand under correction.

Best Regards,
Don Schoeman


-----Original Message-----
From: Lucas Franzen [mailto:luc@...]
Sent: 16 July 2001 03:36
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Creating a database on the fly using IBO




Paul Schmidt schrieb:

>
> Dear List:
>
> I am trying to create a database on the fly, and it doesn't want to
> work. Okay, the database doesn't exist, so I set up a IB_Script
> object, I set up the connection, including the database name,
> username (SYSDBA), password, servername, and protocol type, hey it's
> enough to open an existing database, I load the SQL into the script,
> it
> looks like this:
>
> CREATE DATABASE 'lnxsrvr:/var/ib_data/dbmsname.gdb' USER 'SYSDBA'
> PASSWORD 'masterkey';

Is lnxsrvr the server where IB is running on?

If yes:
you can omit the machine name, since the database will be created by the
server which is running on this machine anyway and can only be created
on alocal drive/path from the server.

if not: it is impossible to create a database on network drive.

If this doesn't help try to delete the Connection and transaction
property of the script and re-add it.

Hth
Luc.



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/