[freetds] Getting XML document from MS SQL2000
Victor Gamov
vit at lipetsk.ru
Thu Jul 3 18:07:12 EDT 2003
Lowden, James K wrote:
>>From: Victor Gamov [mailto:vit at lipetsk.ru]
>>Sent: June 25, 2003 11:19 AM
>>
>>When I try to get XML document from MS SQL2000 I've got the
>>following in dump file:
>>
>>pid: 19395:2003-06-25 18:37:24.836991 inside _ct_get_client_type(type
>>35, size 2147483646)
>
> ^^^^^^^^^^
> What is your text size set to?
>
>>pid: 19395:2003-06-25 18:37:24.837049 inside ct_describe()
>>datafmt->datatype = 16 server type 35
>>pid: 19395:2003-06-25 18:37:24.837599 inside ct_cancel()
>>
>>(but packet with XML document already received from server)
>
>
> Try "set textsize 16000" (or whatever's sufficient for you) before issuing
> the query. Nowadays you can set "text size" in your freetds.conf, but I'm
> not sure 0.60 supports that.
Thanx!
text size = 65535 works fine in 0.60.
But I still have a problem. I see requested document in FreeTDS dump
file but never see in DBI software.
fetchall_arrayref() returns array with 1 element but it's empty.
FreeTDS-0.60/0.61
DBD-Sybase-0.94
More debug info?
Or more upgrade?
More information about the FreeTDS
mailing list