Re: error for insert into varbinary column: Implicit conversion from data type varchar to varbinary is not allowed

Hari Krishna Dara <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]> 
>
> Date: Fri, 26 Feb 2010 15:30:05 +0100
> From: Frediano Ziglio <[email protected]>
> Subject: Re: [freetds] error for insert into varbinary column:
>        Implicit        conversion from data type varchar to varbinary is
> not allowed
> To: FreeTDS Development Group <[email protected]>
> Message-ID:
>        <[email protected]>
> Content-Type: text/plain; charset=UTF-8
> > Since I am using pyodbc.Buffer (which itself is mapped to python's
> built-in
> > buffer type), this is not text. If somewhere in the stack, it is being
> > treated as text, then it is a bug.
> >
> > -- Hari
>
> To narrow down the problem a DM log would help. If program bind
> pyodbc.Binary type to text this is a problem in pyodbc.
>
> Regards
>  Frediano
>
> I doubt it is a pyodbc binding problem since the same code works with
easysoft driver and all drivers on windows.  Besides, it is not even
reaching the bind stage yet, it fails right at the prepare. I have tracing
enabled for pyodbc and I can confirm that it fails in the prepare and bind
is not called yet. Also, when running in debug versions of python, pyodbc,
unixodbc and freetds the breakpoint is never reached when set in
SQLBindParameter. I can also confirm this from the DM log. I am attaching
the log generated while using freetds as well as easysoft, so you can see
the difference (it will help you open them side by side by using tool such
as vim diff). I am also attaching the freetds dump file in case it helps.

-- 
Thank you,
Hari

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
unixodbc.log.freetds (application/octet-stream, 7.2 KB) - not displayed
unixodbc.log.easysoft (application/octet-stream, 9.5 KB) - not displayed
freetds.log (application/octet-stream, 40.9 KB) 
log.c:196:Starting log file for FreeTDS 0.83.dev.20100122
	on 2010-02-26 03:33:17 with debug flags 0x4fff.
iconv.c:336:tds_iconv_open(0x821a868, ISO-8859-1)
iconv.c:197:local name for ISO-8859-1 is ISO-8859-1
iconv.c:197:local name for UTF-8 is UTF-8
iconv.c:197:local name for UCS-2LE is UCS-2LE
iconv.c:197:local name for UCS-2BE is UCS-2BE
iconv.c:364:setting up conversions for client charset "ISO-8859-1"
iconv.c:366:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:407:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:410:tds_iconv_open: done
net.c:221:Connecting to 10.40.8.116 port 1433 (TDS version 7.1)
net.c:277:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:317:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
net.c:786:Sending packet
0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|
0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(......|
0020 55 00 00 02 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 4f 26 00 00            -                        |O&..|

net.c:605:Received header
0000 04 01 00 25 00 00 01 00-                        |...%....|

net.c:659:Received packet
0000 04 01 00 25 00 00 01 00-00 00 15 00 06 01 00 1b |...%.... ........|
0010 00 01 02 00 1c 00 01 03-00 1d 00 00 ff 09 00 05 |........ ........|
0020 77 00 00 02 00         -                        |w....|

login.c:1040:detected flag 2
login.c:767:quietly sending TDS 7+ login packet
token.c:315:tds_process_login_tokens()
net.c:605:Received header
0000 04 01 01 79 00 44 01 00-                        |...y.D..|

net.c:659:Received packet
0000 04 01 01 79 00 44 01 00-e3 1b 00 01 06 65 00 6e |...y.D.. .....e.n|
0010 00 67 00 69 00 6e 00 65-00 06 6d 00 61 00 73 00 |.g.i.n.e ..m.a.s.|
0020 74 00 65 00 72 00 ab 66-00 45 16 00 00 02 00 25 |t.e.r..f .E.....%|
0030 00 43 00 68 00 61 00 6e-00 67 00 65 00 64 00 20 |.C.h.a.n .g.e.d. |
0040 00 64 00 61 00 74 00 61-00 62 00 61 00 73 00 65 |.d.a.t.a .b.a.s.e|
0050 00 20 00 63 00 6f 00 6e-00 74 00 65 00 78 00 74 |. .c.o.n .t.e.x.t|
0060 00 20 00 74 00 6f 00 20-00 27 00 65 00 6e 00 67 |. .t.o.  .'.e.n.g|
0070 00 69 00 6e 00 65 00 27-00 2e 00 08 53 00 55 00 |.i.n.e.' ....S.U.|
0080 52 00 46 00 49 00 4e 00-47 00 32 00 00 01 00 e3 |R.F.I.N. G.2.....|
0090 08 00 07 05 09 04 d0 00-34 00 e3 17 00 02 0a 75 |........ 4......u|
00a0 00 73 00 5f 00 65 00 6e-00 67 00 6c 00 69 00 73 |.s._.e.n .g.l.i.s|
00b0 00 68 00 00 ab 6a 00 47-16 00 00 01 00 27 00 43 |.h...j.G .....'.C|
00c0 00 68 00 61 00 6e 00 67-00 65 00 64 00 20 00 6c |.h.a.n.g .e.d. .l|
00d0 00 61 00 6e 00 67 00 75-00 61 00 67 00 65 00 20 |.a.n.g.u .a.g.e. |
00e0 00 73 00 65 00 74 00 74-00 69 00 6e 00 67 00 20 |.s.e.t.t .i.n.g. |
00f0 00 74 00 6f 00 20 00 75-00 73 00 5f 00 65 00 6e |.t.o. .u .s._.e.n|
0100 00 67 00 6c 00 69 00 73-00 68 00 2e 00 08 53 00 |.g.l.i.s .h....S.|
0110 55 00 52 00 46 00 49 00-4e 00 47 00 32 00 00 01 |U.R.F.I. N.G.2...|
0120 00 ad 36 00 01 71 00 00-01 16 4d 00 69 00 63 00 |..6..q.. ..M.i.c.|
0130 72 00 6f 00 73 00 6f 00-66 00 74 00 20 00 53 00 |r.o.s.o. f.t. .S.|
0140 51 00 4c 00 20 00 53 00-65 00 72 00 76 00 65 00 |Q.L. .S. e.r.v.e.|
0150 72 00 00 00 00 00 09 00-05 77 e3 13 00 04 04 34 |r....... .w.....4|
0160 00 30 00 39 00 36 00 04-34 00 30 00 39 00 36 00 |.0.9.6.. 4.0.9.6.|
0170 fd 00 00 00 00 00 00 00-00                      |........ .|

token.c:319:looking for login token, got  e3(ENVCHANGE)
token.c:111:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:319:looking for login token, got  ab(INFO)
token.c:111:tds_process_default_tokens() marker is ab(INFO)
token.c:2643:tds_process_msg() reading message 5701 from server
token.c:2716:tds_process_msg() calling client msg handler
odbc.c:2101:msgno 5701 20003
token.c:2729:tds_process_msg() returning TDS_SUCCEED
token.c:319:looking for login token, got  e3(ENVCHANGE)
token.c:111:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2474:tds_process_env_chg(): 5 bytes of collation data received
token.c:2475:tds->collation was
0000 00 00 00 00 00         -                        |.....|

iconv.c:1025:setting server single-byte charset to "CP1252"
token.c:2485:tds->collation now
0000 09 04 d0 00 34         -                        |....4|

token.c:319:looking for login token, got  e3(ENVCHANGE)
token.c:111:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:319:looking for login token, got  ab(INFO)
token.c:111:tds_process_default_tokens() marker is ab(INFO)
token.c:2643:tds_process_msg() reading message 5703 from server
token.c:2716:tds_process_msg() calling client msg handler
odbc.c:2101:msgno 5703 20003
token.c:2729:tds_process_msg() returning TDS_SUCCEED
token.c:319:looking for login token, got  ad(LOGINACK)
token.c:319:looking for login token, got  e3(ENVCHANGE)
token.c:111:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2532:changing block size from 4096 to 4096
token.c:319:looking for login token, got  fd(DONE)
token.c:111:tds_process_default_tokens() marker is fd(DONE)
token.c:2394:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2410:tds_process_end() state set to TDS_IDLE
token.c:2425:                rows_affected = 0
token.c:396:leaving tds_process_login_tokens() returning 1
mem.c:603:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:134:tds_put_string converting 19 bytes of "set textsize 10000 "
write.c:162:tds_put_string wrote 38 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:786:Sending packet
0000 01 01 00 2e 00 00 00 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 31 00 30 00 30 00-30 00 30 00 20 00       | .1.0.0. 0.0. .|

token.c:498:tds_process_tokens(0x821a868, 0xbfd28adc, 0xbfd28ad8, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:605:Received header
0000 04 01 00 11 00 44 01 00-                        |.....D..|

net.c:659:Received packet
0000 04 01 00 11 00 44 01 00-fd 00 00 be 00 00 00 00 |.....D.. ........|
0010 00                     -                        |.|

token.c:513:processing result tokens.  marker is  fd(DONE)
token.c:2394:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2410:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2425:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:498:tds_process_tokens(0x821a868, 0xbfd28adc, 0xbfd28ad8, 0x100)
token.c:501:tds_process_tokens() state is COMPLETED
odbc.c:4799:SQLGetFunctions: fFunction is 999
odbc.c:5714:SQLGetInfo(0x823ea58, 77, 0xbfd28de4, 20, (nil))
odbc.c:4968:_SQLGetInfo(0x823ea58, 77, 0xbfd28de4, 20, (nil)
error.c:616:SQLGetDiagRec(2, 0x823ea58, 1, 0xbfd2897a, 0xbfd28988, 0xbfd2877a, 512, 0xbfd28984)
error.c:621:SQLGetDiagRec returning 100
odbc.c:6057:SQLSetConnectAttr(0x823ea58, 102, (nil), -5)
odbc.c:5972:_SQLSetConnectAttr(0x823ea58, 102, (nil), -5)
odbc.c:235:change_autocommit: executing SET IMPLICIT_TRANSACTIONS ON
mem.c:603:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:134:tds_put_string converting 28 bytes of "SET IMPLICIT_TRANSACTIONS ON"
write.c:162:tds_put_string wrote 56 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:786:Sending packet
0000 01 01 00 40 00 00 01 00-53 00 45 00 54 00 20 00 |...@.... S.E.T. .|
0010 49 00 4d 00 50 00 4c 00-49 00 43 00 49 00 54 00 |I.M.P.L. I.C.I.T.|
0020 5f 00 54 00 52 00 41 00-4e 00 53 00 41 00 43 00 |_.T.R.A. N.S.A.C.|
0030 54 00 49 00 4f 00 4e 00-53 00 20 00 4f 00 4e 00 |T.I.O.N. S. .O.N.|

token.c:498:tds_process_tokens(0x821a868, 0xbfd2a24c, 0xbfd2a248, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:605:Received header
0000 04 01 00 11 00 44 01 00-                        |.....D..|

net.c:659:Received packet
0000 04 01 00 11 00 44 01 00-fd 00 00 b9 00 00 00 00 |.....D.. ........|
0010 00                     -                        |.|

token.c:513:processing result tokens.  marker is  fd(DONE)
token.c:2394:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2410:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2425:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:498:tds_process_tokens(0x821a868, 0xbfd2a24c, 0xbfd2a248, 0x100)
token.c:501:tds_process_tokens() state is COMPLETED
odbc.c:5714:SQLGetInfo(0x823ea58, 77, 0xbfd2abf8, 20, 0xbfd2ac1a)
odbc.c:4968:_SQLGetInfo(0x823ea58, 77, 0xbfd2abf8, 20, 0xbfd2ac1a
odbc.c:5714:SQLGetInfo(0x823ea58, 10002, 0xbfd2ac18, 2, 0xbfd2ac1a)
odbc.c:4968:_SQLGetInfo(0x823ea58, 10002, 0xbfd2ac18, 2, 0xbfd2ac1a
odbc.c:1573:SQLAllocStmt(0x823ea58, 0x8296f00)
odbc.c:1472:_SQLAllocStmt(0x823ea58, 0x8296f00)
odbc.c:4211:SQLGetStmtAttr(0x821b6a0, 10010, 0xbfd2a478, 4, (nil))
odbc.c:4211:SQLGetStmtAttr(0x821b6a0, 10011, 0xbfd2a478, 4, (nil))
odbc.c:4211:SQLGetStmtAttr(0x821b6a0, 10012, 0xbfd2a478, 4, (nil))
odbc.c:4211:SQLGetStmtAttr(0x821b6a0, 10013, 0xbfd2a478, 4, (nil))
odbc.c:5802:SQLGetTypeInfo(0x821b6a0, 93)
odbc.c:3047:_SQLExecute(0x821b6a0)
odbc.c:3052:_SQLExecute() starting with state 0
mem.c:603:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:134:tds_put_string converting 26 bytes of "EXEC sp_datatype_info 93,3"
write.c:162:tds_put_string wrote 52 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:786:Sending packet
0000 01 01 00 3c 00 00 01 00-45 00 58 00 45 00 43 00 |...<.... E.X.E.C.|
0010 20 00 73 00 70 00 5f 00-64 00 61 00 74 00 61 00 | .s.p._. d.a.t.a.|
0020 74 00 79 00 70 00 65 00-5f 00 69 00 6e 00 66 00 |t.y.p.e. _.i.n.f.|
0030 6f 00 20 00 39 00 33 00-2c 00 33 00             |o. .9.3. ,.3.|

token.c:498:tds_process_tokens(0x821a868, 0xbfd2a254, 0xbfd2a250, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:605:Received header
0000 04 01 03 b1 00 44 01 00-                        |.....D..|

net.c:659:Received packet
0000 04 01 03 b1 00 44 01 00-ff 11 00 c1 00 01 00 00 |.....D.. ........|
0010 00 ff 01 00 c0 00 00 00-00 00 ff 11 00 c1 00 01 |........ ........|
0020 00 00 00 ff 01 00 c0 00-00 00 00 00 ff 11 00 c1 |........ ........|
0030 00 01 00 00 00 ff 11 00-c1 00 01 00 00 00 81 14 |........ ........|
0040 00 00 01 21 00 e7 00 01-09 04 d0 00 34 09 54 00 |...!.... ....4.T.|
0050 59 00 50 00 45 00 5f 00-4e 00 41 00 4d 00 45 00 |Y.P.E._. N.A.M.E.|
0060 00 00 21 00 26 02 09 44-00 41 00 54 00 41 00 5f |..!.&..D .A.T.A._|
0070 00 54 00 59 00 50 00 45-00 00 00 21 00 26 04 09 |.T.Y.P.E ...!.&..|
0080 50 00 52 00 45 00 43 00-49 00 53 00 49 00 4f 00 |P.R.E.C. I.S.I.O.|
0090 4e 00 00 00 09 00 a7 20-00 09 04 f0 00 00 0e 4c |N......  .......L|
00a0 00 49 00 54 00 45 00 52-00 41 00 4c 00 5f 00 50 |.I.T.E.R .A.L._.P|
00b0 00 52 00 45 00 46 00 49-00 58 00 00 00 09 00 a7 |.R.E.F.I .X......|
00c0 20 00 09 04 f0 00 00 0e-4c 00 49 00 54 00 45 00 | ....... L.I.T.E.|
00d0 52 00 41 00 4c 00 5f 00-53 00 55 00 46 00 46 00 |R.A.L._. S.U.F.F.|
00e0 49 00 58 00 00 00 09 00-a7 20 00 09 04 f0 00 00 |I.X..... . ......|
00f0 0d 43 00 52 00 45 00 41-00 54 00 45 00 5f 00 50 |.C.R.E.A .T.E._.P|
0100 00 41 00 52 00 41 00 4d-00 53 00 00 00 21 00 26 |.A.R.A.M .S...!.&|
0110 02 08 4e 00 55 00 4c 00-4c 00 41 00 42 00 4c 00 |..N.U.L. L.A.B.L.|
0120 45 00 00 00 21 00 26 02-0e 43 00 41 00 53 00 45 |E...!.&. .C.A.S.E|
0130 00 5f 00 53 00 45 00 4e-00 53 00 49 00 54 00 49 |._.S.E.N .S.I.T.I|
0140 00 56 00 45 00 00 00 08-00 34 0a 53 00 45 00 41 |.V.E.... .4.S.E.A|
0150 00 52 00 43 00 48 00 41-00 42 00 4c 00 45 00 00 |.R.C.H.A .B.L.E..|
0160 00 09 00 26 02 12 55 00-4e 00 53 00 49 00 47 00 |...&..U. N.S.I.G.|
0170 4e 00 45 00 44 00 5f 00-41 00 54 00 54 00 52 00 |N.E.D._. A.T.T.R.|
0180 49 00 42 00 55 00 54 00-45 00 00 00 08 00 34 05 |I.B.U.T. E.....4.|
0190 4d 00 4f 00 4e 00 45 00-59 00 00 00 21 00 26 02 |M.O.N.E. Y...!.&.|
01a0 0e 41 00 55 00 54 00 4f-00 5f 00 49 00 4e 00 43 |.A.U.T.O ._.I.N.C|
01b0 00 52 00 45 00 4d 00 45-00 4e 00 54 00 00 01 21 |.R.E.M.E .N.T...!|
01c0 00 e7 00 01 09 04 d0 00-34 0f 4c 00 4f 00 43 00 |........ 4.L.O.C.|
01d0 41 00 4c 00 5f 00 54 00-59 00 50 00 45 00 5f 00 |A.L._.T. Y.P.E._.|
01e0 4e 00 41 00 4d 00 45 00-00 00 21 00 26 02 0d 4d |N.A.M.E. ..!.&..M|
01f0 00 49 00 4e 00 49 00 4d-00 55 00 4d 00 5f 00 53 |.I.N.I.M .U.M._.S|
0200 00 43 00 41 00 4c 00 45-00 00 00 21 00 26 02 0d |.C.A.L.E ...!.&..|
0210 4d 00 41 00 58 00 49 00-4d 00 55 00 4d 00 5f 00 |M.A.X.I. M.U.M._.|
0220 53 00 43 00 41 00 4c 00-45 00 00 00 21 00 26 02 |S.C.A.L. E...!.&.|
0230 0d 53 00 51 00 4c 00 5f-00 44 00 41 00 54 00 41 |.S.Q.L._ .D.A.T.A|
0240 00 5f 00 54 00 59 00 50-00 45 00 00 00 09 00 26 |._.T.Y.P .E.....&|
0250 02 10 53 00 51 00 4c 00-5f 00 44 00 41 00 54 00 |..S.Q.L. _.D.A.T.|
0260 45 00 54 00 49 00 4d 00-45 00 5f 00 53 00 55 00 |E.T.I.M. E._.S.U.|
0270 42 00 00 00 21 00 26 04-0e 4e 00 55 00 4d 00 5f |B...!.&. .N.U.M._|
0280 00 50 00 52 00 45 00 43-00 5f 00 52 00 41 00 44 |.P.R.E.C ._.R.A.D|
0290 00 49 00 58 00 00 00 21-00 26 02 12 49 00 4e 00 |.I.X...! .&..I.N.|
02a0 54 00 45 00 52 00 56 00-41 00 4c 00 5f 00 50 00 |T.E.R.V. A.L._.P.|
02b0 52 00 45 00 43 00 49 00-53 00 49 00 4f 00 4e 00 |R.E.C.I. S.I.O.N.|
02c0 00 00 21 00 26 02 08 55-00 53 00 45 00 52 00 54 |..!.&..U .S.E.R.T|
02d0 00 59 00 50 00 45 00 a9-08 00 02 00 0c 00 0b 00 |.Y.P.E.. ........|
02e0 14 00 d1 10 00 64 00 61-00 74 00 65 00 74 00 69 |.....d.a .t.e.t.i|
02f0 00 6d 00 65 00 02 5d 00-04 17 00 00 00 01 00 27 |.m.e..]. .......'|
0300 01 00 27 ff ff 02 01 00-02 00 00 03 00 00 00 00 |..'..... ........|
0310 00 10 00 64 00 61 00 74-00 65 00 74 00 69 00 6d |...d.a.t .e.t.i.m|
0320 00 65 00 02 03 00 02 03-00 02 09 00 02 03 00 00 |.e...... ........|
0330 00 02 0c 00 d1 1a 00 73-00 6d 00 61 00 6c 00 6c |.......s .m.a.l.l|
0340 00 64 00 61 00 74 00 65-00 74 00 69 00 6d 00 65 |.d.a.t.e .t.i.m.e|
0350 00 02 5d 00 04 10 00 00-00 01 00 27 01 00 27 ff |..]..... ...'..'.|
0360 ff 02 01 00 02 00 00 03-00 00 00 00 00 1a 00 73 |........ .......s|
0370 00 6d 00 61 00 6c 00 6c-00 64 00 61 00 74 00 65 |.m.a.l.l .d.a.t.e|
0380 00 74 00 69 00 6d 00 65-00 02 00 00 02 00 00 02 |.t.i.m.e ........|
0390 09 00 02 03 00 00 00 02-16 00 ff 11 00 c1 00 02 |........ ........|
03a0 00 00 00 79 00 00 00 00-fe 00 00 e0 00 00 00 00 |...y.... ........|
03b0 00                     -                        |.|

token.c:513:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2394:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2425:                rows_affected = 1
util.c:162:Changed query state from READING to PENDING
odbc.c:3363:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3364:    result_type=4054, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3428:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
odbc.c:3203:_SQLExecute: odbc_process_tokens returned result_type 4054
token.c:498:tds_process_tokens(0x821a868, 0xbfd2a254, 0xbfd2a250, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2394:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2425:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
odbc.c:3363:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3364:    result_type=4054, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3428:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
odbc.c:3203:_SQLExecute: odbc_process_tokens returned result_type 4054
token.c:498:tds_process_tokens(0x821a868, 0xbfd2a254, 0xbfd2a250, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2394:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2425:                rows_affected = 1
util.c:162:Changed query state from READING to PENDING
odbc.c:3363:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3364:    result_type=4054, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3428:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
odbc.c:3203:_SQLExecute: odbc_process_tokens returned result_type 4054
token.c:498:tds_process_tokens(0x821a868, 0xbfd2a254, 0xbfd2a250, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2394:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2425:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
odbc.c:3363:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3364:    result_type=4054, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3428:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
odbc.c:3203:_SQLExecute: odbc_process_tokens returned result_type 4054
token.c:498:tds_process_tokens(0x821a868, 0xbfd2a254, 0xbfd2a250, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2394:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2425:                rows_affected = 1
util.c:162:Changed query state from READING to PENDING
odbc.c:3363:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3364:    result_type=4054, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3428:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
odbc.c:3203:_SQLExecute: odbc_process_tokens returned result_type 4054
token.c:498:tds_process_tokens(0x821a868, 0xbfd2a254, 0xbfd2a250, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2394:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2425:                rows_affected = 1
util.c:162:Changed query state from READING to PENDING
odbc.c:3363:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3364:    result_type=4054, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3428:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
odbc.c:3203:_SQLExecute: odbc_process_tokens returned result_type 4054
token.c:498:tds_process_tokens(0x821a868, 0xbfd2a254, 0xbfd2a250, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1530:processing TDS7 result metadata.
mem.c:603:tds_free_all_results()
token.c:1554:set current_results (20 columns) to tds->res_info
token.c:1565:setting up column 0
token.c:1500:tds7_get_data_info: 
	colname = TYPE_NAME (9 bytes)
	type = 39 (varchar)
	server's type = 231 (x UCS-2 varchar)
	column_varint_size = 2
	column_size = 256 (256 on server)
token.c:1565:setting up column 1
token.c:1500:tds7_get_data_info: 
	colname = DATA_TYPE (9 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 2
token.c:1500:tds7_get_data_info: 
	colname = PRECISION (9 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
token.c:1565:setting up column 3
token.c:1500:tds7_get_data_info: 
	colname = LITERAL_PREFIX (14 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 32 (32 on server)
token.c:1565:setting up column 4
token.c:1500:tds7_get_data_info: 
	colname = LITERAL_SUFFIX (14 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 32 (32 on server)
token.c:1565:setting up column 5
token.c:1500:tds7_get_data_info: 
	colname = CREATE_PARAMS (13 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 32 (32 on server)
token.c:1565:setting up column 6
token.c:1500:tds7_get_data_info: 
	colname = NULLABLE (8 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 7
token.c:1500:tds7_get_data_info: 
	colname = CASE_SENSITIVE (14 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 8
token.c:1500:tds7_get_data_info: 
	colname = SEARCHABLE (10 bytes)
	type = 52 (smallint)
	server's type = 52 (smallint)
	column_varint_size = 0
	column_size = 2 (2 on server)
token.c:1565:setting up column 9
token.c:1500:tds7_get_data_info: 
	colname = UNSIGNED_ATTRIBUTE (18 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 10
token.c:1500:tds7_get_data_info: 
	colname = MONEY (5 bytes)
	type = 52 (smallint)
	server's type = 52 (smallint)
	column_varint_size = 0
	column_size = 2 (2 on server)
token.c:1565:setting up column 11
token.c:1500:tds7_get_data_info: 
	colname = AUTO_INCREMENT (14 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 12
token.c:1500:tds7_get_data_info: 
	colname = LOCAL_TYPE_NAME (15 bytes)
	type = 39 (varchar)
	server's type = 231 (x UCS-2 varchar)
	column_varint_size = 2
	column_size = 256 (256 on server)
token.c:1565:setting up column 13
token.c:1500:tds7_get_data_info: 
	colname = MINIMUM_SCALE (13 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 14
token.c:1500:tds7_get_data_info: 
	colname = MAXIMUM_SCALE (13 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 15
token.c:1500:tds7_get_data_info: 
	colname = SQL_DATA_TYPE (13 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 16
token.c:1500:tds7_get_data_info: 
	colname = SQL_DATETIME_SUB (16 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 17
token.c:1500:tds7_get_data_info: 
	colname = NUM_PREC_RADIX (14 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
token.c:1565:setting up column 18
token.c:1500:tds7_get_data_info: 
	colname = INTERVAL_PRECISION (18 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
token.c:1565:setting up column 19
token.c:1500:tds7_get_data_info: 
	colname = USERTYPE (8 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 2 (2 on server)
util.c:162:Changed query state from READING to PENDING
odbc.c:3363:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3364:    result_type=4049, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3434:odbc_process_tokens: returning result_type 4049
odbc.c:3203:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:498:tds_process_tokens(0x821a868, 0xbfd2a254, 0xbfd2a250, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  a9(ORDERBY)
token.c:111:tds_process_default_tokens() marker is a9(ORDERBY)
token.c:226:Eating ORDERBY token
token.c:513:processing result tokens.  marker is  d1(ROW)
token.c:624:tds_process_tokens::SET_RETURN stopping on current token
util.c:162:Changed query state from READING to PENDING
odbc.c:3363:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3364:    result_type=4040, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3434:odbc_process_tokens: returning result_type 4040
odbc.c:3203:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:3764:SQLFetch(0x821b6a0)
odbc.c:3500:_SQLFetch(0x821b6a0, 1, 0)
token.c:498:tds_process_tokens(0x821a868, 0xbfd2a294, 0xbfd2a290, 0x6508)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  d1(ROW)
token.c:2359:tds_process_row(): reading column 0 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is 16 
token.c:2359:tds_process_row(): reading column 1 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 2 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 4 
token.c:2359:tds_process_row(): reading column 3 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is 1 
token.c:2359:tds_process_row(): reading column 4 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is 1 
token.c:2359:tds_process_row(): reading column 5 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 6 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 7 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 8 
token.c:2104:tds_get_data: type 52, varint size 0
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 9 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 10 
token.c:2104:tds_get_data: type 52, varint size 0
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 11 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 12 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is 16 
token.c:2359:tds_process_row(): reading column 13 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 14 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 15 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 16 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 17 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 18 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 19 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
util.c:162:Changed query state from READING to PENDING
odbc.c:3363:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3364:    result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3434:odbc_process_tokens: returning result_type 4040
odbc.c:4702:SQLGetData(0x821b6a0, 3, 4, 0xbfd2ac0c, 4, (nil))
convert_tds2sql.c:155:odbc_tds2sql: src is 56 dest = 4
odbc.c:3977:SQLFreeStmt(0x821b6a0, 0)
odbc.c:3898:_SQLFreeStmt(0x821b6a0, 0, 0)
query.c:2032:tds_send_cancel: not in_cancel and not idle
query.c:2041:tds_send_cancel: sending cancel packet
net.c:786:Sending packet
0000 06 01 00 08 00 00 01 00-                        |........|

token.c:498:tds_process_tokens(0x821a868, 0xbfd2a2fc, (nil), 0x0)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  d1(ROW)
token.c:2359:tds_process_row(): reading column 0 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is 26 
token.c:2359:tds_process_row(): reading column 1 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 2 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 4 
token.c:2359:tds_process_row(): reading column 3 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is 1 
token.c:2359:tds_process_row(): reading column 4 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is 1 
token.c:2359:tds_process_row(): reading column 5 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 6 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 7 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 8 
token.c:2104:tds_get_data: type 52, varint size 0
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 9 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 10 
token.c:2104:tds_get_data: type 52, varint size 0
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 11 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 12 
token.c:2104:tds_get_data: type 39, varint size 2
token.c:2165:tds_get_data(): wire column size is 26 
token.c:2359:tds_process_row(): reading column 13 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 14 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 15 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 16 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:2359:tds_process_row(): reading column 17 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 18 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is -1 
token.c:2359:tds_process_row(): reading column 19 
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is 2 
token.c:513:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2394:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2425:                rows_affected = 2
token.c:513:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:648:tds_process_tokens: return status is 0
token.c:513:processing result tokens.  marker is  fe(DONEPROC)
token.c:2394:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2425:                rows_affected = 0
net.c:605:Received header
0000 04 01 00 11 00 44 01 00-                        |.....D..|

net.c:659:Received packet
0000 04 01 00 11 00 44 01 00-fd 20 00 fd 00 00 00 00 |.....D.. . ......|
0010 00                     -                        |.|

token.c:513:processing result tokens.  marker is  fd(DONE)
token.c:2394:tds_process_end: more_results = 0
		was_cancelled = 1
		error = 0
		done_count_valid = 0
token.c:2410:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2425:                rows_affected = 0
odbc.c:1573:SQLAllocStmt(0x823ea58, 0x829f708)
odbc.c:1472:_SQLAllocStmt(0x823ea58, 0x829f708)
odbc.c:4211:SQLGetStmtAttr(0x8247a40, 10010, 0xbfd2ac28, 4, (nil))
odbc.c:4211:SQLGetStmtAttr(0x8247a40, 10011, 0xbfd2ac28, 4, (nil))
odbc.c:4211:SQLGetStmtAttr(0x8247a40, 10012, 0xbfd2ac28, 4, (nil))
odbc.c:4211:SQLGetStmtAttr(0x8247a40, 10013, 0xbfd2ac28, 4, (nil))
odbc.c:3977:SQLFreeStmt(0x8247a40, 0)
odbc.c:3898:_SQLFreeStmt(0x8247a40, 0, 0)
odbc.c:4256:SQLPrepare(0x8247a40, INSERT INTO testing (varbinary_col) VALUES (?), -3)
prepare_query.c:203:parsing 0 parameters
prepare_query.c:208:parse_prepared_query: logic_error: parameter out of bounds: 1 > 0 || 1 > 0
odbc.c:4321:Creating prepared statement
mem.c:603:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:134:tds_put_string converting 3 bytes of "@P1"
write.c:162:tds_put_string wrote 6 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:786:Sending packet
0000 03 01 00 ba 00 00 01 00-ff ff 0b 00 00 00 00 01 |........ ........|
0010 26 04 00 00 00 63 1e 00-00 00 09 04 d0 00 34 1e |&....c.. ......4.|
0020 00 00 00 40 00 50 00 31-00 20 00 76 00 61 00 72 |[email protected] . .v.a.r|
0030 00 63 00 68 00 61 00 72-00 28 00 38 00 30 00 29 |.c.h.a.r .(.8.0.)|
0040 00 00 00 63 60 00 00 00-09 04 d0 00 34 60 00 00 |...c`... ....4`..|
0050 00 49 00 4e 00 53 00 45-00 52 00 54 00 20 00 49 |.I.N.S.E .R.T. .I|
0060 00 4e 00 54 00 4f 00 20-00 74 00 65 00 73 00 74 |.N.T.O.  .t.e.s.t|
0070 00 69 00 6e 00 67 00 20-00 28 00 76 00 61 00 72 |.i.n.g.  .(.v.a.r|
0080 00 62 00 69 00 6e 00 61-00 72 00 79 00 5f 00 63 |.b.i.n.a .r.y._.c|
0090 00 6f 00 6c 00 29 00 20-00 56 00 41 00 4c 00 55 |.o.l.).  .V.A.L.U|
00a0 00 45 00 53 00 20 00 28-00 40 00 50 00 31 00 29 |.E.S. .( [email protected].)|
00b0 00 00 00 26 04 04 01 00-00 00                   |...&.... ..|

token.c:498:tds_process_tokens(0x821a868, 0xbfd2aa28, 0xbfd2aa24, 0x104)
util.c:162:Changed query state from PENDING to READING
net.c:605:Received header
0000 04 01 01 8c 00 44 01 00-                        |.....D..|

net.c:659:Received packet
0000 04 01 01 8c 00 44 01 00-aa 02 01 01 01 00 00 03 |.....D.. ........|
0010 10 73 00 49 00 6d 00 70-00 6c 00 69 00 63 00 69 |.s.I.m.p .l.i.c.i|
0020 00 74 00 20 00 63 00 6f-00 6e 00 76 00 65 00 72 |.t. .c.o .n.v.e.r|
0030 00 73 00 69 00 6f 00 6e-00 20 00 66 00 72 00 6f |.s.i.o.n . .f.r.o|
0040 00 6d 00 20 00 64 00 61-00 74 00 61 00 20 00 74 |.m. .d.a .t.a. .t|
0050 00 79 00 70 00 65 00 20-00 76 00 61 00 72 00 63 |.y.p.e.  .v.a.r.c|
0060 00 68 00 61 00 72 00 20-00 74 00 6f 00 20 00 76 |.h.a.r.  .t.o. .v|
0070 00 61 00 72 00 62 00 69-00 6e 00 61 00 72 00 79 |.a.r.b.i .n.a.r.y|
0080 00 20 00 69 00 73 00 20-00 6e 00 6f 00 74 00 20 |. .i.s.  .n.o.t. |
0090 00 61 00 6c 00 6c 00 6f-00 77 00 65 00 64 00 2e |.a.l.l.o .w.e.d..|
00a0 00 20 00 55 00 73 00 65-00 20 00 74 00 68 00 65 |. .U.s.e . .t.h.e|
00b0 00 20 00 43 00 4f 00 4e-00 56 00 45 00 52 00 54 |. .C.O.N .V.E.R.T|
00c0 00 20 00 66 00 75 00 6e-00 63 00 74 00 69 00 6f |. .f.u.n .c.t.i.o|
00d0 00 6e 00 20 00 74 00 6f-00 20 00 72 00 75 00 6e |.n. .t.o . .r.u.n|
00e0 00 20 00 74 00 68 00 69-00 73 00 20 00 71 00 75 |. .t.h.i .s. .q.u|
00f0 00 65 00 72 00 79 00 2e-00 08 53 00 55 00 52 00 |.e.r.y.. ..S.U.R.|
0100 46 00 49 00 4e 00 47 00-32 00 00 01 00 aa 62 00 |F.I.N.G. 2.....b.|
0110 f4 1f 00 00 01 10 23 00-53 00 74 00 61 00 74 00 |......#. S.t.a.t.|
0120 65 00 6d 00 65 00 6e 00-74 00 28 00 73 00 29 00 |e.m.e.n. t.(.s.).|
0130 20 00 63 00 6f 00 75 00-6c 00 64 00 20 00 6e 00 | .c.o.u. l.d. .n.|
0140 6f 00 74 00 20 00 62 00-65 00 20 00 70 00 72 00 |o.t. .b. e. .p.r.|
0150 65 00 70 00 61 00 72 00-65 00 64 00 2e 00 08 53 |e.p.a.r. e.d....S|
0160 00 55 00 52 00 46 00 49-00 4e 00 47 00 32 00 00 |.U.R.F.I .N.G.2..|
0170 01 00 79 f4 1f 00 00 ac-09 00 00 01 00 00 00 00 |..y..... ........|
0180 26 04 00 fe 02 00 e0 00-00 00 00 00             |&....... ....|

token.c:513:processing result tokens.  marker is  aa(ERROR)
token.c:111:tds_process_default_tokens() marker is aa(ERROR)
token.c:2643:tds_process_msg() reading message 257 from server
token.c:2716:tds_process_msg() calling client msg handler
odbc.c:2101:msgno 257 20003
token.c:2729:tds_process_msg() returning TDS_SUCCEED
token.c:513:processing result tokens.  marker is  aa(ERROR)
token.c:111:tds_process_default_tokens() marker is aa(ERROR)
token.c:2643:tds_process_msg() reading message 8180 from server
token.c:2716:tds_process_msg() calling client msg handler
odbc.c:2101:msgno 8180 20003
token.c:2729:tds_process_msg() returning TDS_SUCCEED
token.c:513:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:513:processing result tokens.  marker is  ac(PARAM)
token.c:570:processing parameters for sp 11
token.c:572:calling tds_process_param_result
token.c:1201:tds_process_param_result(0x821a868, 0xbfd2a9c4)
token.c:1586:tds_get_data_info(0x821a868, 0x82e4c38, 1) [for parameter]
token.c:1649:processing result. type = 38(integer-null), varint_size 1
token.c:1675:processing result. column_size 4
token.c:2104:tds_get_data: type 38, varint size 1
token.c:2165:tds_get_data(): wire column size is -1 
log.c:499:cannot log data for type integer-null
token.c:576:1 hidden return parameters
token.c:513:processing result tokens.  marker is  fe(DONEPROC)
token.c:2394:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 1
		done_count_valid = 0
token.c:2410:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2425:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:498:tds_process_tokens(0x821a868, 0xbfd2aa28, 0xbfd2aa24, 0x104)
token.c:501:tds_process_tokens() state is COMPLETED
error.c:616:SQLGetDiagRec(3, 0x8247a40, 1, 0xbfd2a9fa, 0xbfd2aa08, 0xbfd2a7fa, 512, 0xbfd2aa04)
error.c:562:_SQLError: "Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query."
error.c:621:SQLGetDiagRec returning 0
error.c:616:SQLGetDiagRec(3, 0x8247a40, 2, 0xbfd2a9fa, 0xbfd2aa08, 0xbfd2a7fa, 512, 0xbfd2aa04)
error.c:562:_SQLError: "Statement(s) could not be prepared."
error.c:621:SQLGetDiagRec returning 0
error.c:616:SQLGetDiagRec(3, 0x8247a40, 3, 0xbfd2a9fa, 0xbfd2aa08, 0xbfd2a7fa, 512, 0xbfd2aa04)
error.c:621:SQLGetDiagRec returning 100
error.c:616:SQLGetDiagRec(3, 0x8247a40, 1, 0xbfd2ab18, 0xbfd2ab24, 0xbfd2a718, 1023, 0xbfd2ab2a)
error.c:562:_SQLError: "Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query."
error.c:621:SQLGetDiagRec returning 0
odbc.c:3977:SQLFreeStmt(0x8247a40, 0)
odbc.c:3898:_SQLFreeStmt(0x8247a40, 0, 0)
odbc.c:3809:SQLFreeHandle(3, 0x0x8247a40)
odbc.c:3898:_SQLFreeStmt(0x8247a40, 1, 0)
odbc.c:4521:SQLEndTran(2, 0x823ea58, 1)
odbc.c:4499:_SQLTransact((nil), 0x823ea58, 1)
odbc.c:4460:change_transaction(0x0x823ea58,0)
mem.c:603:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:134:tds_put_string converting 27 bytes of "IF @@TRANCOUNT > 0 ROLLBACK"
write.c:162:tds_put_string wrote 54 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:786:Sending packet
0000 01 01 00 3e 00 00 01 00-49 00 46 00 20 00 40 00 |...>.... I.F. .@.|
0010 40 00 54 00 52 00 41 00-4e 00 43 00 4f 00 55 00 |@.T.R.A. N.C.O.U.|
0020 4e 00 54 00 20 00 3e 00-20 00 30 00 20 00 52 00 |N.T. .>.  .0. .R.|
0030 4f 00 4c 00 4c 00 42 00-41 00 43 00 4b 00       |O.L.L.B. A.C.K.|

token.c:498:tds_process_tokens(0x821a868, 0xbfd2ad4c, 0xbfd2ad48, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:605:Received header
0000 04 01 00 1a 00 44 01 00-                        |.....D..|

net.c:659:Received packet
0000 04 01 00 1a 00 44 01 00-fd 01 00 c0 00 00 00 00 |.....D.. ........|
0010 00 fd 00 00 d2 00 00 00-00 00                   |........ ..|

token.c:513:processing result tokens.  marker is  fd(DONE)
token.c:2394:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2425:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
token.c:498:tds_process_tokens(0x821a868, 0xbfd2ad4c, 0xbfd2ad48, 0x100)
util.c:162:Changed query state from PENDING to READING
token.c:513:processing result tokens.  marker is  fd(DONE)
token.c:2394:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2410:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2425:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:498:tds_process_tokens(0x821a868, 0xbfd2ad4c, 0xbfd2ad48, 0x100)
token.c:501:tds_process_tokens() state is COMPLETED
odbc.c:5714:SQLGetInfo(0x823ea58, 23, 0x8246620, 2, 0xbfd2aeea)
odbc.c:4968:_SQLGetInfo(0x823ea58, 23, 0x8246620, 2, 0xbfd2aeea
odbc.c:5714:SQLGetInfo(0x823ea58, 24, 0x8246622, 2, 0xbfd2aeea)
odbc.c:4968:_SQLGetInfo(0x823ea58, 24, 0x8246622, 2, 0xbfd2aeea
odbc.c:2074:SQLDisconnect(0x823ea58)
odbc.c:3898:_SQLFreeStmt(0x821b6a0, 1, 1)
mem.c:603:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
odbc.c:3809:SQLFreeHandle(2, 0x0x823ea58)
odbc.c:3835:_SQLFreeConnect(0x823ea58)
odbc.c:3809:SQLFreeHandle(1, 0x0x8247b50)
odbc.c:3873:_SQLFreeEnv(0x8247b50)
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.