freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] Unable to query MSSQL server using freetds
- From: "Belden, Alvin (H USA)" <alvin.belden AT siemens.com>
- To: <freetds AT lists.ibiblio.org>
- Subject: [freetds] Unable to query MSSQL server using freetds
- Date: Tue, 28 Sep 2010 13:02:59 -0400
Hi All,
We are trying to port our applications that currently use Ct Lib/Sybase to
Sql Server using the Ct lib supplied by FreeTds. We are able to connect to
and switch databases but fail to query. We're running the following versions:
Linux (application (C++) server) - Red Hat Enterprise Linux Server release
5.4 (Tikanga)
FreeTds - 082
MSSQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
The problem with the query seems to be (from the dump below) that the single
parameter to stored procedure get_users_info, being passed as RADRAD is
truncated to RADR. I have tried different parameter strings but whatever I
pass appears from the dump to be truncated and therefore returns nothing. I
have also tried making the parameter larger than the actual field in the
table in the hope that the truncation would result in a match. Running in
Isql, I can run the same stored procedure and it works fine.
Below is the tdsdump running from a C++ application. After that, is the dump
running the same stored proc from Isql. Appreciate any help.
log.c:190:Starting log file for FreeTDS 0.82
on 2010-09-28 12:50:18 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character
set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:836:tds7_get_instance_port(192.168.142.28, WFSLR_DEV)
net.c:936:instance info
0000 05 5d 00 53 65 72 76 65-72 4e 61 6d 65 3b 4d 4c |.].Serve rName;ML|
0010 56 56 52 44 44 42 53 31-31 3b 49 6e 73 74 61 6e |VVRDDBS1 1;Instan|
0020 63 65 4e 61 6d 65 3b 57-46 53 4c 52 5f 44 45 56 |ceName;W FSLR_DEV|
0030 3b 49 73 43 6c 75 73 74-65 72 65 64 3b 4e 6f 3b |;IsClust ered;No;|
0040 56 65 72 73 69 6f 6e 3b-31 30 2e 35 30 2e 31 36 |Version; 10.50.16|
0050 30 30 2e 31 3b 74 63 70-3b 34 39 33 30 33 3b 3b |00.1;tcp ;49303;;|
net.c:974:instance port is 49303
net.c:210:Connecting to 192.168.142.28 port 49303 (TDS version 8.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:303:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
net.c:592:Received header
0000 04 01 01 ad 00 38 01 00- |.....8..|
net.c:671:Received packet
0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |.....m.a .s.t.e.r|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 80 |..m.a.s. t.e.r...|
0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d. .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|
0070 00 2e 00 15 4d 00 4c 00-56 00 56 00 52 00 44 00 |....M.L. V.V.R.D.|
0080 44 00 42 00 53 00 31 00-31 00 5c 00 57 00 46 00 |D.B.S.1. 1.\.W.F.|
0090 53 00 4c 00 52 00 5f 00-44 00 45 00 56 00 00 01 |S.L.R._. D.E.V...|
00a0 00 e3 08 00 07 05 09 04-d0 00 34 00 e3 17 00 02 |........ ..4.....|
00b0 0a 75 00 73 00 5f 00 65-00 6e 00 67 00 6c 00 69 |.u.s._.e .n.g.l.i|
00c0 00 73 00 68 00 00 ab 84-00 47 16 00 00 01 00 27 |.s.h.... .G.....'|
00d0 00 43 00 68 00 61 00 6e-00 67 00 65 00 64 00 20 |.C.h.a.n .g.e.d. |
00e0 00 6c 00 61 00 6e 00 67-00 75 00 61 00 67 00 65 |.l.a.n.g .u.a.g.e|
00f0 00 20 00 73 00 65 00 74-00 74 00 69 00 6e 00 67 |. .s.e.t .t.i.n.g|
0100 00 20 00 74 00 6f 00 20-00 75 00 73 00 5f 00 65 |. .t.o. .u.s._.e|
0110 00 6e 00 67 00 6c 00 69-00 73 00 68 00 2e 00 15 |.n.g.l.i .s.h....|
0120 4d 00 4c 00 56 00 56 00-52 00 44 00 44 00 42 00 |M.L.V.V. R.D.D.B.|
0130 53 00 31 00 31 00 5c 00-57 00 46 00 53 00 4c 00 |S.1.1.\. W.F.S.L.|
0140 52 00 5f 00 44 00 45 00-56 00 00 01 00 ad 36 00 |R._.D.E. V.....6.|
0150 01 71 00 00 01 16 4d 00-69 00 63 00 72 00 6f 00 |.q....M. i.c.r.o.|
0160 73 00 6f 00 66 00 74 00-20 00 53 00 51 00 4c 00 |s.o.f.t. .S.Q.L.|
0170 20 00 53 00 65 00 72 00-76 00 65 00 72 00 00 00 | .S.e.r. v.e.r...|
0180 00 00 0a 32 06 40 e3 13-00 04 04 34 00 30 00 39 |...2.@.. ...4.0.9|
0190 00 36 00 04 34 00 30 00-39 00 36 00 fd 00 00 00 |.6..4.0. 9.6.....|
01a0 00 00 00 00 00 - |.....|
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 00 00 00 00 00 - |.....|
iconv.c:985:setting server single-byte charset to "CP1252"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
token.c:2292:tds->collation now
0000 09 04 d0 00 34 - |....4|
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got ad(LOGINACK)
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got fd(DONE)
token.c:108:tds_process_default_tokens() marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
token.c:2232: rows_affected = 0
token.c:393:leaving tds_process_login_tokens() returning 1
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 19 bytes of "set textsize 64512 "
write.c:164:tds_put_string wrote 38 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779: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 36 00 34 00 35 00-31 00 32 00 20 00 | .6.4.5. 1.2. .|
token.c:495:tds_process_tokens(0xa497c08, 0xbfdd2ac8, 0xbfdd2ac4, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 38 01 00- |.....8..|
net.c:671:Received packet
0000 fd 00 00 be 00 00 00 00-00 |........ .|
token.c:510:processing result tokens. marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xa497c08, 0xbfdd2ac8, 0xbfdd2ac4, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
ct.c:623:leaving ct_connect() returning 1
ct.c:641:ct_cmd_alloc()
ct.c:215:setting command state from IDLE to IDLE
ct.c:660:ct_cmd_alloc() : allocating command list to head
ct.c:682:ct_command()
ct.c:215:setting command state from IDLE to IDLE
ct.c:215:setting command state from IDLE to IDLE
ct.c:215:setting command state from IDLE to READY
ct.c:844:ct_send() command_type = 148
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 18 bytes of "USE SE3100_RADDATA"
write.c:164:tds_put_string wrote 36 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 2c 00 00 01 00-55 00 53 00 45 00 20 00 |...,.... U.S.E. .|
0010 53 00 45 00 33 00 31 00-30 00 30 00 5f 00 52 00 |S.E.3.1. 0.0._.R.|
0020 41 00 44 00 44 00 41 00-54 00 41 00 |A.D.D.A. T.A.|
ct.c:215:setting command state from READY to SENT
ct.c:965:ct_send() succeeded
ct.c:1100:ct_results()
token.c:495:tds_process_tokens(0xa497c08, 0xbfdd2f08, 0xbfdd2f04, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 dd 00 38 01 00- |.....8..|
net.c:671:Received packet
0000 e3 2b 00 01 0e 53 00 45-00 33 00 31 00 30 00 30 |.+...S.E .3.1.0.0|
0010 00 5f 00 52 00 41 00 44-00 44 00 41 00 54 00 41 |._.R.A.D .D.A.T.A|
0020 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 90 |..m.a.s. t.e.r...|
0030 00 45 16 00 00 01 00 2d-00 43 00 68 00 61 00 6e |.E.....- .C.h.a.n|
0040 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d. .d.a.t.a|
0050 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0060 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0070 00 27 00 53 00 45 00 33-00 31 00 30 00 30 00 5f |.'.S.E.3 .1.0.0._|
0080 00 52 00 41 00 44 00 44-00 41 00 54 00 41 00 27 |.R.A.D.D .A.T.A.'|
0090 00 2e 00 15 4d 00 4c 00-56 00 56 00 52 00 44 00 |....M.L. V.V.R.D.|
00a0 44 00 42 00 53 00 31 00-31 00 5c 00 57 00 46 00 |D.B.S.1. 1.\.W.F.|
00b0 53 00 4c 00 52 00 5f 00-44 00 45 00 56 00 00 01 |S.L.R._. D.E.V...|
00c0 00 e3 08 00 07 05 09 04-d0 00 34 00 fd 00 00 e2 |........ ..4.....|
00d0 00 00 00 00 00 - |.....|
token.c:510:processing result tokens. marker is e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:510:processing result tokens. marker is ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:510:processing result tokens. marker is e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 09 04 d0 00 34 - |....4|
iconv.c:985:setting server single-byte charset to "CP1252"
token.c:2292:tds->collation now
0000 09 04 d0 00 34 - |....4|
token.c:510:processing result tokens. marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
ct.c:1157:ct_results() process_result_tokens returned 1 (type 4052)
ct.c:1262:ct_results() results state = 0
ct.c:1263:ct_results() command type = 148
ct.c:1264:ct_results() dynamic cmd = 0
ct.c:1100:ct_results()
ct.c:682:ct_command()
ct.c:215:setting command state from SENT to IDLE
ct.c:215:setting command state from IDLE to IDLE
ct.c:766:ct_command() added rpcname "get_users_info"
ct.c:215:setting command state from IDLE to READY
ct.c:3358:ct_param()
ct.c:3359:ct_param() data addr = 0xbfdd29fe data length = 6
ct.c:4324: _ct_fill_param() status = 256
ct.c:2003:_ct_get_server_type(0)
ct.c:3390: ct_param() added rpc parameter @user_init
ct.c:844:ct_send() command_type = 149
ct.c:4239:paraminfoalloc: status = 256, maxlen 0
ct.c:4240:paraminfoalloc: name = @user_init, varint size 2 column_type 47
size 6, 6 column_cur_size 6 column_output = 0
ct.c:4079:paramrowalloc, size = 6, data = 0xa4cb450, row_size = 0
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
query.c:1292:tds_put_data_info putting param_name
query.c:1326:tds_put_data_info putting status
query.c:1420:tds_put_data: colsize = 6
query.c:1449:tds_put_data: not null param varint_size = 2
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 03 01 00 4e 00 00 01 00-0e 00 67 00 65 00 74 00 |...N.... ..g.e.t.|
0010 5f 00 75 00 73 00 65 00-72 00 73 00 5f 00 69 00 |_.u.s.e. r.s._.i.|
0020 6e 00 66 00 6f 00 00 00-0a 40 00 75 00 73 00 65 |n.f.o... .@.u.s.e|
0030 00 72 00 5f 00 69 00 6e-00 69 00 74 00 00 af 06 |.r._.i.n .i.t....|
0040 00 09 04 d0 00 34 06 00-06 00 52 41 44 52 |.....4.. ..RADR|
ct.c:215:setting command state from READY to SENT
ct.c:1100:ct_results()
token.c:495:tds_process_tokens(0xa497c08, 0xbfdd2ca8, 0xbfdd2ca4, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 41 00 38 01 00- |...A.8..|
net.c:671:Received packet
0000 81 01 00 00 00 08 00 af-0c 00 09 04 d0 00 34 09 |........ ......4.|
0010 75 00 73 00 65 00 72 00-5f 00 6e 00 61 00 6d 00 |u.s.e.r. _.n.a.m.|
0020 65 00 ff 11 00 c1 00 00-00 00 00 79 00 00 00 00 |e....... ...y....|
0030 fe 00 00 e0 00 00 00 00-00 |........ .|
token.c:510:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (1 column) to tds->res_info
token.c:1555:setting up column 0
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 12
Client charset: ISO-8859-1
Client column_size: 12
token.c:1490:tds7_get_data_info:
colname = user_name (9 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 12 (12 on server)
util.c:162:Changed query state from READING to PENDING
ct.c:1157:ct_results() process_result_tokens returned 1 (type 4049)
token.c:495:tds_process_tokens(0xa497c08, 0xbfdd2ca8, 0xbfdd2ca4, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2232: rows_affected = 0
util.c:162:Changed query state from READING to PENDING
ct.c:1157:ct_results() process_result_tokens returned 1 (type 4054)
ct.c:2300:ct_describe()
ct.c:1890:_ct_get_client_type(type 47, user 0, size 12)
ct.c:2321:ct_describe() datafmt->datatype = 0 server type 47
ct.c:1434:ct_bind() datafmt count = 1 column_number = 1
ct.c:1490:ct_fetch()
ct.c:682:ct_command()
ct.c:215:setting command state from SENT to IDLE
ct.c:215:setting command state from IDLE to IDLE
Dump from Isql
log.c:190:Starting log file for FreeTDS 0.82
on 2010-09-28 12:57:27 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character
set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:836:tds7_get_instance_port(192.168.142.28, WFSLR_DEV)
net.c:936:instance info
0000 05 5d 00 53 65 72 76 65-72 4e 61 6d 65 3b 4d 4c |.].Serve rName;ML|
0010 56 56 52 44 44 42 53 31-31 3b 49 6e 73 74 61 6e |VVRDDBS1 1;Instan|
0020 63 65 4e 61 6d 65 3b 57-46 53 4c 52 5f 44 45 56 |ceName;W FSLR_DEV|
0030 3b 49 73 43 6c 75 73 74-65 72 65 64 3b 4e 6f 3b |;IsClust ered;No;|
0040 56 65 72 73 69 6f 6e 3b-31 30 2e 35 30 2e 31 36 |Version; 10.50.16|
0050 30 30 2e 31 3b 74 63 70-3b 34 39 33 30 33 3b 3b |00.1;tcp ;49303;;|
net.c:974:instance port is 49303
net.c:210:Connecting to 192.168.142.28 port 49303 (TDS version 8.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:303:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
net.c:592:Received header
0000 04 01 01 cd 00 3a 01 00- |...Í.:..|
net.c:671:Received packet
0000 e3 2b 00 01 0e 53 00 45-00 33 00 31 00 30 00 30 |ã+...S.E .3.1.0.0|
0010 00 5f 00 52 00 41 00 44-00 44 00 41 00 54 00 41 |._.R.A.D .D.A.T.A|
0020 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 90 |..m.a.s. t.e.r.«.|
0030 00 45 16 00 00 02 00 2d-00 43 00 68 00 61 00 6e |.E.....- .C.h.a.n|
0040 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d. .d.a.t.a|
0050 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0060 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0070 00 27 00 53 00 45 00 33-00 31 00 30 00 30 00 5f |.'.S.E.3 .1.0.0._|
0080 00 52 00 41 00 44 00 44-00 41 00 54 00 41 00 27 |.R.A.D.D .A.T.A.'|
0090 00 2e 00 15 4d 00 4c 00-56 00 56 00 52 00 44 00 |....M.L. V.V.R.D.|
00a0 44 00 42 00 53 00 31 00-31 00 5c 00 57 00 46 00 |D.B.S.1. 1.\.W.F.|
00b0 53 00 4c 00 52 00 5f 00-44 00 45 00 56 00 00 01 |S.L.R._. D.E.V...|
00c0 00 e3 08 00 07 05 09 04-d0 00 34 00 e3 17 00 02 |.ã...... Ð.4.ã...|
00d0 0a 75 00 73 00 5f 00 65-00 6e 00 67 00 6c 00 69 |.u.s._.e .n.g.l.i|
00e0 00 73 00 68 00 00 ab 84-00 47 16 00 00 01 00 27 |.s.h..«. .G.....'|
00f0 00 43 00 68 00 61 00 6e-00 67 00 65 00 64 00 20 |.C.h.a.n .g.e.d. |
0100 00 6c 00 61 00 6e 00 67-00 75 00 61 00 67 00 65 |.l.a.n.g .u.a.g.e|
0110 00 20 00 73 00 65 00 74-00 74 00 69 00 6e 00 67 |. .s.e.t .t.i.n.g|
0120 00 20 00 74 00 6f 00 20-00 75 00 73 00 5f 00 65 |. .t.o. .u.s._.e|
0130 00 6e 00 67 00 6c 00 69-00 73 00 68 00 2e 00 15 |.n.g.l.i .s.h....|
0140 4d 00 4c 00 56 00 56 00-52 00 44 00 44 00 42 00 |M.L.V.V. R.D.D.B.|
0150 53 00 31 00 31 00 5c 00-57 00 46 00 53 00 4c 00 |S.1.1.\. W.F.S.L.|
0160 52 00 5f 00 44 00 45 00-56 00 00 01 00 ad 36 00 |R._.D.E. V....6.|
0170 01 71 00 00 01 16 4d 00-69 00 63 00 72 00 6f 00 |.q....M. i.c.r.o.|
0180 73 00 6f 00 66 00 74 00-20 00 53 00 51 00 4c 00 |s.o.f.t. .S.Q.L.|
0190 20 00 53 00 65 00 72 00-76 00 65 00 72 00 00 00 | .S.e.r. v.e.r...|
01a0 00 00 0a 32 06 40 e3 13-00 04 04 34 00 30 00 39 |...2.@ã. ...4.0.9|
01b0 00 36 00 04 34 00 30 00-39 00 36 00 fd 00 00 00 |.6..4.0. 9.6.ý...|
01c0 00 00 00 00 00 - |.....|
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 00 00 00 00 00 - |.....|
iconv.c:985:setting server single-byte charset to "CP1252"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
token.c:2292:tds->collation now
0000 09 04 d0 00 34 - |..Ð.4|
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got ad(LOGINACK)
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got fd(DONE)
token.c:108:tds_process_default_tokens() marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
token.c:2232: rows_affected = 0
token.c:393:leaving tds_process_login_tokens() returning 1
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 19 bytes of "set textsize 64512 "
write.c:164:tds_put_string wrote 38 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779: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 36 00 34 00 35 00-31 00 32 00 20 00 | .6.4.5. 1.2. .|
token.c:495:tds_process_tokens(0x99a4a28, 0xbfc2b288, 0xbfc2b284, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 3a 01 00- |.....:..|
net.c:671:Received packet
0000 fd 00 00 be 00 00 00 00-00 |ý..¾.... .|
token.c:510:processing result tokens. marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x99a4a28, 0xbfc2b288, 0xbfc2b284, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 24 bytes of "get_users_info 'RADRAD'
"
write.c:164:tds_put_string wrote 48 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 38 00 00 01 00-67 00 65 00 74 00 5f 00 |...8.... g.e.t._.|
0010 75 00 73 00 65 00 72 00-73 00 5f 00 69 00 6e 00 |u.s.e.r. s._.i.n.|
0020 66 00 6f 00 20 00 27 00-52 00 41 00 44 00 52 00 |f.o. .'. R.A.D.R.|
0030 41 00 44 00 27 00 0a 00- |A.D.'...|
token.c:495:tds_process_tokens(0x99a4a28, 0xbfc2b538, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 50 00 3a 01 00- |...P.:..|
net.c:671:Received packet
0000 81 01 00 00 00 08 00 af-0c 00 09 04 d0 00 34 09 |.......¯ ....Ð.4.|
0010 75 00 73 00 65 00 72 00-5f 00 6e 00 61 00 6d 00 |u.s.e.r. _.n.a.m.|
0020 65 00 d1 0c 00 52 41 44-55 53 45 52 5f 54 45 4d |e.Ñ..RAD USER_TEM|
0030 50 ff 11 00 c1 00 01 00-00 00 79 00 00 00 00 fe |Pÿ..Á... ..y....þ|
0040 00 00 e0 00 00 00 00 00- |..à.....|
token.c:510:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (1 column) to tds->res_info
token.c:1555:setting up column 0
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 12
Client charset: ISO-8859-1
Client column_size: 12
token.c:1490:tds7_get_data_info:
colname = user_name (9 bytes)
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 12 (12 on server)
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x99a4a28, 0xbfc2b538, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is d1(ROW)
token.c:621:tds_process_tokens::SET_RETURN stopping on current token
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x99a4a28, 0xbfc2b538, (nil), 0x1508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is d1(ROW)
token.c:2166:tds_process_row(): reading column 0
token.c:1915:tds_get_data: type 47, varint size 2
token.c:1975:tds_get_data(): wire column size is 12
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x99a4a28, 0xbfc2b538, (nil), 0x1508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2232: rows_affected = 1
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x99a4a28, 0xbfc2b538, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:645:tds_process_tokens: return status is 0
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x99a4a28, 0xbfc2b538, (nil), 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x99a4a28, 0xbfc2b538, (nil), 0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
----------------------------------------------------------------------------
This message and any included attachments are from Siemens Medical Solutions
and are intended only for the addressee(s).
The information contained herein may include trade secrets or privileged or
otherwise confidential information. Unauthorized review, forwarding,
printing,
copying, distributing, or using such information is strictly prohibited and
may
be unlawful. If you received this message in error, or have reason to believe
you are not authorized to receive it, please promptly delete this message and
notify the sender by e-mail with a copy to Central.SecurityOffice AT siemens.com
Thank you
-
[freetds] Unable to query MSSQL server using freetds,
Belden, Alvin (H USA), 09/28/2010
- Re: [freetds] Unable to query MSSQL server using freetds, Frediano Ziglio, 09/30/2010
Archive powered by MHonArc 2.6.24.