Skip to Content.
Sympa Menu

freetds - Re: 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: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: set textsize 1048576 fails
  • Date: Tue, 30 Oct 2001 11:19:15 +1100


Brian Bruns wrote:
> can you generate a TDSDUMP trace log?

This is the output generated by the PHP code ...

$link = sybase_connect('CSMain','username','password');
$result = sybase_query('set textsize 256', $link);
$result = sybase_query('select @@version', $link);

If I comment out the 'set textsize' it works.


2001-10-30 10:14:26 Connecting addr 16.167.208.86 port 1433
Sending packet @ 2001-10-30 10:14:27
0000 02 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
[...]
00e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
00f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
01a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
01b0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
01c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
01d0 00 09 04 02 00 00 43 54 2d 4c 69 62 72 61 72 79
|......CT-Library|
01e0 0a 00 00 00 00 00 0d 11 75 73 5f 65 6e 67 6c 69
|........us_engli|
01f0 73 68 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|sh..............|


Sending packet @ 2001-10-30 10:14:27
0000 02 01 00 4c 00 00 00 00 00 00 00 00 00 00 0a 00
|...L............|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 69 73 6f
|.............iso|
0020 5f 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|_1..............|
0030 00 00 00 00 00 00 00 00 00 00 00 05 01 35 31 32
|.............512|
0040 00 00 00 03 00 00 00 00 00 00 00 00 |............|


2001-10-30 10:14:27 inside tds_process_login_tokens()
Received packet @ 2001-10-30 10:14:29
0000 e3 0f 00 01 06 43 53 4d 61 69 6e 06 6d 61 73 74
|.....CSMain.mast|
0010 65 72 ab 37 00 45 16 00 00 02 00 25 00 43 68 61
|er.7.E.....%.Cha|
0020 6e 67 65 64 20 64 61 74 61 62 61 73 65 20 63 6f |nged database
co|
0030 6e 74 65 78 74 20 74 6f 20 27 43 53 4d 61 69 6e |ntext to
'CSMain|
0040 27 2e 06 45 56 54 53 51 4c 00 00 00 e3 09 00 03
|'..EVTSQL.......|
0050 05 69 73 6f 5f 31 01 00 ad 20 00 01 04 02 00 00 |.iso_1...
......|
0060 16 4d 69 63 72 6f 73 6f 66 74 20 53 51 4c 20 53 |.Microsoft SQL
S|
0070 65 72 76 65 72 00 00 5f 07 00 ff e3 0a 00 04 03
|erver.._........|
0080 35 31 32 04 34 30 39 36 fd 00 00 00 00 00 00 00
|512.4096........|
0090 00 |.|


2001-10-30 10:14:29 inside tds_process_default_tokens() marker is e3
2001-10-30 10:14:29 inside tds_process_default_tokens() marker is ab
2001-10-30 10:14:29 Msg 5701, Level 0, State 2, Server EVTSQL, Line 0
Changed database context to 'CSMain'.
2001-10-30 10:14:29 inside tds_process_default_tokens() marker is e3
2001-10-30 10:14:29 inside tds_process_default_tokens() marker is e3
2001-10-30 10:14:29 inside tds_process_default_tokens() marker is fd
2001-10-30 10:14:29 leaving tds_process_login_tokens() returning 1
2001-10-30 10:14:29 leaving ct_connect() returning 1
2001-10-30 10:14:29 inside ct_cmd_alloc()
2001-10-30 10:14:29 inside ct_command()
2001-10-30 10:14:29 inside ct_send()
Sending packet @ 2001-10-30 10:14:29
0000 01 01 00 18 00 00 00 00 73 65 74 20 74 65 78 74 |........set
text|
0010 73 69 7a 65 20 32 35 36 |size 256|


2001-10-30 10:14:29 inside ct_results()
Received packet @ 2001-10-30 10:14:30
0000 fd 00 00 be 00 00 00 00 00 |.........|


2001-10-30 10:14:30 processing result tokens. marker is fd
2001-10-30 10:14:30 inside ct_cancel()
Sending packet @ 2001-10-30 10:14:30
0000 06 01 00 08 00 00 00 00 |........|


Received packet @ 2001-10-30 10:14:31
0000 fd 20 00 00 00 00 00 00 00 |. .......|


2001-10-30 10:14:31 inside ct_con_props() action = 25 property = 26
2001-10-30 10:14:31 inside ct_close()
2001-10-30 10:14:31 inside ct_con_drop()

Ends there.

freetds.conf has ...
[CSMain]
host = some.domain.name
port = 1433
tds version = 4.2

SELECT @@VERSION normally returns

Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
Mar 2 2000 06:49:37
Copyright (c) 1988-1998 Microsoft Corporation
Enterprise Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

--
James Cameron (cameron AT stl.dec.com)

http://www.opensource.org/ http://vanilla.us.netrek.org/ http://lwn.net/




Archive powered by MHonArc 2.6.24.

Top of Page