in reply to Creating a Firebird Database

Hi,
I'm not sure it is possible to create the database via Perl as you need to specify the database name in the Ds string.
But if you run your Perl script on the same box as the Firebird daemon, you might be able to use
system('isql');
Why can you not first create the database using the usual tools (isql) and then connect to the empty database with perl and proceed?
Regards,
svenXY

Replies are listed 'Best First'.
Re^2: Creating a Firebird Database
by Anonymous Monk on Sep 22, 2005 at 14:51 UTC

    The aim of the script is to provide one place for creating MySQL, SQL and Firebird accounts for users, printing off a sheet for them to take away with their account details.

    Unfortunately Firebird and Perl aren't on the same box so I can't use system.

    The back up plan is to use isql as you suggested, it would just be more convenient to have everything in the same place.

    Thanks again for your help.

    Izabelle

[reply]
      Surely once you have created the database you will be able to use DBI to interface with it to create users or whatever? Am I missing your point here?

      Martin
[reply]

        Each user gets their own database, so when they request an account a database needs to be created for them as well as a username and password. Sorry if I did not make this clear.

        Izabelle

[reply]

In Section Seekers of Perl Wisdom