OK, well here's the rub. Having spent weeks getting DBD:InterBase working, it's absolutely horrible with 2.1. Acording to the doc, it's been tested with 1.5, so although it works after a fashion, it mangles dates, truncates fields and crashes doing a while/fetch. So, very disapointing. However, ODBC has mysteriously sprung into life, maybe it was the transition to Kubuntu 9.10, which seems more stable, for firebird at least. Anyway here are the ODBC instructions, which I found somewhere, I'd like to give credit, but sadly I can't remember:

Installing the Firebird Database ODBC Driver

The Firebird ODBC driver is not in the Ubuntu repositories so it has to be downloaded from the FirebirdSQL site: http://www.firebirdsql.org/download/prerelease/odbc/OdbcFb-LIB-RC1-2.0.0148.i686.tar.gz

It contains a single file named "libOdbcFb.so". Copy this file to the /usr/lib directory.

Next make sure you have the Firebird client library installed: apt-get install libfbclient2

Openoffice and probably a few other programs will insist on using a driver named libgds.so for connecting to a Firebird database. A symbolic link will have to be created:

nb: I didn't do this ln -s /usr/lib/libfbclient.so.2 /usr/lib/libgds.so At this point you are ready to add some entries to the odbc config files. If they don't already exist you can create them.

Here's another example odbc.ini: 

[DBNAME]
Description = Firebird
Driver = Firebird
Dbname = localhost:/var/lib/firebird/2.1/data/employee.fdb
User = SYSDBA
Password = xxxxx
Role =
CharacterSet =
ReadOnly = No
NoWait = No

[download]

And the relevant entries for the odbcinst.ini file: 

[Firebird]
Description = InterBase/Firebird ODBC Driver
Driver = /usr/lib/libOdbcFb.so
Setup = /usr/lib/libOdbcFbS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =

[download]

You should now be able to connect to DBNAME from OpenOffice or other programs using the ODBC connection method.

Regards

Steve

In reply to Re^2: Getting a Perl connection to a Firebird2.1-classic database in Kubuntu 9.10 [SOLUTION] by Steve_BZ
in thread Getting a Perl connection to a Firebird2.1-classic database in Kubuntu 9.10 by Steve_BZ

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.