Path is known, Database is a personal one per client, created as needed. That's why the admin can't do it.
So I still need to know what is the best way to do this.
Regards,
Norman

----- Original Message -----
From: Alan McDonald
To: firebird-support@yahoogroups.com
Sent: Monday, November 17, 2008 11:51 AM
Subject: RE: [firebird-support] Creating a database using DSQL


> I need to do thisd, once I've attempted to connect a database and found
> it to be absent. the Docs, and Helen's book make reference to using
> EXECUTE IMMEDIATE weith CREATE DATABASE, but not terribly explicitly.
> It looks cumbersone because you're using EXECUTE IMMEDIATE to execute a
> prepared script. Wouldn't it make more sense to simply call isql and
> pass it the prepared database creation script anyway? Once the databse
> is created, then one can connect in the normal manner form within the
> application.
> Regards,
> Norman
>

your client app is going to create a database.
Do you (the client) know where the server wants to store databases? The path
is known?
If you want to use an alias, then someone (admin) already has placed the
path in the aliases.conf file. Why isn't there a step in this case for the
admin to place a database where they (the admin) wants?
If it were me, I would not let a client app create databases on my server
but that's just me, maybe.
Alan






------------------------------------------------------------------------------



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1793 - Release Date: 11/16/2008 7:58 PM


[Non-text portions of this message have been removed]