FreeTDS Development Group

[Peter Deacon <peterd AT iea-software.com>]

This works fine with tds 7.  With tds5 on ASE 12.5 it's looking for
marker 18?  Any idea on what that is offhand? :)

If the operation doesen't fail no marker 18 problems.  Its all down hill
from there.  For example sending a cancel ususally leads to FreeTDS
parsing the wrong packet data and going haywire (Like initializing
some 63,000 columns)

Methinks disconnecting for unknowns like the comment sais is a good idea :)

Also noticed some of the metadata procedures for older versions of Sybase
(11.9.2) don't follow the odbc documented columns :(  I'll work on fixing
these.

00:04:42 tds_process_end: more_results = 0
00:04:42                  was_cancelled = 1
00:04:42                  error = 0
00:04:42                  done_count_valid = 0
00:04:42 tds_process_end() state set to TDS_IDLE
Sending packet @ 00:04:42
0000 0f 01 00 b7 00 00 00 00-21 aa 00 00 00 00 49 4e |........ !.....IN|
0010 53 45 52 54 20 49 4e 54-4f 20 52 61 64 4c 6f 67 |SERT INT O RadLog|
0020 73 28 52 61 64 4c 6f 67-4d 73 67 49 44 2c 4c 6f |s(RadLog MsgID,Lo|
0030 67 44 61 74 65 2c 55 73-65 72 6e 61 6d 65 2c 44 |gDate,Us ername,D|
0040 61 74 61 2c 4e 41 53 49-64 65 6e 74 69 66 69 65 |ata,NASI dentifie|
0050 72 2c 4e 41 53 50 6f 72-74 2c 43 61 6c 6c 65 72 |r,NASPor t,Caller|
0060 49 44 29 56 41 4c 55 45-53 28 31 30 2c 27 32 30 |ID)VALUE S(10,'20|
0070 30 33 31 31 31 35 20 30-3a 34 3a 34 32 27 2c 27 |031115 0 :4:42','|
0080 70 65 74 65 72 64 64 64-27 2c 27 74 65 73 74 31 |peterddd ','test1|
0090 32 33 27 2c 27 31 32 37-2e 30 2e 30 2e 31 27 2c |23','127 .0.0.1',|
00a0 27 74 65 73 74 20 74 65-73 74 27 2c 27 35 35 35 |'test te st','555|
00b0 31 32 31 32 27 29 20   -                        |1212') |


Received header @ 00:04:42
0000 04 01 01 76 00 00 00 00-                        |...v....|


Received packet @ 00:04:42
0000 e5 74 00 29 0a 00 00 01-0e 05 32 33 30 30 30 01 |.t.).... ..23000.|
0010 00 00 5f 00 41 74 74 65-6d 70 74 20 74 6f 20 69 |.._.Atte mpt to i|
0020 6e 73 65 72 74 20 64 75-70 6c 69 63 61 74 65 20 |nsert du plicate |
0030 6b 65 79 20 72 6f 77 20-69 6e 20 6f 62 6a 65 63 |key row  in objec|
0040 74 20 27 52 61 64 4c 6f-67 73 27 20 77 69 74 68 |t 'RadLo gs' with|
0050 20 75 6e 69 71 75 65 20-69 6e 64 65 78 20 27 52 | unique  index 'R|
0060 61 64 4c 6f 67 73 5f 36-33 33 30 35 30 32 36 30 |adLogs_6 33050260|
0070 31 27 0a 00 00 01 00 ec-6a 00 07 00 05 69 6e 64 |1'...... j....ind|
0080 65 78 00 02 00 00 00 27-12 00 08 64 61 74 61 62 |ex.....' ...datab|
0090 61 73 65 00 02 00 00 00-27 08 00 05 6f 77 6e 65 |ase..... '...owne|
00a0 72 00 02 00 00 00 27 03-00 05 74 61 62 6c 65 00 |r.....'. ..table.|
00b0 02 00 00 00 27 07 00 06-63 6f 6c 75 6d 6e 00 02 |....'... column..|
00c0 00 00 00 27 0b 00 06 63-6f 6c 75 6d 6e 00 02 00 |...'...c olumn...|
00d0 00 00 27 07 00 06 63 6f-6c 75 6d 6e 00 02 00 00 |..'...co lumn....|
00e0 00 27 08 00 d7 12 52 61-64 4c 6f 67 73 5f 36 33 |.'....Ra dLogs_63|
00f0 33 30 35 30 32 36 30 31-08 45 6d 65 72 61 6c 64 |30502601 .Emerald|
0100 34 03 64 62 6f 07 52 61-64 4c 6f 67 73 0b 52 61 |4.dbo.Ra dLogs.Ra|
0110 64 4c 6f 67 4d 73 67 49-44 07 4c 6f 67 44 61 74 |dLogMsgI D.LogDat|
0120 65 08 55 73 65 72 6e 61-6d 65 fd 05 00 01 00 00 |e.Userna me......|
0130 00 00 00 e5 2f 00 25 0e-00 00 00 0a 05 5a 5a 5a |..../.%. .....ZZZ|
0140 5a 5a 00 03 00 1a 00 43-6f 6d 6d 61 6e 64 20 68 |ZZ.....C ommand h|
0150 61 73 20 62 65 65 6e 20-61 62 6f 72 74 65 64 2e |as been  aborted.|
0160 0a 00 00 01 00 fd 12 00-03 00 00 00 00 00       |........ ......|


00:04:42 processing result tokens.  marker is  e5(EED)
00:04:42 tds_process_default_tokens() marker is e5(EED)
tds_get_string: reading 95 from wire to give 95 to client.
00:04:42 processing result tokens.  marker is  ec(TDS5_PARAMFMT)
tds_get_string: reading 5 from wire to give 5 to client.
00:04:42 processing result. type = 39(varchar), varint_size 1
00:04:42 processing result. column_size 18
tds_get_string: reading 8 from wire to give 8 to client.
00:04:42 processing result. type = 39(varchar), varint_size 1
00:04:42 processing result. column_size 8
tds_get_string: reading 5 from wire to give 5 to client.
00:04:42 processing result. type = 39(varchar), varint_size 1
00:04:42 processing result. column_size 3
tds_get_string: reading 5 from wire to give 5 to client.
00:04:42 processing result. type = 39(varchar), varint_size 1
00:04:42 processing result. column_size 7
tds_get_string: reading 6 from wire to give 6 to client.
00:04:42 processing result. type = 39(varchar), varint_size 1
00:04:42 processing result. column_size 11
tds_get_string: reading 6 from wire to give 6 to client.
00:04:42 processing result. type = 39(varchar), varint_size 1
00:04:42 processing result. column_size 7
tds_get_string: reading 6 from wire to give 6 to client.
00:04:42 processing result. type = 39(varchar), varint_size 1
00:04:42 processing result. column_size 8
00:04:42 processing result tokens.  marker is  d7(TDS5_PARAMS)
00:04:42 processing result tokens.  marker is  12()
00:04:42 tds_process_default_tokens() marker is 12()
Unknown marker: 18(12)!!
SQLExecute: bad results

Have Fun!
Peter