FreeTDS Development Group

[Alex Lake <alex AT digitalmail.com>]

Are there any FreeTDS expert "guns for hire" out there who might be 
persuaded to help with this quickly in exchange for some cash? ;-)
> 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)
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds