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

Reduce code to a simple connect and select. Enable DBI tracing by setting and exporting the DBI_TRACE environment variable to something like 15=x.log. Run your code and post the log file output.

export DBI_TRACE=15=x.log

[download]
or 
set DBI_TRACE=15=x.log

[download]

Replies are listed 'Best First'.
Re^2: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns
by gaggio (Friar) on Jul 22, 2010 at 00:45 UTC

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

[reply]

      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]

In Section Seekers of Perl Wisdom