[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