FreeTDS Development Group

[Guillaume Nourry-Marquis <guillaume.nourry.marquis AT gmail.com>]

Hello,

I'm connecting to a MSSQL database which has a table with 2 text columns.

When connecting to the table, I'm unable to display those 2 columns. I tried
to convert to a varchar... but 8000 bytes is not long enough for the data I
tried to access.

I changed the TEXTSIZE to a bigger value, but when I go over 300, nothing is
ouputted. I checked in the logs, and everything is received correctly...
here it is, if you can help me, I would really appreciate.

14:06:10.114265 Starting log file for FreeTDS 0.63
        on 2005-12-23 14:06:10 with debug level 99.
#####
Removed information...
#####
14:06:23.878914 Sending packet
0000 03 01 00 27 00 00 01 00-0a 00 73 00 70 00 5f 00 |...'.... ..s.p._.|
0010 65 00 78 00 65 00 63 00-75 00 74 00 65 00 00 00 |e.x.e.c. u.t.e...|
0020 00 00 38 01 00 00 00   -                        |..8....|

14:06:23.893895 Received header
0000 04 01 19 67 00 33 01 00-                        |...g.3..|

14:06:23.898237 Received packet
0000 81 01 00 00 00 09 00 23-a0 86 01 00 09 04 d0 00 |.......# ........|
0010 34 0c 00 43 00 6f 00 6d-00 62 00 69 00 6e 00 65 |4..C.o.m .b.i.n.e|
0020 00 64 00 42 00 6f 00 64-00 79 00 04 42 00 4f 00 |.d.B.o.d .y..B.O.|
0030 44 00 59 00 d1 10 fd ff-46 6a 01 00 00 00 e4 e5 |D.Y..... Fj......|
0040 00 00 01 00 04 00 64 75-6d 6d 79 54 53 00 44 0b |......du mmyTS.D.|
0050 00 00 30 30 31 45 20 20-20 20 20 20 20 20 20 20 |..001E           |
0060 4d 54 52 4c 50 51 32 33-48 32 30 20 20 43 47 45 |MTRLPQ23 H20  CGE|
0070 30 34 35 2c 43 4f 4c 4f-43 20 4c 49 4e 4b 23 52 |045,COLO C LINK#R|
0080 52 3a 4d 54 52 4c 50 51-32 33 46 30 33 55 3a 35 |R:MTRLPQ 23F03U:5|
0090 31 30 20 20 53 3a 20 20-20 23 0d 0a 30 30 32 45 |10  S:    #..002E|
00a0 20 20 20 20 20 20 20 20-20 20 4d 54 52 4c 50 51 |           MTRLPQ|
00b0 32 33 48 32 30 20 20 4c-49 4e 45 20 46 52 3a 44 |23H20  L INE FR:D|
00c0 20 20 20 4c 49 4e 45 20-5a 4e 3a 31 35 38 20 44 |   LINE  ZN:158 D|
00d0 52 50 20 46 52 3a 20 20-20 20 44 52 50 20 5a 4e |RP FR:     DRP ZN|
00e0 3a 20 20 20 0d 0a 30 30-33 45 20 20 20 20 20 20 |:   ..00 3E      |
00f0 20 20 20 20 4d 54 52 4c-50 51 32 33 48 32 30 20 |    MTRL PQ23H20 |
0100 20 41 43 43 3a 4d 44 46-20 44 31 35 38 20 20 20 | ACC:MDF  D158   |
0110 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0120 20 20 20 20 20 20 20 20-20 20 20 20 20 20 0d 0a |               ..|
0130 30 30 34 4e 20 20 30 2e-35 20 20 30 2e 30 20 20 |004N  0. 5  0.0  |
0140 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0150 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0160 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0170 20 20 20 20 20 20 20 20-0d 0a 30 30 35 43 20 20 |         ..005C  |
0180 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0190 20 20 20 20 20 43 41 20-33 30 20 20 20 2c 50 52 |     CA  30   ,PR|
01a0 20 31 37 30 33 20 3a 42-52 2f 43 4c 52 3a 34 30 | 1703 :B R/CLR:40|
01b0 33 20 4a 4a 45 20 20 20-20 20 20 20 20 20 20 20 |3 JJE            |
01c0 20 20 0d 0a 30 30 36 43-20 20 20 20 20 20 20 20 |  ..006C         |
01d0 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 5a |                Z|
01e0 52 3a 30 30 20 20 20 20-20 5a 4e 3a 30 32 20 20 |R:00      ZN:02  |
01f0 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0200 20 20 20 20 20 20 20 20-20 20 20 20 0d 0a 30 30 |             ..00|
0210 37 58 20 20 20 20 20 20-20 20 20 20 54 59 50 45 |7X           TYPE|
0220 3a 43 20 20 20 20 20 20-20 41 44 52 45 53 53 45 |:C        ADRESSE|
0230 3a 20 32 36 32 36 20 53-41 42 4f 55 52 49 4e 20 |: 2626 S ABOURIN |
0240 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0250 20 20 20 20 20 20 0d 0a-30 30 38 44 20 20 20 20 |      .. 008D    |
0260 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0270 20 20 20 20 20 20 43 41-20 34 31 35 2d 32 20 20 |      CA  415-2  |
0280 20 2c 50 52 20 34 32 38-20 20 3a 42 52 2f 43 4c | ,PR 428   :BR/CL|
0290 52 3a 32 38 20 46 53 43-20 20 20 20 20 20 20 20 |R:28 FSC         |
02a0 0d 0a 30 30 39 58 20 20-20 20 20 20 20 20 20 20 |..009X           |
02b0 54 59 50 45 3a 41 52 52-20 20 20 20 20 41 44 52 |TYPE:ARR      ADR|
02c0 45 53 53 45 3a 20 32 38-36 37 20 48 41 4c 50 45 |ESSE: 28 67 HALPE|
02d0 52 4e 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |RN               |
02e0 20 20 20 20 20 20 20 20-20 20 0d 0a 30 31 30 56 |           ..010V|
02f0 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0300 20 20 20 20 20 20 20 56-49 53 49 54 45 20 52 45 |       V ISITE RE|
0310 51 55 49 53 45 20 20 52-54 45 3a 20 20 4d 44 39 |QUISE  R TE:  MD9|
0320 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
0330 20 20 20 20 0d 0a 30 31-31 4e 20 20 20 20 20 20 |    ..01 1N      |
0340 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
#####...
18f0 20 20 20 20 20 20 20 20-20 20 20 20 20 20 0d 0a |               ..|
1900 30 34 37 4e 20 20 20 20-20 20 20 20 20 20 20 20 |047N             |
1910 20 20 20 20 20 20 20 20-20 20 20 43 52 4f 20 4e |            CRO N|
1920 20 34 33 32 37 20 34 38-34 35 20 33 37 20 20 20 | 4327 48 45 37   |
1930 20 20 20 20 20 20 20 20-20 20 20 20 20 20 20 20 |                 |
1940 20 20 20 20 20 20 20 20-ff 11 00 c1 00 02 00 00 |         ........|
1950 00 79 00 00 00 00 fe 00-00 e0 00 02 00 00 00    |.y...... .......|

14:06:23.900715 processing result tokens.  marker is  81(TDS7_RESULT)
14:06:23.900734 tds_free_all_results()
14:06:23.900767 processing TDS7 result. set current_results to tds->res_info
14:06:23.900785 adjust_character_column_size:
        Server charset: CP1252
        Server column_size: 100000
        Client charset: ISO-8859-1
        Client column_size: 100000
14:06:23.900799 tds_get_string: reading 24 from wire to give 12 to client.
14:06:23.900821 tds_get_string: reading 8 from wire to give 4 to client.
14:06:23.900834 tds7_get_data_info:1558:
        colname = BODY (4 bytes)
        type = 35 (text)
        server's type = 35 (text)
        column_varint_size = 4
        column_size = 100000 (100000 on server)
14:06:23.900852 processing result tokens.  marker is  d1(ROW)
14:06:23.900907 odbc:SQLColAttribute: fDescType is 18
14:06:23.900949 processing row tokens.  marker is  d1(ROW)
14:06:23.900963 processing row.  column is 0 varint size = 4
14:06:23.900976 processing row.  column size is 2884
14:06:23.900988 clearing column 0 NULL bit
14:06:23.901066 convert_tds2sql: src is 35 dest = 1
14:06:23.901095 convert_tds2sql: outputting character data destlen = 301
14:06:23.901127 processing row tokens.  marker is  d1(ROW)
14:06:23.901140 processing row.  column is 0 varint size = 4
14:06:23.901153 processing row.  column size is 3476
14:06:23.901165 clearing column 0 NULL bit
14:06:23.901218 convert_tds2sql: src is 35 dest = 1
14:06:23.901231 convert_tds2sql: outputting character data destlen = 301
14:06:23.901256 processing row tokens.  marker is  ff(DONEINPROC)
14:06:23.901269 tds_process_end: more_results = 1
                was_cancelled = 0
                error = 0
                done_count_valid = 1
14:06:23.901282                 rows_affected = 2
14:06:23.901296 SQLFetch: NO_DATA_FOUND
14:06:23.901317 processing result tokens.  marker is  79(RETURNSTATUS)
14:06:23.901330 processing result tokens.  marker is  fe(DONEPROC)
14:06:23.901343 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
14:06:23.901356 tds_process_end() state set to TDS_IDLE
14:06:23.901377 SQLFreeHandle(3, 0x0x88b6f28)
14:06:23.901392 tds_submit_unprepare() eejz936000
14:06:23.901404 tds_free_all_results()
14:06:23.901420 Sending packet
0000 03 01 00 15 00 00 01 00-ff ff 0f 00 00 00 00 00 |........ ........|
0010 38 01 00 00 00         -                        |8....|

14:06:23.914155 Received header
0000 04 01 00 16 00 33 01 00-                        |.....3..|

14:06:23.914280 Received packet
0000 79 00 00 00 00 fe 00 00-e0 00 02 00 00 00       |y....... ......|

14:06:23.914298 processing result tokens.  marker is  79(RETURNSTATUS)
14:06:23.914415 processing result tokens.  marker is  fe(DONEPROC)
14:06:23.914430 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
14:06:23.914444 tds_process_end() state set to TDS_IDLE
14:06:27.395771 tds_free_all_results()








RESULTS is :
[root@localhost examples]# isql -cbdv -x0x09 879_2005 AWFM ********
+----------------------------- ----------+
| Connected!                             |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> SELECT BODY FROM CombinedBody WHERE CKT LIKE 'LCLXXU099969%'
BODY

SQL>


My freetds.conf file look like this :

[global]
        # TDS protocol version
        tds version = 4.2

        # Whether to write a TDSDUMP file for diagnostic purposes
        # (setting this to /tmp is insecure on a multi-user system)
        dump file = /tmp/freetds.log
        debug level = 10


        text size = 100000

#Database with all the 879 information being sent from MCCDS to NSC_HUB to
FWFM (SB)
[Search879]
        host = AL2CAD.XX.XXXX.XX <http://al2cad.on.bell.ca/>
        port = 1433
        tds version = 8.0
#       client charset = UTF-8

#########
Any ideas why the logs show that it receive the information correctly, but
it is not returned by isql? Freetds bug?