Subject | RE: [firebird-support] Creating a database using DSQL |
---|---|
Author | Alan McDonald |
Post date | 2008-11-17T09:51:31Z |
> I need to do thisd, once I've attempted to connect a database and foundyour client app is going to create a database.
> 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
>
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