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

Alex Lake <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]> 
OK, well I've discovered that Sybase do their own PHP module for 
SQLAnywhere connections. It doesn't use PDO, which in some ways is a 
shame, but I'll take that, thanks very much!
> 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
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
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.