Thanks Lucas,

I think Paul should also try a loopback connection like you did, either
using IBO or IBConsole. He can then try the following (almost like you did):

Let's assume your own computer name is something like "PaulPC"...

Set the following TIB_Connection properties:
IB_Connection1.DatabaseName := 'PaulPC:C:\TestDB.GDB';
IB_Connection1.Protocol := cpTCP_IP;
IB_Connection1.Server := 'PaulPC';
IB_Connection1.Username := 'SYSDBA';
IB_Connection1.Password := 'masterkey';

Set the following TIB_Transaction properties:
IB_Transaction1.IB_Connection := IB_Connection1;

Set the following TIB_Script properties:
IB_Script1.IB_Connection := IB_Connection1;
IB_Script1.IB_Transaction := IB_Transaction1;
IB_Script1.SQL :=
'CREATE DATABASE ''PaulPC:C:\TestDB.gdb'' USER ''SYSDBA'' PASSWORD
''masterkey''';

Paul, changing the IBO properties to suite your needs to something similar
I've shown above should create your database. What happens if you try and
create the database on the linux machine via your Windows PC using
IBConsole? I don't know Linux at all but I think you must enter the complete
and absolute directory path for the database.

Best Regards,
Don Schoeman



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




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/

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