Okay, I'm running under the assumption that the dev machine hits one of the NT boxen, while the test machine hits the other. Let me know if this is incorrect.

What's your $ENV{TDSVER} set to? With MSSQL 6.5, you should have both of the DECs set to '42'. I don't think this is related to your inconsistent DBI versions, since your test machine is actually higher versions of both Perl and DBI.

However, the key here may be the DBD version. I'm not 100% sure that FreeTDS has been tested with 0.23. The FreeTDS website lists 0.20, but it's been that way for a while. I'm also trusting that you followed instructions for building the libs.

You say that the code works on the dev machine, but not the test machine. Is it the exact same code? Finally, you may wish to subscribe to DBI Users mailing list. I've seen the problem you refer to, but aside from creating a second dbh, I've not solved it. My own problem lies in the fact that only about half of my subqueries produce this error, so I haven't been as perturbed by it.

ALL HAIL BRAK!!!

In reply to Re: strange DBI behaviour by PsychoSpunk
in thread strange DBI behaviour by tune

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.