Skip to Content.
Sympa Menu

freetds - [freetds] MSSQL TEXTSIZE for large text files is not returning any values

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Guillaume Nourry-Marquis <guillaume.nourry.marquis AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] MSSQL TEXTSIZE for large text files is not returning any values
  • Date: Wed, 28 Dec 2005 11:06:56 -0500

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?



  • [freetds] MSSQL TEXTSIZE for large text files is not returning any values, Guillaume Nourry-Marquis, 12/28/2005

Archive powered by MHonArc 2.6.24.

Top of Page