Subject Connecting to Firebird2.1-classic from Perl.
Author Steve Cookson
Hi People,

For the last three weeks I have been trying to get a connection to a
Firebird Database under Kubuntu 9.04 (now 9.10).

I have a perfectly running application under Windows using ODBC, so I
thought it would be easier to use that here, however, apparently not so.

Firstly Firebird

Firstly it took a good ten days to get firebird installed, because of
missing dependencies and bugs in the installation. These seem to have been
fixed since Kubuntu 9.10 came out last week, so I now have a repeatable
Firebird install (see previous emails to Raja)


I tried unixODBC with both the odbcFb driver and the OdbcJdbc drivers, to no
avail. The ODBCConfig application continually crashed when trying to create
odbc.ini and odbcinst.ini files, so I built them by hand.

Although Flamerobin was connecting nicely, isql <dsn> consistently gave me

[ISQL]ERROR: Could not SQLConnect

So odbc is on hold for the time being.


So next I tried DBI::Interbase. The CPAN install here requires a number of
directories. The defaults didn't work and the install failed. So I tried
searching the folder structure to pick them out by eye. One of the problems
is that it looks for a gds.h file and there hasn't been one since 1.5.
According to
058.html "firebird2 no longer provides gds.h, as the entire user api is in

So this too needs more help.

So my question is: is there a very simple connection method that I can use
that just involves a simple install and/or connection string?

Sorry if I am coming over as a little frustrated :{

Thanks and regards