FreeTDS Development Group

[Alex Lake <alex AT digitalmail.com>]

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
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds