Skip to Content.
Sympa Menu

freetds - Re: [freetds] Nearly there connecting to ASA8 - but need final bit of help

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Alex Lake <alex AT digitalmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Nearly there connecting to ASA8 - but need final bit of help
  • Date: Mon, 19 Dec 2011 10:11:58 +0000

Thanks for the implied offer of help! ;-)

Here's a trace for the statement "select 42;" as issued by isql.

I changed the TDS version to 5.0 (although I note that the password's still in there, but it doesn't matter, as this is only a test server)

I note the suspicious "unknown" bit, but not sure what to do about it. Like I say, if I say "help", then it seems able to connect and query the database.

Rgds,
Alex

log.c:190:Starting log file for FreeTDS 0.82
on 2011-12-19 10:06: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 "UTF-8" character set
iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
net.c:210:Connecting to 192.168.1.90 port 2638 (TDS version 5.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
net.c:779:Sending packet
0000 02 00 02 00 00 00 00 00-41 4a 4c 54 65 73 74 30 |........ AJLTest0|
0010 36 4a 75 6e 00 00 00 00-00 00 00 00 00 00 00 00 |6Jun.... ........|
0020 00 00 00 00 00 00 0c 64-62 61 00 00 00 00 00 00 |.......d ba......|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 03 73 71-6c 00 00 00 00 00 00 00 |......sq l.......|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 03 33 37 38-37 36 00 00 00 00 00 00 |.....378 76......|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 00 00 |........ ........|
0090 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 00 62 68 32 5f 6d-37 30 30 33 00 00 00 00 |...bh2_m 7003....|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 09 00 03 73 71 6c 00-00 00 00 00 00 00 00 00 |....sql. ........|
00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01d0 00 05 05 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01e0 00 05 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|

net.c:779:Sending packet
0000 02 01 00 61 00 00 00 00-00 00 00 00 00 00 0a 00 |...a.... ........|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 55 54 46 |........ .....UTF|
0020 2d 38 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |-8...... ........|
0030 00 00 00 00 00 00 00 00-00 00 00 05 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00-e2 16 00 01 09 00 08 0e |........ ........|
0050 6d 7f ff ff ff fe 02 09-00 00 00 00 02 68 00 00 |m....... .....h..|
0060 00 - |.|

token.c:312:tds_process_login_tokens()
net.c:592:Received header
0000 04 01 00 5c 00 00 00 00- |...\....|

net.c:671:Received packet
0000 e3 0a 00 03 07 75 6e 6b-6e 6f 77 6e 00 ad 22 00 |.....unk nown..".|
0010 05 05 00 00 00 18 41 64-61 70 74 69 76 65 20 53 |......Ad aptive S|
0020 65 72 76 65 72 20 41 6e-79 77 68 65 72 65 08 00 |erver An ywhere..|
0030 00 00 e2 16 00 01 09 00-00 0e 61 01 ff ff fe e6 |........ ..a.....|
0040 02 09 00 00 07 fe e2 68-00 00 0a fd 00 00 01 00 |.......h ........|
0050 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:2356:server indicated charset change to "unknown"
iconv.c:980:tds_srv_charset_changed: what is charset "unknown"?
token.c:316:looking for login token, got ad(LOGINACK)
token.c:316:looking for login token, got e2(CAPABILITY)
token.c:108:tds_process_default_tokens() marker is e2(CAPABILITY)
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
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 0f 01 00 21 00 00 00 00-21 14 00 00 00 00 73 65 |...!.... !.....se|
0010 74 20 74 65 78 74 73 69-7a 65 20 36 34 35 31 32 |t textsi ze 64512|
0020 20 - | |

token.c:495:tds_process_tokens(0x8656948, 0xbfe2087c, 0xbfe20878, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 00 00 00- |........|

net.c:671:Received packet
0000 fd 00 00 01 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(0x8656948, 0xbfe2087c, 0xbfe20878, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:4672:SQLGetFunctions: fFunction is 1
odbc.c:4672:SQLGetFunctions: fFunction is 2
odbc.c:4672:SQLGetFunctions: fFunction is 1001
odbc.c:4672:SQLGetFunctions: fFunction is 3
odbc.c:4672:SQLGetFunctions: fFunction is 4
odbc.c:4672:SQLGetFunctions: fFunction is 1002
odbc.c:4672:SQLGetFunctions: fFunction is 72
odbc.c:4672:SQLGetFunctions: fFunction is 5
odbc.c:4672:SQLGetFunctions: fFunction is 1003
odbc.c:4672:SQLGetFunctions: fFunction is 6
odbc.c:4672:SQLGetFunctions: fFunction is 6
odbc.c:4672:SQLGetFunctions: fFunction is 56
odbc.c:4672:SQLGetFunctions: fFunction is 40
odbc.c:4672:SQLGetFunctions: fFunction is 7
odbc.c:4672:SQLGetFunctions: fFunction is 1004
odbc.c:4672:SQLGetFunctions: fFunction is 8
odbc.c:4672:SQLGetFunctions: fFunction is 9
odbc.c:4672:SQLGetFunctions: fFunction is 41
odbc.c:4672:SQLGetFunctions: fFunction is 1005
odbc.c:4672:SQLGetFunctions: fFunction is 10
odbc.c:4672:SQLGetFunctions: fFunction is 11
odbc.c:4672:SQLGetFunctions: fFunction is 12
odbc.c:4672:SQLGetFunctions: fFunction is 59
odbc.c:4672:SQLGetFunctions: fFunction is 13
odbc.c:4672:SQLGetFunctions: fFunction is 1021
odbc.c:4672:SQLGetFunctions: fFunction is 60
odbc.c:4672:SQLGetFunctions: fFunction is 15
odbc.c:4672:SQLGetFunctions: fFunction is 1006
odbc.c:4672:SQLGetFunctions: fFunction is 16
odbc.c:4672:SQLGetFunctions: fFunction is 14
odbc.c:4672:SQLGetFunctions: fFunction is 1007
odbc.c:4672:SQLGetFunctions: fFunction is 42
odbc.c:4672:SQLGetFunctions: fFunction is 17
odbc.c:4672:SQLGetFunctions: fFunction is 43
odbc.c:4672:SQLGetFunctions: fFunction is 1008
odbc.c:4672:SQLGetFunctions: fFunction is 1009
odbc.c:4672:SQLGetFunctions: fFunction is 1010
odbc.c:4672:SQLGetFunctions: fFunction is 1012
odbc.c:4672:SQLGetFunctions: fFunction is 44
odbc.c:4672:SQLGetFunctions: fFunction is 45
odbc.c:4672:SQLGetFunctions: fFunction is 1014
odbc.c:4672:SQLGetFunctions: fFunction is 46
odbc.c:4672:SQLGetFunctions: fFunction is 47
odbc.c:4672:SQLGetFunctions: fFunction is 61
odbc.c:4672:SQLGetFunctions: fFunction is 62
odbc.c:4672:SQLGetFunctions: fFunction is 63
odbc.c:4672:SQLGetFunctions: fFunction is 18
odbc.c:4672:SQLGetFunctions: fFunction is 48
odbc.c:4672:SQLGetFunctions: fFunction is 64
odbc.c:4672:SQLGetFunctions: fFunction is 19
odbc.c:4672:SQLGetFunctions: fFunction is 65
odbc.c:4672:SQLGetFunctions: fFunction is 66
odbc.c:4672:SQLGetFunctions: fFunction is 67
odbc.c:4672:SQLGetFunctions: fFunction is 49
odbc.c:4672:SQLGetFunctions: fFunction is 20
odbc.c:4672:SQLGetFunctions: fFunction is 1016
odbc.c:4672:SQLGetFunctions: fFunction is 50
odbc.c:4672:SQLGetFunctions: fFunction is 21
odbc.c:4672:SQLGetFunctions: fFunction is 1017
odbc.c:4672:SQLGetFunctions: fFunction is 1018
odbc.c:4672:SQLGetFunctions: fFunction is 1019
odbc.c:4672:SQLGetFunctions: fFunction is 22
odbc.c:4672:SQLGetFunctions: fFunction is 68
odbc.c:4672:SQLGetFunctions: fFunction is 69
odbc.c:4672:SQLGetFunctions: fFunction is 1020
odbc.c:4672:SQLGetFunctions: fFunction is 51
odbc.c:4672:SQLGetFunctions: fFunction is 52
odbc.c:4672:SQLGetFunctions: fFunction is 53
odbc.c:4672:SQLGetFunctions: fFunction is 70
odbc.c:4672:SQLGetFunctions: fFunction is 54
odbc.c:4672:SQLGetFunctions: fFunction is 23
odbc.c:4672:SQLGetFunctions: fFunction is 1011
odbc.c:5587:SQLGetInfo(0x8656590, 77, 0xbfe20bdc, 20, (nil))
odbc.c:4841:_SQLGetInfo(0x8656590, 77, 0xbfe20bdc, 20, (nil)
odbc.c:5587:SQLGetInfo(0x8656590, 10000, 0xbfe20bdc, 5, (nil))
odbc.c:4841:_SQLGetInfo(0x8656590, 10000, 0xbfe20bdc, 5, (nil)
odbc.c:1504:SQLAllocStmt(0x8656590, 0x867f190)
odbc.c:1403:_SQLAllocStmt(0x8656590, 0x867f190)
odbc.c:4079:SQLGetStmtAttr(0x86719f8, 10010, 0xbfe21c78, 4, (nil))
odbc.c:3917:_SQLGetStmtAttr(0x86719f8, 10010, 0xbfe21c78, 4, (nil))
odbc.c:4079:SQLGetStmtAttr(0x86719f8, 10011, 0xbfe21c78, 4, (nil))
odbc.c:3917:_SQLGetStmtAttr(0x86719f8, 10011, 0xbfe21c78, 4, (nil))
odbc.c:4079:SQLGetStmtAttr(0x86719f8, 10012, 0xbfe21c78, 4, (nil))
odbc.c:3917:_SQLGetStmtAttr(0x86719f8, 10012, 0xbfe21c78, 4, (nil))
odbc.c:4079:SQLGetStmtAttr(0x86719f8, 10013, 0xbfe21c78, 4, (nil))
odbc.c:3917:_SQLGetStmtAttr(0x86719f8, 10013, 0xbfe21c78, 4, (nil))
odbc.c:4124:SQLPrepare(0x86719f8, select 42;, -3)
odbc.c:4188:Creating prepared statement
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 0f 01 00 3e 00 00 00 00-e7 33 00 01 00 0a 63 6a |...>.... .3....cj|
0010 66 34 38 33 36 30 30 30-24 00 63 72 65 61 74 65 |f4836000 $.create|
0020 20 70 72 6f 63 20 63 6a-66 34 38 33 36 30 30 30 | proc cj f4836000|
0030 20 61 73 20 73 65 6c 65-63 74 20 34 32 3b | as sele ct 42;|

token.c:495:tds_process_tokens(0x8656948, 0xbfe21bdc, 0xbfe21bd8, 0x104)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 21 00 00 00 00- |...!....|

net.c:671:Received packet
0000 e7 0d 00 20 00 0a 63 6a-66 34 38 33 36 30 30 30 |... ..cj f4836000|
0010 fd 00 00 01 00 00 00 00-00 |........ .|

token.c:510:processing result tokens. marker is e7(TDS5_DYNAMIC)
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(0x8656948, 0xbfe21bdc, 0xbfe21bd8, 0x104)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3237:SQLExecute(0x86719f8)
odbc.c:2965:_SQLExecute(0x86719f8)
odbc.c:2970:_SQLExecute() starting with state 0
odbc.c:3078:End prepare, execute
query.c:1631:tds_submit_execute()
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 0f 01 00 1a 00 00 00 00-e7 0f 00 02 00 0a 63 6a |........ ......cj|
0010 66 34 38 33 36 30 30 30-00 00 |f4836000 ..|

token.c:495:tds_process_tokens(0x8656948, 0xbfe21b6c, 0xbfe21b68, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 21 00 00 00 00- |...!....|

net.c:671:Received packet
0000 e7 0d 00 20 00 0a 63 6a-66 34 38 33 36 30 30 30 |... ..cj f4836000|
0010 fd 00 00 01 00 00 00 00-00 |........ .|

token.c:510:processing result tokens. marker is e7(TDS5_DYNAMIC)
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
odbc.c:3269:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3270: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3313:odbc_process_tokens: processed TDS_DONE_RESULT
token.c:495:tds_process_tokens(0x8656948, 0xbfe21b6c, 0xbfe21b68, 0x6914)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3269:odbc_process_tokens: tds_process_tokens returned 2
odbc.c:3270: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3119:_SQLExecute: odbc_process_tokens returned result_type 4046
odbc.c:4100:SQLNumResultCols(0x86719f8, 0xbfe21d6e)
odbc.c:4256:_SQLRowCount(0x86719f8, 0xbfe21d2c)
odbc.c:4275:SQLRowCount returns 0, row count -1
odbc.c:588:SQLMoreResults(0x86719f8)
odbc.c:3680:SQLFreeHandle(3, 0x0x86719f8)
odbc.c:3769:_SQLFreeStmt(0x86719f8, 1, 0)
query.c:1768:tds_submit_unprepare() cjf4836000
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 0f 01 00 1a 00 00 00 00-e7 0f 00 04 00 0a 63 6a |........ ......cj|
0010 66 34 38 33 36 30 30 30-00 00 |f4836000 ..|

token.c:495:tds_process_tokens(0x8656948, 0xbfe21afc, 0xbfe21af8, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 21 00 00 00 00- |...!....|

net.c:671:Received packet
0000 e7 0d 00 20 00 0a 63 6a-66 34 38 33 36 30 30 30 |... ..cj f4836000|
0010 fd 00 00 01 00 00 00 00-00 |........ .|

token.c:510:processing result tokens. marker is e7(TDS5_DYNAMIC)
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(0x8656948, 0xbfe21afc, 0xbfe21af8, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:2005:SQLDisconnect(0x8656590)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
odbc.c:3734:SQLFreeConnect(0x8656590)
odbc.c:3706:_SQLFreeConnect(0x8656590)
odbc.c:3757:SQLFreeEnv(0x8655570)
odbc.c:3744:_SQLFreeEnv(0x8655570)





Archive powered by MHonArc 2.6.24.

Top of Page