Hi People,

For the last three weeks I have been trying to get a connection to a Firebird Database under Kubuntu 9.04

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 have a repeatable Firebird install.

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. The lib directory was obvious (I hope), but then it asked for the "include" directory, but there isn't one.

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

In reply to 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.