Skip to Content.
Sympa Menu

freetds - set textsize 1048576 fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Cameron <cameron AT stl.dec.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: set textsize 1048576 fails
  • Date: Thu, 25 Oct 2001 12:29:08 +1000


Summary: a query of 'set textsize 1048576' fails on 0.52 but works on an
earlier version.

I've just tried some of my PHP code that uses FreeTDS on a different
system, with a slightly different version of FreeTDS. SELECT queries
work fine, but if I use a 'set textsize' query, then sybase_query()
returns FALSE and no further queries on the connection succeed.

I've yet to try the current CVS copy.

Non-working system:
FreeTDS 0.52-3 (Debian package freetds0)
PHP 4.0.5-2 (Debian packages php4 and php4-sybase)

Working system:
FreeTDS from CVS, 6th November 2000
PHP 4.0.5 (CGI version, installed by hand)

TDSDUMP of failed query, less login.

2001-10-25 11:24:45 inside tds_process_login_tokens()
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is e3
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is ab
2001-10-25 11:24:48 Msg 5701, Level 0, State 2, Server EVTSQL, Line 0
Changed database context to 'CSMain'.
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is e3
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is e3
2001-10-25 11:24:48 increasing block size from 4096 to 4096
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is fd
2001-10-25 11:24:48 leaving tds_process_login_tokens() returning 1
2001-10-25 11:24:48 leaving ct_connect() returning 1
2001-10-25 11:24:48 inside ct_cmd_alloc()
2001-10-25 11:24:48 inside ct_command()
2001-10-25 11:24:48 inside ct_send()
Sending packet @ 2001-10-25 11:24:48
0000 01 01 00 1d 00 00 00 00 73 65 74 20 74 65 78 74 |........set
text|
0010 73 69 7a 65 20 31 30 34 38 35 37 36 0d |size 1048576.|


2001-10-25 11:24:48 inside ct_results()
2001-10-25 11:24:49 processing result tokens. marker is fd
2001-10-25 11:24:49 inside ct_cancel()
Sending packet @ 2001-10-25 11:24:49
0000 06 01 00 08 00 00 00 00 |........|


2001-10-25 11:24:50 inside ct_con_props() action = 25 property = 26
2001-10-25 11:24:50 inside ct_close()
2001-10-25 11:24:50 inside ct_con_drop()

--
James Cameron




Archive powered by MHonArc 2.6.24.

Top of Page