I see I commented on the thread you mention and I would not describe it as a nightmare. DBD::ODBC needs an ODBC driver manager but as it is XS code it also needs the driver manager header files. Many Linux distributions distribute the header files in different packages and you hadn't installed the development package.

I cannot say why isql is returning a timestamp but I'd guess this is down to the ODBC driver and not unixODBC or DBD::ODBC (neither of which change data types). Many bugs in ODBC drivers are attributed to earlier elements of the ODBC stack, e.g., isql perhaps in this case or unixODBC or DBD::ODBC. I'm guessing when you see a date, you are not using the ODBC driver.

It may also help to know which ODBC driver you are using.

unixODBC and DBD::ODBC have been around for years and years. I'm not going to say they are perfect and have no bugs but they are mature and pretty stable in most peoples definition of stable.

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