FreeTDS Development Group

[Victor Gamov <vit AT lipetsk.ru>]

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?