in reply to Creating a Firebird Database

Hi,

What have you tried so far?
Have you tried using DBI and the DBI driver for Firebird and InterBase .
Within the module documentation there are examples of how to use them both.

Hope this helps.

Martin

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

    Hi Martin,

    I've been using DBI and this is the code I've been trying to use:

    $dbh = DBI->connect("dbi:InterBase:dbname=/usr/local/firebird/security.fdb;ho +st=$host",$fbuser,$fbpass,{AutoCommit =>1}); my $create = qq(CREATE DATABASE '$host:/var/lib/firebird/$dbname.fdb' +user '$username' password '$password'); $dbh->do($create);

    When I try to run it I get these errors, which is what makes me think I might be connected to the wrong database.

    DBD::InterBase::db do failed: Unsuccessful execution caused by an unavailable resource.
    invalid database handle (no active connection)

    Thanks for all your help.

    Izabelle