Re: Fwd: [unixODBC-support] PHP PDO unixODBC FreeTDS SQL Server text column size
Jochen Daum <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAPeqxCcrfGTTbW8ZM+bc0JRxydTKpXDfcE6A11_OFBE5fan98g@mail.gmail.com> |
Thanks: >> > To determine if the FreeTDS ODBC driver is able to process your >> > query results, I recommend testing it with bsqlodbc. If that >> > works, you can have some confidence that the driver works as >> > expected. That is, as the authors intended. >> >> When I run this query through bsqlodbc >> >> select [Attachment].[attaContent] from [Attachment] where >> ([Attachment].[attaId] = 10239) >> >> I get bsqlodbc: error -2: SQLAllocHandle: invalid handle: failed > > Well, we can file that under "doesn't work". Did you get no other > message before that one? Usually a TDS_DONE_ERROR from the server is > preceded by a message, and something like "invalid handle" would occur > later, after the program continues blithely on. That's "usually" as > in, I've never seen an exception. > >> column_size = 2147483647 (2147483647 on server) > > Does it help if you "set textsize 10000000" (10 million) first? The > constraint in your configuration file > I can't see any other error message, but admittedly this is the first time I log at freetds logs. I've modified my query to: set textsize 10000000 select attaRefTable from [Attachment] where ([Attachment].[attaId] = 10239) - I tried "go" inbetween the 2 statements and it threw an error - attaRefTable is a varchar(30) >> text size = 10971520 > > might not matter; you said its name is "/etc/freetds/freetds.ini" and > that would normally be /etc/freetds/freetds.conf. That was a mixup by myself. its /etc/freetds/freetds.conf I also found that I used tds version = 8.0, which doesn't exist, so I changed this to 7.2. In summary: bsqlodbc -v -Uwebsite -Ppassword -SEIS -DExportInformationSystem -o output -e error -i Attachment.sql returns output: empty error: bsqlodbc:273: Verbose operation enabled bsqlodbc:366: Query: set textsize 10000000 select attaRefTable from [Attachment] where ([Attachment].[attaId] = 10239) Metadata col name type value type name size varies ------ ------------------------------ ---------- ------------------ ------ ------ bsqlodbc: error -2: SQLAllocHandle: invalid handle: failed freetds.log attached. Thanks for any further pointers. > > --jkl > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds -- P.S.: Latest newsletter: Website application reporting - an overview - http://eepurl.com/pKrAD Kind Regards, Jochen Daum "There is no shortcut to anywhere worth going" - Beverly Sills Automatem Ltd Phone: +64 9 630 3425 Mobile: +64 21 567 853 Email: [email protected] Website: www.automatem.co.nz Skype: jochendaum http://nz.linkedin.com/in/automatem http://twitter.com/automatem _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds
freetds.log
(application/octet-stream, 28.2 KB)
log.c:196:Starting log file for FreeTDS 0.91
on 2012-09-26 09:29:07 with debug flags 0x4fff.
iconv.c:330:tds_iconv_open(0x12ff5c0, UTF-8)
iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
iconv.c:187:local name for UTF-8 is UTF-8
iconv.c:187:local name for UCS-2LE is UCS-2LE
iconv.c:187:local name for UCS-2BE is UCS-2BE
iconv.c:349:setting up conversions for client charset "UTF-8"
iconv.c:351:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:391:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:394:tds_iconv_open: done
net.c:205:Connecting to 192.168.23.35 port 1433 (TDS version 7.2)
net.c:270:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:310:tds_open_socket() succeeded
util.c:156:Changed query state from DEAD to IDLE
net.c:741:Sending packet
0000 12 01 00 3a 00 00 00 00-00 00 1a 00 06 01 00 20 |...:.... ....... |
0010 00 01 02 00 21 00 0c 03-00 2d 00 04 04 00 31 00 |....!... .-....1.|
0020 01 ff 09 00 00 00 00 00-00 4d 53 53 51 4c 53 65 |........ .MSSQLSe|
0030 72 76 65 72 00 dc 2c 00-00 00 |rver..,. ..|
net.c:555:Received header
0000 04 01 00 2b 00 00 01 00- |...+....|
net.c:609:Received packet
0000 04 01 00 2b 00 00 01 00-00 00 1a 00 06 01 00 20 |...+.... ....... |
0010 00 01 02 00 21 00 01 03-00 22 00 00 04 00 22 00 |....!... ."....".|
0020 01 ff 0a 32 09 c4 00 00-00 00 00 |...2.... ...|
login.c:1057:detected flag 0
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Allocating epoch #0
net.c:1257:GNUTLS: level 2:
ASSERT: gnutls_constate.c:695
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Allocating epoch #1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: RSA_AES_256_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: RSA_3DES_EDE_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: RSA_ARCFOUR_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: RSA_ARCFOUR_MD5
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: DHE_DSS_AES_256_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: DHE_DSS_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: DHE_DSS_3DES_EDE_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: DHE_DSS_ARCFOUR_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: DHE_RSA_AES_256_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: DHE_RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Keeping ciphersuite: DHE_RSA_3DES_EDE_CBC_SHA1
net.c:1257:GNUTLS: level 2:
EXT[0x1331f20]: Sending extension SAFE RENEGOTIATION (1 bytes)
net.c:1257:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (4.2) DSA-SHA256
net.c:1257:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (4.1) RSA-SHA256
net.c:1257:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (2.1) RSA-SHA1
net.c:1257:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (2.2) DSA-SHA1
net.c:1257:GNUTLS: level 2:
EXT[0x1331f20]: Sending extension SIGNATURE ALGORITHMS (10 bytes)
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: CLIENT HELLO was sent [88 bytes]
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 88 bytes of Data
net.c:1257:GNUTLS: level 7:
HWRITE: enqueued 88. Total 88 bytes.
net.c:1257:GNUTLS: level 7:
HWRITE FLUSH: 88 bytes in buffer.
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Sending Packet[0] Handshake(22) with length: 88
net.c:1257:GNUTLS: level 7:
WRITE: enqueued 93 bytes for 0x12ff5c0. Total 93 bytes.
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Sent Packet[1] Handshake(22) with length: 93
net.c:1257:GNUTLS: level 7:
HWRITE: wrote 88 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 7:
WRITE FLUSH: 93 bytes in buffer.
net.c:1240:in tds_push_func
net.c:1257:GNUTLS: level 7:
WRITE: wrote 93 bytes, 0 bytes left.
net.c:1199:in tds_pull_func
net.c:741:Sending packet
0000 12 01 00 65 00 00 00 00-16 03 00 00 58 01 00 00 |...e.... ....X...|
0010 54 03 03 50 62 22 24 68-ef f7 da a7 e0 5b 3a 2d |T..Pb"$h .....[:-|
0020 ec b2 7a b2 46 8e 9d 48-89 f1 8f 88 ff 28 13 be |..z.F..H .....(..|
0030 08 66 71 00 00 18 00 35-00 2f 00 0a 00 05 00 04 |.fq....5 ./......|
0040 00 38 00 32 00 13 00 66-00 39 00 33 00 16 01 00 |.8.2...f .9.3....|
0050 00 13 ff 01 00 01 00 00-0d 00 0a 00 08 04 02 04 |........ ........|
0060 01 02 01 02 02 - |.....|
net.c:1212:have 0
net.c:1216:before read
net.c:555:Received header
0000 12 01 02 69 00 00 00 00- |...i....|
net.c:609:Received packet
0000 12 01 02 69 00 00 00 00-16 03 01 02 5c 02 00 00 |...i.... ....\...|
0010 4d 03 01 50 62 22 21 35-ed 0c c4 21 37 df b4 a8 |M..Pb"!5 ...!7...|
0020 20 ad fd fa 97 f3 09 ec-36 84 7c b4 47 6c 93 a6 | ....... 6.|.Gl..|
0030 2b 72 8e 20 83 14 00 00-e9 9b f6 94 a6 b8 4c 02 |+r. .... ......L.|
0040 62 da 3e b4 36 ac c9 df-51 f9 fa 4c c6 bb b9 49 |b.>.6... Q..L...I|
0050 04 3d 01 43 00 2f 00 00-05 ff 01 00 01 00 0b 00 |.=.C./.. ........|
0060 02 03 00 02 00 00 01 fd-30 82 01 f9 30 82 01 62 |........ 0...0..b|
0070 a0 03 02 01 02 02 10 52-e5 76 2a 3d ed 3c a6 4a |.......R .v*=.<.J|
0080 ec af 10 01 86 af a4 30-0d 06 09 2a 86 48 86 f7 |.......0 ...*.H..|
0090 0d 01 01 05 05 00 30 3b-31 39 30 37 06 03 55 04 |......0; 1907..U.|
00a0 03 1e 30 00 53 00 53 00-4c 00 5f 00 53 00 65 00 |..0.S.S. L._.S.e.|
00b0 6c 00 66 00 5f 00 53 00-69 00 67 00 6e 00 65 00 |l.f._.S. i.g.n.e.|
00c0 64 00 5f 00 46 00 61 00-6c 00 6c 00 62 00 61 00 |d._.F.a. l.l.b.a.|
00d0 63 00 6b 30 1e 17 0d 31-32 30 39 32 32 31 30 30 |c.k0...1 20922100|
00e0 33 34 37 5a 17 0d 34 32-30 39 32 32 31 30 30 33 |347Z..42 09221003|
00f0 34 37 5a 30 3b 31 39 30-37 06 03 55 04 03 1e 30 |47Z0;190 7..U...0|
0100 00 53 00 53 00 4c 00 5f-00 53 00 65 00 6c 00 66 |.S.S.L._ .S.e.l.f|
0110 00 5f 00 53 00 69 00 67-00 6e 00 65 00 64 00 5f |._.S.i.g .n.e.d._|
0120 00 46 00 61 00 6c 00 6c-00 62 00 61 00 63 00 6b |.F.a.l.l .b.a.c.k|
0130 30 81 9f 30 0d 06 09 2a-86 48 86 f7 0d 01 01 01 |0..0...* .H......|
0140 05 00 03 81 8d 00 30 81-89 02 81 81 00 cb d1 2f |......0. ......./|
0150 ee 80 ef 32 79 20 01 1f-0f 9b 3e 7e ff a8 c1 c8 |...2y .. ..>~....|
0160 66 fb 8d 1c 74 51 12 58-b3 2b c3 2f c4 d5 28 bc |f...tQ.X .+./..(.|
0170 d6 bf 66 c1 cb 7b d5 e8-06 a6 c3 7a df 36 fc b8 |..f..{.. ...z.6..|
0180 4f a6 ff b2 a5 89 fe 74-1c 93 51 fc e1 3e 3f 97 |O......t ..Q..>?.|
0190 98 f5 b8 0b f5 54 d9 47-bf 77 e0 65 35 b7 1d fd |.....T.G .w.e5...|
01a0 0e 58 19 26 4f 6b 7a ea-6d ff f4 da 8f 3f ae 6f |.X.&Okz. m....?.o|
01b0 96 be 99 a0 7f 3c 9b 8d-b8 f9 b6 b4 3f 39 d0 36 |.....<.. ....?9.6|
01c0 8c cb 3e a1 84 82 96 47-19 96 7e 05 e7 02 03 01 |..>....G ..~.....|
01d0 00 01 30 0d 06 09 2a 86-48 86 f7 0d 01 01 05 05 |..0...*. H.......|
01e0 00 03 81 81 00 aa f7 02-3d 7a 0d 31 5f 74 a6 1c |........ =z.1_t..|
01f0 d9 0d b3 b1 0d cf 66 1d-18 3d 68 b2 74 24 09 81 |......f. .=h.t$..|
0200 26 8b 77 e5 24 69 74 5f-5e 08 0d da 8f 2a af af |&.w.$it_ ^....*..|
0210 61 16 76 8b 33 78 dc e9-c0 cb ec 54 3c 9b 97 51 |a.v.3x.. ...T<..Q|
0220 77 ad a1 c1 bb c7 5e 83-fa 06 6b c9 f2 8f f5 5a |w.....^. ..k....Z|
0230 d2 83 83 aa 32 19 37 2c-2c 7c 7a 95 1c 5e 58 23 |....2.7, ,|z..^X#|
0240 ad c1 79 8b f5 c3 93 45-3e e8 05 c2 08 97 7c 2e |..y....E >.....|.|
0250 bc ca 63 c5 a9 0a b0 7a-ac 49 5f 44 43 a0 cf eb |..c....z .I_DC...|
0260 f9 e9 39 b0 de 0e 00 00-00 |..9..... .|
net.c:1219:after read
net.c:1212:have 609
net.c:1223:read 5 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 5 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
READ: read 5 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
RB: Have 0 bytes into buffer. Adding 5 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 5 bytes
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Expected Packet[0] Handshake(22) with length: 1
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Received Packet[0] Handshake(22) with length: 604
net.c:1199:in tds_pull_func
net.c:1212:have 604
net.c:1223:read 604 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 604 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
READ: read 604 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
RB: Have 5 bytes into buffer. Adding 604 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 609 bytes
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Decrypted Packet[0] Handshake(22) with length: 604
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 604 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: SERVER HELLO was received [81 bytes]
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 77 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 77 bytes of Data
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Server's version: 3.1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: SessionID length: 32
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: SessionID: 83140000e99bf694a6b84c0262da3eb436acc9df51f9fa4cc6bbb949043d0143
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Selected cipher suite: RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 2:
EXT[0x1331f20]: Parsing extension 'SAFE RENEGOTIATION/65281' (1 bytes)
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Safe renegotiation succeeded
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: CERTIFICATE was received [519 bytes]
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 515 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 169 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 515 bytes of Data
net.c:1257:GNUTLS: level 2:
ASSERT: ext_signature.c:388
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: SERVER HELLO DONE was received [4 bytes]
net.c:1257:GNUTLS: level 2:
ASSERT: gnutls_handshake.c:1369
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 519 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: CLIENT KEY EXCHANGE was sent [134 bytes]
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 4 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 7:
HWRITE: enqueued 134. Total 134 bytes.
net.c:1257:GNUTLS: level 7:
HWRITE FLUSH: 134 bytes in buffer.
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Sending Packet[1] Handshake(22) with length: 134
net.c:1257:GNUTLS: level 7:
WRITE: enqueued 139 bytes for 0x12ff5c0. Total 139 bytes.
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Sent Packet[2] Handshake(22) with length: 139
net.c:1257:GNUTLS: level 7:
HWRITE: wrote 134 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 7:
WRITE FLUSH: 139 bytes in buffer.
net.c:1240:in tds_push_func
net.c:1257:GNUTLS: level 7:
WRITE: wrote 139 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 3:
REC[0x1331f20]: Sent ChangeCipherSpec
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Sending Packet[2] Change Cipher Spec(20) with length: 1
net.c:1257:GNUTLS: level 7:
WRITE: enqueued 6 bytes for 0x12ff5c0. Total 6 bytes.
net.c:1257:GNUTLS: level 7:
WRITE FLUSH: 6 bytes in buffer.
net.c:1240:in tds_push_func
net.c:1257:GNUTLS: level 7:
WRITE: wrote 6 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Sent Packet[3] Change Cipher Spec(20) with length: 6
net.c:1257:GNUTLS: level 9:
INT: PREMASTER SECRET[48]: 0303d4b836fcd4d7558cb065591f64b8cadbfa65af677d56eaf7f39361c9d4863210c3607eb03deb54bded6d39c862c7
net.c:1257:GNUTLS: level 9:
INT: CLIENT RANDOM[32]: 5062222468eff7daa7e05b3a2decb27ab2468e9d4889f18f88ff2813be086671
net.c:1257:GNUTLS: level 9:
INT: SERVER RANDOM[32]: 5062222135ed0cc42137dfb4a820adfdfa97f309ec36847cb4476c93a62b728e
net.c:1257:GNUTLS: level 9:
INT: MASTER SECRET: 15f3af251e038c3b23b57c6e71f6955be634a3e62902cc7aea24aa401c6e9b3949f0ab5bf6a44a2150b303b5ffc71538
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Initializing epoch #1
net.c:1257:GNUTLS: level 9:
INT: KEY BLOCK[104]: 8d25fd375ae831b04b68524b3d96fcab350bedfea4bde19cffec667b5b8da7b0
net.c:1257:GNUTLS: level 9:
INT: CLIENT WRITE KEY [16]: 32879a8c359e42664cb22f13ac9a367d
net.c:1257:GNUTLS: level 9:
INT: SERVER WRITE KEY [16]: 820cc3e5e5c8b0e5fb10c1cd28203f8f
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Epoch #1 ready
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Cipher Suite: RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Initializing internal [write] cipher sessions
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Start of epoch cleanup
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: End of epoch cleanup
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 0 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: recording tls-unique CB (send)
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: FINISHED was sent [16 bytes]
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 0 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 7:
HWRITE: enqueued 16. Total 16 bytes.
net.c:1257:GNUTLS: level 7:
HWRITE FLUSH: 16 bytes in buffer.
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Sending Packet[0] Handshake(22) with length: 16
net.c:1257:GNUTLS: level 7:
WRITE: enqueued 53 bytes for 0x12ff5c0. Total 53 bytes.
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Sent Packet[1] Handshake(22) with length: 53
net.c:1257:GNUTLS: level 7:
HWRITE: wrote 16 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 7:
WRITE FLUSH: 53 bytes in buffer.
net.c:1240:in tds_push_func
net.c:1257:GNUTLS: level 7:
WRITE: wrote 53 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 2:
ASSERT: ext_session_ticket.c:710
net.c:1199:in tds_pull_func
net.c:741:Sending packet
0000 12 01 00 ce 00 00 00 00-16 03 01 00 86 10 00 00 |........ ........|
0010 82 00 80 01 84 eb 85 0e-2a d5 19 8f cc a7 cf 89 |........ *.......|
0020 9a f3 72 e2 56 72 c8 7e-4d f3 07 d0 6b 8b a5 e3 |..r.Vr.~ M...k...|
0030 8c 36 ce 5e 2c 75 7f eb-55 aa f9 c6 3a 5e ed 4d |.6.^,u.. U...:^.M|
0040 20 d8 db c4 66 d9 3e 78-ca 38 94 db 40 db e4 9d | ...f.>x .8..@...|
0050 f4 3e 5a 42 b4 7b 39 b8-3a b9 7e ce 25 8b b0 c8 |.>ZB.{9. :.~.%...|
0060 89 8c 1d d0 ab f1 65 40-9f a4 b7 93 21 37 68 ff |......e@ ....!7h.|
0070 56 28 fd 53 9a ac f9 8f-c3 93 cb 12 37 fa 0b 89 |V(.S.... ....7...|
0080 2a 97 4d 64 83 ab 8d 62-70 40 81 7d 5d 6d 76 80 |*.Md...b p@.}]mv.|
0090 73 6e 5e 14 03 01 00 01-01 16 03 01 00 30 54 df |sn^..... .....0T.|
00a0 59 0a 5d 8b 6f 88 d3 96-8e 92 7a 09 29 82 b5 a6 |Y.].o... ..z.)...|
00b0 41 cd 67 af 7c aa af e8-4d 04 50 5f 3a a3 52 1c |A.g.|... M.P_:.R.|
00c0 89 37 49 22 09 97 60 14-d1 65 91 c2 1e 20 |.7I"..`. .e... |
net.c:1212:have 0
net.c:1216:before read
net.c:555:Received header
0000 12 01 00 43 00 00 00 00- |...C....|
net.c:609:Received packet
0000 12 01 00 43 00 00 00 00-14 03 01 00 01 01 16 03 |...C.... ........|
0010 01 00 30 c7 89 07 3b e3-72 61 92 80 4c 33 f9 95 |..0...;. ra..L3..|
0020 68 85 4e 27 5a bf ec 6d-31 df f5 c4 58 84 5d 8f |h.N'Z..m 1...X.].|
0030 50 bd 1a 61 9a 7c bb 25-18 e0 bc 14 cd a3 34 44 |P..a.|.% ......4D|
0040 fe 83 ac - |...|
net.c:1219:after read
net.c:1212:have 59
net.c:1223:read 5 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 5 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
READ: read 5 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
RB: Have 0 bytes into buffer. Adding 5 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 5 bytes
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Expected Packet[1] Change Cipher Spec(20) with length: 1
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Received Packet[1] Change Cipher Spec(20) with length: 1
net.c:1199:in tds_pull_func
net.c:1212:have 54
net.c:1223:read 1 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 1 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
READ: read 1 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
RB: Have 5 bytes into buffer. Adding 1 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 6 bytes
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: ChangeCipherSpec Packet was received
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: Cipher Suite: RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Start of epoch cleanup
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Epoch #0 freed
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: End of epoch cleanup
net.c:1199:in tds_pull_func
net.c:1212:have 53
net.c:1223:read 5 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 5 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
READ: read 5 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
RB: Have 0 bytes into buffer. Adding 5 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 5 bytes
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Expected Packet[0] Handshake(22) with length: 1
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Received Packet[0] Handshake(22) with length: 48
net.c:1199:in tds_pull_func
net.c:1212:have 48
net.c:1223:read 48 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 48 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
READ: read 48 bytes from 0x12ff5c0
net.c:1257:GNUTLS: level 7:
RB: Have 5 bytes into buffer. Adding 48 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 53 bytes
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Decrypted Packet[0] Handshake(22) with length: 16
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 16 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1257:GNUTLS: level 3:
HSK[0x1331f20]: FINISHED was received [16 bytes]
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 12 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 0 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 12 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Cleared Data from buffer
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Cleared Data from buffer
net.c:1370:handshake succeeded!!
login.c:782:quietly sending TDS 7+ login packet
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Cleared Data from buffer
net.c:1257:GNUTLS: level 4:
REC[0x1331f20]: Epoch #1 freed
token.c:328:tds_process_login_tokens()
net.c:555:Received header
0000 04 01 01 d1 00 45 01 00- |.....E..|
net.c:609:Received packet
0000 04 01 01 d1 00 45 01 00-e3 3d 00 01 17 45 00 78 |.....E.. .=...E.x|
0010 00 70 00 6f 00 72 00 74-00 49 00 6e 00 66 00 6f |.p.o.r.t .I.n.f.o|
0020 00 72 00 6d 00 61 00 74-00 69 00 6f 00 6e 00 53 |.r.m.a.t .i.o.n.S|
0030 00 79 00 73 00 74 00 65-00 6d 00 06 6d 00 61 00 |.y.s.t.e .m..m.a.|
0040 73 00 74 00 65 00 72 00-ab 90 00 45 16 00 00 02 |s.t.e.r. ...E....|
0050 00 36 00 43 00 68 00 61-00 6e 00 67 00 65 00 64 |.6.C.h.a .n.g.e.d|
0060 00 20 00 64 00 61 00 74-00 61 00 62 00 61 00 73 |. .d.a.t .a.b.a.s|
0070 00 65 00 20 00 63 00 6f-00 6e 00 74 00 65 00 78 |.e. .c.o .n.t.e.x|
0080 00 74 00 20 00 74 00 6f-00 20 00 27 00 45 00 78 |.t. .t.o . .'.E.x|
0090 00 70 00 6f 00 72 00 74-00 49 00 6e 00 66 00 6f |.p.o.r.t .I.n.f.o|
00a0 00 72 00 6d 00 61 00 74-00 69 00 6f 00 6e 00 53 |.r.m.a.t .i.o.n.S|
00b0 00 79 00 73 00 74 00 65-00 6d 00 27 00 2e 00 0b |.y.s.t.e .m.'....|
00c0 46 00 52 00 45 00 53 00-48 00 43 00 4f 00 53 00 |F.R.E.S. H.C.O.S.|
00d0 51 00 4c 00 31 00 00 01-00 00 00 e3 08 00 07 05 |Q.L.1... ........|
00e0 09 04 d0 00 00 00 e3 17-00 02 0a 75 00 73 00 5f |........ ...u.s._|
00f0 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 00 |.e.n.g.l .i.s.h..|
0100 ab 72 00 47 16 00 00 01-00 27 00 43 00 68 00 61 |.r.G.... .'.C.h.a|
0110 00 6e 00 67 00 65 00 64-00 20 00 6c 00 61 00 6e |.n.g.e.d . .l.a.n|
0120 00 67 00 75 00 61 00 67-00 65 00 20 00 73 00 65 |.g.u.a.g .e. .s.e|
0130 00 74 00 74 00 69 00 6e-00 67 00 20 00 74 00 6f |.t.t.i.n .g. .t.o|
0140 00 20 00 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |. .u.s._ .e.n.g.l|
0150 00 69 00 73 00 68 00 2e-00 0b 46 00 52 00 45 00 |.i.s.h.. ..F.R.E.|
0160 53 00 48 00 43 00 4f 00-53 00 51 00 4c 00 31 00 |S.H.C.O. S.Q.L.1.|
0170 00 01 00 00 00 ad 36 00-01 72 09 00 02 16 4d 00 |......6. .r....M.|
0180 69 00 63 00 72 00 6f 00-73 00 6f 00 66 00 74 00 |i.c.r.o. s.o.f.t.|
0190 20 00 53 00 51 00 4c 00-20 00 53 00 65 00 72 00 | .S.Q.L. .S.e.r.|
01a0 76 00 65 00 72 00 00 00-00 00 0a 32 09 c4 e3 13 |v.e.r... ...2....|
01b0 00 04 04 34 00 30 00 39-00 36 00 04 34 00 30 00 |...4.0.9 .6..4.0.|
01c0 39 00 36 00 fd 00 00 00-00 00 00 00 00 00 00 00 |9.6..... ........|
01d0 00 - |.|
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:337:looking for login token, got ab(INFO)
token.c:122:tds_process_default_tokens() marker is ab(INFO)
token.c:2588:tds_process_msg() reading message 5701 from server
token.c:2661:tds_process_msg() calling client msg handler
odbc.c:2270:msgno 5701 20003
token.c:2674:tds_process_msg() returning TDS_SUCCEED
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2419:tds_process_env_chg(): 5 bytes of collation data received
token.c:2420:tds->collation was
0000 00 00 00 00 00 - |.....|
iconv.c:988:setting server single-byte charset to "CP1252"
token.c:2430:tds->collation now
0000 09 04 d0 00 00 - |.....|
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:337:looking for login token, got ab(INFO)
token.c:122:tds_process_default_tokens() marker is ab(INFO)
token.c:2588:tds_process_msg() reading message 5703 from server
token.c:2661:tds_process_msg() calling client msg handler
odbc.c:2270:msgno 5703 20003
token.c:2674:tds_process_msg() returning TDS_SUCCEED
token.c:337:looking for login token, got ad(LOGINACK)
token.c:373:server reports TDS version 72.9.0.2
token.c:375:Product name for 0x72090002 is 2005
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2477:changing block size from 4096 to 4096
token.c:337:looking for login token, got fd(DONE)
token.c:122:tds_process_default_tokens() marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
token.c:2370: rows_affected = 0
token.c:438:tds_process_login_tokens() returning TDS_SUCCEED
odbc.c:4916:SQLGetFunctions: fFunction is 999
odbc.c:5831:SQLGetInfo(0x12fe100, 77, 0x7fff65411c80, 20, (nil))
odbc.c:5085:_SQLGetInfo(0x12fe100, 77, 0x7fff65411c80, 20, (nil))
error.c:517:SQLGetDiagRec(2, 0x12fe100, 1, 0x7fff654117d0, 0x7fff654113a4, 0x7fff654115d0, 512, 0x7fff654113a8)
odbc.c:1716:SQLAllocStmt(0x12fe100, 0x1339430)
odbc.c:1615:_SQLAllocStmt(0x12fe100, 0x1339430)
odbc.c:4388:SQLGetStmtAttr(0x1338ce0, 10010, 0x7fff65412dc8, 8, (nil))
odbc.c:4388:SQLGetStmtAttr(0x1338ce0, 10011, 0x7fff65412dc8, 8, (nil))
odbc.c:4388:SQLGetStmtAttr(0x1338ce0, 10012, 0x7fff65412dc8, 8, (nil))
odbc.c:4388:SQLGetStmtAttr(0x1338ce0, 10013, 0x7fff65412dc8, 8, (nil))
odbc.c:4445:SQLPrepare(0x1338ce0, set textsize 10000000
select attaRefTable from [Attachment] where ([Attachment].[attaId] = 10239)
, -3)
odbc.c:3496:SQLExecute(0x1338ce0)
prepare_query.c:203:parsing 0 parameters
odbc.c:3211:_SQLExecute(0x1338ce0)
odbc.c:3216:_SQLExecute() starting with state 0
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
util.c:156:Changed query state from QUERYING to PENDING
net.c:741:Sending packet
0000 03 01 01 0f 00 00 01 00-16 00 00 00 12 00 00 00 |........ ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 0d 00 00 00 00 01 26 04-00 00 00 63 00 00 00 00 |......&. ...c....|
0030 09 04 d0 00 00 ff ff ff-ff 00 00 63 c6 00 00 00 |........ ...c....|
0040 09 04 d0 00 00 c6 00 00-00 73 00 65 00 74 00 20 |........ .s.e.t. |
0050 00 74 00 65 00 78 00 74-00 73 00 69 00 7a 00 65 |.t.e.x.t .s.i.z.e|
0060 00 20 00 31 00 30 00 30-00 30 00 30 00 30 00 30 |. .1.0.0 .0.0.0.0|
0070 00 30 00 0a 00 73 00 65-00 6c 00 65 00 63 00 74 |.0...s.e .l.e.c.t|
0080 00 20 00 61 00 74 00 74-00 61 00 52 00 65 00 66 |. .a.t.t .a.R.e.f|
0090 00 54 00 61 00 62 00 6c-00 65 00 20 00 66 00 72 |.T.a.b.l .e. .f.r|
00a0 00 6f 00 6d 00 20 00 5b-00 41 00 74 00 74 00 61 |.o.m. .[ .A.t.t.a|
00b0 00 63 00 68 00 6d 00 65-00 6e 00 74 00 5d 00 20 |.c.h.m.e .n.t.]. |
00c0 00 77 00 68 00 65 00 72-00 65 00 20 00 28 00 5b |.w.h.e.r .e. .(.[|
00d0 00 41 00 74 00 74 00 61-00 63 00 68 00 6d 00 65 |.A.t.t.a .c.h.m.e|
00e0 00 6e 00 74 00 5d 00 2e-00 5b 00 61 00 74 00 74 |.n.t.].. .[.a.t.t|
00f0 00 61 00 49 00 64 00 5d-00 20 00 3d 00 20 00 31 |.a.I.d.] . .=. .1|
0100 00 30 00 32 00 33 00 39-00 29 00 20 00 0a 00 |.0.2.3.9 .). ...|
token.c:540:tds_process_tokens(0x12ff5c0, 0x7fff65412cb8, 0x7fff65412cbc, 0x6914)
util.c:156:Changed query state from PENDING to READING
net.c:555:Received header
0000 04 01 00 7a 00 45 01 00- |...z.E..|
net.c:609:Received packet
0000 04 01 00 7a 00 45 01 00-ff 01 00 be 00 00 00 00 |...z.E.. ........|
0010 00 00 00 00 00 81 01 00-00 00 00 00 09 00 a7 1e |........ ........|
0020 00 09 04 d0 00 34 0c 61-00 74 00 74 00 61 00 52 |.....4.a .t.t.a.R|
0030 00 65 00 66 00 54 00 61-00 62 00 6c 00 65 00 d1 |.e.f.T.a .b.l.e..|
0040 07 00 4c 6f 61 64 6f 75-74 ff 11 00 c1 00 01 00 |..Loadou t.......|
0050 00 00 00 00 00 00 79 00-00 00 00 ac 00 00 00 01 |......y. ........|
0060 00 00 00 00 00 00 26 04-04 01 00 00 00 fe 00 00 |......&. ........|
0070 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:555:processing result tokens. marker is ff(DONEINPROC)
token.c:2339:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2370: rows_affected = 0
util.c:156:Changed query state from READING to PENDING
odbc.c:3534:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3535: result_type=4054, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3599:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
odbc.c:3374:_SQLExecute: odbc_process_tokens returned result_type 4054
token.c:540:tds_process_tokens(0x12ff5c0, 0x7fff65412cb8, 0x7fff65412cbc, 0x6914)
util.c:156:Changed query state from PENDING to READING
token.c:555:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1515:processing TDS7 result metadata.
mem.c:615:tds_free_all_results()
token.c:1540:set current_results (1 column) to tds->res_info
token.c:1547:setting up 1 columns
token.c:1486:tds7_get_data_info:
colname = attaRefTable (12 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 30 (30 on server)
token.c:1556: name size/wsize type/wtype utype
token.c:1557: -------------------- --------------- --------------- -------
token.c:1567: attaRefTable 30/30 39/167 0
util.c:156:Changed query state from READING to PENDING
odbc.c:3534:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3535: result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3605:odbc_process_tokens: returning result_type 4049
odbc.c:3374:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:540:tds_process_tokens(0x12ff5c0, 0x7fff65412cb8, 0x7fff65412cbc, 0x6914)
util.c:156:Changed query state from PENDING to READING
token.c:555:processing result tokens. marker is d1(ROW)
token.c:666:tds_process_tokens::SET_RETURN stopping on current token
util.c:156:Changed query state from READING to PENDING
odbc.c:3534:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3535: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3605:odbc_process_tokens: returning result_type 4040
odbc.c:3374:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:3519:SQLExecute returns SQL_SUCCESS
odbc.c:4420:SQLNumResultCols(0x1338ce0, 0x7fff65412c48)
odbc.c:1919:SQLDescribeCol(0x1338ce0, 1, 0x7fff65412c50, 512, 0x7fff65412c4a, 0x12ff598, 0x12ff5a0, 0x7fff65412c4c, 0x7fff65412c4e)