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: Tue, 20 Dec 2011 15:33:19 +0000

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






Archive powered by MHonArc 2.6.24.

Top of Page