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)

Next ODBC
_________

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.

DBI::Interbase
______________

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
http://www.mail-archive.com/libdbi-drivers-devel@.../msg00
058.html "firebird2 no longer provides gds.h, as the entire user api is in
ibase.h."

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

Steve