in reply to Re: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns
in thread [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns

Thank you for the DBI_TRACE tip.

After having enabled tracing, I easily found what the problem was: the default LongReadLen of 80 was not sufficient to grab the full XML strings, resulting in the abortion of the query.

Solved!!!

  • Comment on Re^2: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns

Replies are listed 'Best First'.
Re^3: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns
by mje (Curate) on Jul 22, 2010 at 06:47 UTC

    Glad you are working although I might have pointed at LongReadLen myself if you hadn't given the impression you were getting no data back at all for that column.

[reply]

      Except that he wasn't getting any data back. The LongTruncOk was false, so the query failed returning no rows.

      Jenda
      Enoch was right!
      Enjoy the last years of Rome.

[reply]

        ok, so LongTruncOk was false but unless the OP had also disabled PrintError and RaiseError he should have got a "String data, right truncation" error. The only point I was attempting to make was that a little bit more information here would not have hurt.

[reply]
        You got it!
[reply]

In Section Seekers of Perl Wisdom