Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^5: DBI MSSQL LongReadLen issue

by mje (Deacon)
on Apr 10, 2014 at 08:52 UTC ( #1081774=note: print w/ replies, xml ) Need Help??


in reply to Re^4: DBI MSSQL LongReadLen issue
in thread DBI MSSQL LongReadLen issue

The problem is:

DescribeCol column = 2, name = O, namelen = 13, type = unknown(-152), +precision/column size = 0, scale = 0, nullable = 0 display size = 0 column length = 0 now using col 2: type = unknown (-152), len = 1, display size = 1, pre +c = 0, scale = 0

Column type -152 is unknown to your DBD::ODBC and in any case a call to SQLDescribeCol reports it as size=0 and SQLColAttributes reports display size=1 and column length = 0. For now you'll either have to upgrade to the latest DBD::ODBC which I believe supports MS_SQLS_XML_TYPE or you'll have to cast your m_oGroupDefinition to something else (a varchar).


Comment on Re^5: DBI MSSQL LongReadLen issue
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1081774]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (11)
As of 2014-09-18 15:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (116 votes), past polls