[freetds] Problem with tsql

dmarrer at bci.cl dmarrer at bci.cl
Tue Jun 2 14:10:59 EDT 2009


Hi James:

Thank you for your answer.

Here is the TDSDUMP with tsql:

log.c:190:Starting log file for FreeTDS 0.82
        on 2009-06-02 12:33:38 with debug flags 0x4fff.
iconv.c:78:Using trivial iconv
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: (null)
iconv.c:363:iconv to convert client-side data to the "roman8" character 
set
iconv.c:477:tds_iconv_info_init: use memcpy to convert "ROMAN8"->"UCS-2LE"
net.c:210:Connecting to 192.168.1.3 port 1433 (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()
util.c:334:tdserror(800000010000c540, 80000001000117c8, 20017, 0)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
util.c:162:Changed query state from IDLE to DEAD
token.c:316:looking for login token, got  0()
token.c:108:tds_process_default_tokens() marker is 0()
token.c:111:leaving tds_process_default_tokens() connection dead
util.c:334:tdserror(800000010000c540, 80000001000117c8, 20002, 0)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
mem.c:563:tds_free_all_results()

---------------------------------------------------------------------------------------------------------------------------------------

And this is the TDSDUMP with fisql

log.c:190:Starting log file for FreeTDS 0.82
        on 2009-06-02 12:34:43 with debug flags 0x4fff.
iconv.c:78:Using trivial iconv
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: (null)
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:210:Connecting to 161.131.141.197 port 1433 (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 91 00 3c 01 00-                        |.....<..|

net.c:671:Received packet
0000 e3 1d 00 01 07 4d 00 45-00 54 00 41 00 34 00 51 |.....M.E .T.A.4.Q|
0010 00 41 00 06 6d 00 61 00-73 00 74 00 65 00 72 00 |.A..m.a. s.t.e.r.|
0020 ab 72 00 45 16 00 00 02-00 26 00 43 00 68 00 61 |.r.E.... .&.C.h.a|
0030 00 6e 00 67 00 65 00 64-00 20 00 64 00 61 00 74 |.n.g.e.d . .d.a.t|
0040 00 61 00 62 00 61 00 73-00 65 00 20 00 63 00 6f |.a.b.a.s .e. .c.o|
0050 00 6e 00 74 00 65 00 78-00 74 00 20 00 74 00 6f |.n.t.e.x .t. .t.o|
0060 00 20 00 27 00 4d 00 45-00 54 00 41 00 34 00 51 |. .'.M.E .T.A.4.Q|
0070 00 41 00 27 00 2e 00 0d-53 00 52 00 56 00 2d 00 |.A.'.... S.R.V.-.|
0080 57 00 49 00 4e 00 50 00-45 00 50 00 44 00 45 00 |W.I.N.D. O.W.S.X.|
0090 53 00 00 01 00 e3 08 00-07 05 09 04 c0 00 33 00 |P....... ......3.|
00a0 e3 17 00 02 0a 75 00 73-00 5f 00 65 00 6e 00 67 |.....u.s ._.e.n.g|
00b0 00 6c 00 69 00 73 00 68-00 00 ab 74 00 47 16 00 |.l.i.s.h ...t.G..|
00c0 00 01 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|
00d0 00 64 00 20 00 6c 00 61-00 6e 00 67 00 75 00 61 |.d. .l.a .n.g.u.a|
00e0 00 67 00 65 00 20 00 73-00 65 00 74 00 74 00 69 |.g.e. .s .e.t.t.i|
00f0 00 6e 00 67 00 20 00 74-00 6f 00 20 00 75 00 73 |.n.g. .t .o. .u.s|
0100 00 5f 00 65 00 6e 00 67-00 6c 00 69 00 73 00 68 |._.e.n.g .l.i.s.h|
0110 00 2e 00 0d 53 00 52 00-56 00 2d 00 57 00 49 00 |....S.R. V.-.W.I.|
0120 4e 00 50 00 45 00 50 00-44 00 45 00 53 00 00 01 |N.D.O.W. S.X.P...|
0130 00 ad 36 00 01 71 00 00-01 16 4d 00 69 00 63 00 |..6..q.. ..M.i.c.|
0140 72 00 6f 00 73 00 6f 00-66 00 74 00 20 00 53 00 |r.o.s.o. f.t. .S.|
0150 51 00 4c 00 20 00 53 00-65 00 72 00 76 00 65 00 |Q.L. .S. e.r.v.e.|
0160 72 00 00 00 00 00 09 00-0c 01 e3 13 00 04 04 34 |r....... .......4|
0170 00 30 00 39 00 36 00 04-34 00 30 00 39 00 36 00 |.0.9.6.. 4.0.9.6.|
0180 fd 00 00 00 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)
dblib.c:325:db_env_chg(8000000100010e70, 1, master, META4QA)
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
dbutil.c:86:_dblib_handle_info_message(8000000100010178, 8000000100010e70, 
800003fff0ff18a8)
dbutil.c:87:msgno 5701: "Changed database context to 'META4QA'."
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:477:tds_iconv_info_init: use memcpy to convert 
"ISO-8859-1"->"CP1252"
token.c:2292:tds->collation now
0000 09 04 c0 00 33         -                        |....3|

token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(8000000100010e70, 2, , us_english)
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
dbutil.c:86:_dblib_handle_info_message(8000000100010178, 8000000100010e70, 
800003fff0ff18a8)
dbutil.c:87:msgno 5703: "Changed language setting to us_english."
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)
dblib.c:325:db_env_chg(8000000100010e70, 4, 4096, 4096)
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(8000000100010e70, 800003fff0ff16c8, 
800003fff0ff16cc, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 3c 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(8000000100010e70, 800003fff0ff16c8, 
800003fff0ff16cc, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:237:dblib_add_connection(800003fff0fea630, 8000000100010e70)
dblib.c:4208:dbsetopt(8000000100010350, 23,
, 1)
dblib.c:4208:dbsetopt(8000000100010350, 21,  , 1)
dblib.c:3093:dbcancel(8000000100010350)
query.c:1934:tds_send_cancel: not in_cancel and idle
dblib.c:1442:dbexit(void)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
dblib.c:1372:dbclose(8000000100010350)
dblib.c:5727:dbfreebuf(8000000100010350)
dblib.c:303:dblib_release_tds_ctx(2)


What's wrong?

Best regards

Daymel




"James K. Lowden" <jklowden at freetds.org>

Enviado por: freetds-bounces at lists.ibiblio.org
28-05-2009 22:13
Por favor, responda a
FreeTDS Development Group <freetds at lists.ibiblio.org>


Para
FreeTDS Development Group <freetds at lists.ibiblio.org>
cc

Asunto
Re: [freetds] Problem with tsql






dmarrer at bci.cl wrote:
> 
> I installed freetds on HPUX. I configured freetds.conf file but when I
> try  tsql, I receive an error. In the freetds.log file I see the
> following:
> 
> tdserror: client library returned TDS_INT_CANCEL(2)
> 
> With fisql, I can connect properly.

Please post a TDSDUMP log of the failed session.  Something is amiss. 

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


z
 EN BCI PROTEGEMOS EL MEDIO AMBIENTE, IMPRIME SÓLO LO NECESARIO




More information about the FreeTDS mailing list