FreeTDS Development Group

[James Ponder <james AT squish.net>]

(I'm dropping the 'int' part of the subject, since I can't reproduce it
in a test program)

On Wed, Oct 18, 2000 at 08:05:49PM -0400, Brian Bruns wrote:
> Also do an 'export TDSDUMP=mydump.log' or some such and send the contents of
> that log file (please edit out passwords and such...)

It seems to only store the last query or so, so I've included the relevant
one by stopping the test program after the select.  I note that my program
name (test.pl) is sent to the remote server?!  If this is true then from
a security point of view this seems unexpected, and should be documented
somewhere.

> Also, provide info on what service pack the SQL Server is running.

The SQL Server itself is running 7.00.694 and it's on an NT Server 4 SP6.

> Michael, have any of the recent snapshots of DBD::Sybase changed the bind
> types for char/varchar datatypes? James, you may want to grab the 0.23
> release instead and give that a whirl.

I am using DBD::Sybase 0.23 and freetds.snapshot dated Oct 18 11:13.


Best wishes, James
-- 
James Ponder; www.squish.net
2000-10-19 10:49:10 Connecting addr 195.xxxxxxxxxx port 1433
Sending packet @ 2000-10-19 10:49:10
0000  10 01 00 ce 00 00 01 00 c6 00 00 00 00 00 00 70   |...............p|
0010  00 00 00 00 00 00 00 06 83 f2 f8 ff 00 00 00 00   |................|
0020  e0 03 00 00 88 ff ff ff 36 04 00 00 56 00 00 00   |........6...V...|
0030  56 00 02 00 5a 00 00 00 5a 00 07 00 68 00 0d 00   |V...Z...Z...h...|
0040  00 00 00 00 82 00 0a 00 96 00 00 00 96 00 00 00   |................|
0050  00 40 33 9a 6b 50 96 00 30 00 c6 00 00 00 73 00   |.@3.kP..0.....s.|
0060  61 00 74 00 65 00 73 00 74 00 2e 00 70 00 6c 00   |a.t.e.s.t...p.l.|
0070  31 00 39 00 35 00 2e 00 37 00 34 00 2e 00 31 00   |1.9.5...xxxxxxxx|
0080  30 00 32 00 2e 00 39 00 31 00 43 00 54 00 2d 00   |xxxxxxxxx.C.T.-.|
0090  4c 00 69 00 62 00 72 00 61 00 72 00 79 00 4e 54   |L.i.b.r.a.r.y.NT|
00a0  4c 4d 53 53 50 00 01 00 00 00 06 82 00 00 00 00   |LMSSP...........|
00b0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
00c0  00 00 30 00 00 00 00 00 00 00 30 00 00 00         |..0.......0...|


2000-10-19 10:49:10 inside tds_process_login_tokens()
2000-10-19 10:49:11 inside tds_process_default_tokens() marker is e3
2000-10-19 10:49:11 inside tds_process_default_tokens() marker is ab
2000-10-19 10:49:11 Msg 5701, Level 0, State 2, Server PSERVER, Line 0
Changed database context to 'master'.
2000-10-19 10:49:11 inside tds_process_default_tokens() marker is e3
2000-10-19 10:49:11 inside tds_process_default_tokens() marker is ab
2000-10-19 10:49:11 Msg 5703, Level 0, State 1, Server PSERVER, Line 0
Changed language setting to us_english.
2000-10-19 10:49:11 inside tds_process_default_tokens() marker is e3
2000-10-19 10:49:11 inside tds_process_default_tokens() marker is e3
2000-10-19 10:49:11 inside tds_process_default_tokens() marker is e3

2000-10-19 10:49:11 inside tds_process_default_tokens() marker is e3
2000-10-19 10:49:11 inside tds_process_default_tokens() marker is fd
2000-10-19 10:49:11 leaving tds_process_login_tokens() returning 1
2000-10-19 10:49:11 leaving ct_connect() returning 1
2000-10-19 10:49:11 inside ct_cmd_alloc()
2000-10-19 10:49:11 inside ct_command()
2000-10-19 10:49:11 inside ct_send()
Sending packet @ 2000-10-19 10:49:11
0000  01 01 00 18 00 00 01 00 75 00 73 00 65 00 20 00   |........u.s.e. .|
0010  6a 00 61 00 6e 00 65 00                           |j.a.n.e.|


2000-10-19 10:49:11 inside ct_results()
2000-10-19 10:49:11 processing result tokens.  marker is  e3
2000-10-19 10:49:11 inside tds_process_default_tokens() marker is e3
2000-10-19 10:49:11 processing result tokens.  marker is  ab
2000-10-19 10:49:11 processing result tokens.  marker is  fd
2000-10-19 10:49:11 inside ct_cmd_drop()
2000-10-19 10:49:11 inside ct_options()
2000-10-19 10:49:11 inside ct_cmd_alloc()
2000-10-19 10:49:11 inside ct_command()
2000-10-19 10:49:11 inside ct_send()
Sending packet @ 2000-10-19 10:49:11
0000  01 01 00 4c 00 00 01 00 43 00 52 00 45 00 41 00   |...L....C.R.E.A.|
0010  54 00 45 00 20 00 54 00 41 00 42 00 4c 00 45 00   |T.E. .T.A.B.L.E.|
0020  20 00 77 00 69 00 62 00 62 00 6c 00 65 00 20 00   | .w.i.b.b.l.e. .|
0030  28 00 6d 00 6f 00 6f 00 20 00 43 00 48 00 41 00   |(.m.o.o. .C.H.A.|
0040  52 00 28 00 32 00 30 00 29 00 29 00               |R.(.2.0.).).|


2000-10-19 10:49:11 inside ct_results()
2000-10-19 10:49:11 processing result tokens.  marker is  fd
2000-10-19 10:49:11 inside ct_cmd_drop()
2000-10-19 10:49:11 inside ct_cmd_alloc()
2000-10-19 10:49:11 inside ct_command()
2000-10-19 10:49:11 inside ct_send()
Sending packet @ 2000-10-19 10:49:11
0000  01 01 00 5a 00 00 01 00 49 00 4e 00 53 00 45 00   |...Z....I.N.S.E.|
0010  52 00 54 00 20 00 49 00 4e 00 54 00 4f 00 20 00   |R.T. .I.N.T.O. .|
0020  77 00 69 00 62 00 62 00 6c 00 65 00 20 00 28 00   |w.i.b.b.l.e. .(.|
0030  6d 00 6f 00 6f 00 29 00 20 00 56 00 41 00 4c 00   |m.o.o.). .V.A.L.|
0040  55 00 45 00 53 00 20 00 28 00 27 00 68 00 65 00   |U.E.S. .(.'.h.e.|
0050  6c 00 6c 00 6f 00 27 00 29 00                     |l.l.o.'.).|


2000-10-19 10:49:11 inside ct_results()
2000-10-19 10:49:11 processing result tokens.  marker is  fd
2000-10-19 10:49:11 inside ct_cmd_drop()
2000-10-19 10:49:11 inside ct_cmd_alloc()
2000-10-19 10:49:11 inside ct_command()
2000-10-19 10:49:11 inside ct_send()
Sending packet @ 2000-10-19 10:49:11
0000  01 01 00 34 00 00 01 00 53 00 45 00 4c 00 45 00   |...4....S.E.L.E.|
0010  43 00 54 00 20 00 6d 00 6f 00 6f 00 20 00 46 00   |C.T. .m.o.o. .F.|
0020  52 00 4f 00 4d 00 20 00 77 00 69 00 62 00 62 00   |R.O.M. .w.i.b.b.|
0030  6c 00 65 00                                       |l.e.|


2000-10-19 10:49:11 inside ct_results()
2000-10-19 10:49:11 processing result tokens.  marker is  81
2000-10-19 10:49:11 processing result tokens.  marker is  d1
2000-10-19 10:49:11 inside ct_res_info()
2000-10-19 10:49:11 inside ct_describe()
2000-10-19 10:49:11 inside _ct_get_client_type()
2000-10-19 10:49:11 inside ct_describe() datafmt->datatype = 1 server type 47
2000-10-19 10:49:11 inside ct_bind()
2000-10-19 10:49:11 inside ct_bind() item = 1 datafmt->datatype = 1
2000-10-19 10:49:11 inside ct_fetch()
2000-10-19 10:49:11 processing row tokens.  marker is  d1
2000-10-19 10:49:11 setting column 0 to NULL
2000-10-19 10:49:11 inside _ct_bind_data()
2000-10-19 10:49:11 inside _ct_bind_data() setting column size for 0 = 20
2000-10-19 10:49:11 inside _ct_get_server_type()
2000-10-19 10:49:11 inside _ct_bind_data() converting column 0 from type 47 
to type 47
2000-10-19 10:49:11 inside _ct_get_server_type()
2000-10-19 10:49:11 converting string dlen = 21 dtype = 47 string = hello     
          
2000-10-19 10:49:11 inside _ct_bind_data() conversion done len = 6 bindfmt = 
66
2000-10-19 10:49:11 inside _ct_bind_data() length binding len = 62000-10-19 
10:49:11 inside ct_cancel()
Sending packet @ 2000-10-19 10:49:11
0000  06 01 00 08 00 00 01 00                           |........|


2000-10-19 10:49:11 inside ct_cmd_drop()
2000-10-19 10:49:11 inside ct_close()
2000-10-19 10:49:11 inside ct_con_drop()