You don't say whether or not the failure of the query is dependent on the data being input - I'd be suspicious that that might be at the root of the issue. Have you been able to try an example of the query which fails through another interface (like query analyser)? This would at least give you some pointers on whether it's DBD, ODBC or SQL server causing the problem

The error message is not well documented (it's SQL error number 7133), but I assume from its text that you're trying to update a long data field (text, ntext, image). I've experienced some (different) complications accessing long data fields through ODBC, but rather than waste hours on them, I used the sqloledb interface instead.

Check the data first of all, as if this was a problem with ODBC I suspect it would fail 100% rather than intermittently.

UPDATE: Just been reading up on UPDATETEXT in MSSQL books online. Have you checked that the row to be updated actually exists - the null pointer error suggests that it might not.

In reply to Re: OT?>> DBD::ODBC::st execute failed: NULL textptr passed to UpdateText function-- why?? by terce
in thread OT?>> DBD::ODBC::st execute failed: NULL textptr passed to UpdateText function-- why?? by JupiterCrash

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.