FreeTDS Development Group

["Peter Zeltins" <peterz AT umpire.com>]

> Can you set TDSDUMP (such as 'export TDSDUMP=/tmp/freetds.log') and post
> the output?
>
> BTW, the unknown property messages have been removed in the CVS versions.
>

Hmm, I'm still getting 'unknown property 10' messages with CVS ver.

OK, I finaly found out the problem was elsewhere. It seems like select
statement in 0.50 returns strings with 00 byte appended in the end. Perl
handles these strings nicely, and when I construct next SQL statement using
values returned from previous SQL, zero bytes are interpreted as
end-of-string. Temp. fix is to use chomp to remove trailing zero bytes, but
it requires to rewrite scripts. TDSDUMP for the select statement follows.

The following dump was created using latest CVS ver compiled with TDS42
option.

2000-01-27 11:41:22 Connecting addr xxx.xxx.xxx.xx
Sending packet @ 2000-01-27 11:41:22
<login packet>


Sending packet @ 2000-01-27 11:41:22
0000  02 01 00 4c 00 00 00 00 00 00 00 00 00 00 00 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               |............|


2000-01-27 11:41:22 inside tds_process_login_tokens()
2000-01-27 11:41:22 inside tds_process_default_tokens() marker is e3
2000-01-27 11:41:22 inside tds_process_default_tokens() marker is ab
2000-01-27 11:41:22 inside tds_process_default_tokens() marker is e3
2000-01-27 11:41:22 inside tds_process_default_tokens() marker is e3
2000-01-27 11:41:22 inside tds_process_default_tokens() marker is fd
2000-01-27 11:41:22 leaving tds_process_login_tokens() returning 1
2000-01-27 11:41:22 leaving ct_connect() returning 1
2000-01-27 11:41:22 inside ct_options()
2000-01-27 11:41:22 inside ct_cmd_alloc()
2000-01-27 11:41:22 inside ct_command()
2000-01-27 11:41:22 inside ct_send()
Sending packet @ 2000-01-27 11:41:22
0000  01 01 00 43 00 00 00 00 73 65 6c 65 63 74 20 64   |...C....select d|
0010  69 73 74 69 6e 63 74 20 73 79 6d 62 6f 6c 20 66   |istinct symbol f|
0020  72 6f 6d 20 74 69 63 6b 73 79 6d 73 20 77 68 65   |rom ticksyms whe|
0030  72 65 20 73 79 6d 62 6f 6c 20 3c 3e 20 27 43 41   |re symbol <> 'CA|
0040  53 48 27                                          |SH'|


2000-01-27 11:41:22 inside ct_results()
2000-01-27 11:41:22 processing result tokens.  marker is  a0
2000-01-27 11:41:22 processing result tokens.  marker is  a1
2000-01-27 11:41:22 inside tds_process_default_tokens() marker is a1
2000-01-27 11:41:22 processing result tokens.  marker is  d1
2000-01-27 11:41:22 inside ct_res_info()
2000-01-27 11:41:22 inside ct_describe()
2000-01-27 11:41:22 inside _ct_get_client_type()
2000-01-27 11:41:22 inside ct_describe() datafmt->datatype = 1 server type
39
2000-01-27 11:41:22 inside ct_bind()
2000-01-27 11:41:22 inside ct_bind() item = 1 datafmt->datatype = 1
2000-01-27 11:41:22 inside ct_fetch()
2000-01-27 11:41:22 processing row tokens.  marker is  d1
2000-01-27 11:41:22 setting column 0 to NULL
2000-01-27 11:41:22 inside _ct_bind_data()
2000-01-27 11:41:22 inside _ct_bind_data() setting column size for 0 = 20
2000-01-27 11:41:22 inside _ct_get_server_type()
2000-01-27 11:41:22 inside _ct_bind_data() converting column 0 from type 39
to type 47
2000-01-27 11:41:22 inside _ct_get_server_type()
2000-01-27 11:41:22 converting string dlen = 21 strlen = 47 string = AACB
2000-01-27 11:41:22 inside ct_fetch()
2000-01-27 11:41:22 processing row tokens.  marker is  d1
...
etc etc etc. ct_fetch() for each row.

Attachment: smime.p7s
Description: S/MIME cryptographic signature