Don Schoeman schrieb:

>
> I actually did understand you Lucas, I'm just thinking that it is possible
> to create a database via a remote machine. Is it written somewhere that you
> can not create a new database via a network/remote machine?
>
> For example:
>
> If you set your IB_Connection.DatabaseName property to
> lnxsrvr:/var/ib_data/dbmsname.gdb and you set your
> IB_Connection.DatabaseName property to cpTCP_IP, surely the script should
> execute successfully. I think it would be a major pain if IB/FB can not
> create databases from a remote machine.

Don,

still I don't disagree with you.
It is possible, ofcourse and I didn't say anything else...

I just asked Paul if "lnxsrvr" is the name of the machine where the
IBServer is running on.


Since I got no network access at the moment I did try this:

I put a TIB_Connection, TIB_Transaction and TIB_Script on a datamodule
and link them together.

The TIB_Connection gets the properties:
USERNAME: SYSDBA
PASSWORD: masterkey
PROTOCOL: cpTCP_IP
PATH (not DATABASENAME!): C:\testme.gdb (but I can leave it blank, too)

In the script I enter:

CREATE DATABASE 'localhost:C:\testme.gdb'
USER 'SYSDBA' password 'masterkey'

I can execute this statement within the script without any error and the
database exists afterwards (the only error I had was when I entered
SYSBDA instead of SYSDBA (it was just a typo) ).

So the problem should be something else.

Luc.

>
> Best Regards,
> Don Schoeman
>
> -----Original Message-----
> From: Lucas Franzen [mailto:luc@...]
> Sent: 16 July 2001 04:00
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Creating a database on the fly using IBO
>
> Don Schoeman schrieb:
> >
> > 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.
>
> Don,
>
> maybe I didn't express myself correct.
>
> I didn't want to say you can't create a database on a remote server, I
> wanted to say you can't create a database where the database-file is not
> on the server itself!
>
> So the filename of the database has to point to a "local path" as seen
> by the server itself.
>
> Luc.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/