Hi Mje,

Well apart from the install which proved a nightmare under Kubuntu 9.04, but mysteriously cleared up under 9.10 see Installing DBD::ODBC, in the end I gave up using ODBC for the Firebird 2.1 connection because I couldn't get the DATE (and I think also number formats) to work and there were a number of other stability issues which I can't remember. Instead I used the DBI::Interbase driver, while it works, it is subject to occasional crashes, so I'd like to go back to trying ODBC, if it turned out to be more stable.

My current main ODBC problem is that if I use isql on employee.fbd, (eg select first 1 change_date from salary_history), I get:

1992-12-15 00:00:00. (Data type TIMESTAMP)

if I use it on my own database, (eg select first 1 att_patient_examination_dtd from tbl_patient_exam), I get:

22256-10-18. (Data type DATE)

Any ideas what I could do?

Surely the DATE format should work? Other applications like Flamerobin have no such problems on the same field and they don't crash either.

Regards

Steve

In reply to Re^4: What is your favourite Linux or cross-platform database? by Steve_BZ
in thread What is your favourite Linux or cross-platform database? 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.