FreeTDS Development Group

[James Cameron <cameron AT stl.dec.com>]

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/