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

[gaggio]

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!!!

[mje]

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.

[Jenda]

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

[mje]

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.

[gaggio]

You got it!