FreeTDS Development Group

["Ben Vaughn" <bvaughn AT BlackbirdTech.com>]

(This is with CVS from an hour ago...)
It looks like Sybase ASA dislikes TDS.  It seems to be forcing a
Database to be specified on login or at least a server name (which is an
allowed specification for connection through Open Client) 


...Any ideas?




root@manage:/usr/src/freetds-devel# /usr/local/freetds/bin/tsql -S
server3 -U idsmdc
locale is "C"
locale charset is "US-ASCII"
Password:
Msg 911, Level 16, State 0, Server , Line 0
ASA Error -83: Specified database not found
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server
root@manage:/usr/src/freetds-devel# 

Starting log file for FreeTDS 0.62.dev.20030715
        on 2003-07-15 17:01:16 with debug level 99.
Using trivial iconv from
        iconv.c
names for ISO-8859-1: ISO-8859-1
names for US-ASCII: US-ASCII
names for UCS-2LE: UCS-2LE
names for UCS-2BE: (null)
iconv to convert client-side data to the "US-ASCII" character set
17:01:16.909178 tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
17:01:16.909217 Connecting to 10.150.250.10 port 10033, TDS 5.0.
Sending packet @ 17:01:16.973100
0000 02 00 02 00 00 00 00 00-6d 61 6e 61 67 65 2e 70 |........ manage.p|
0010 69 63 6b 65 74 2d 66 65-6e 63 65 2e 6f 72 67 00 |icket-fe nce.org.|
0020 00 00 00 00 00 00 17 69-64 73 6d 64 63 00 00 00 |.......i dsmdc...|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 06 43 31-73 43 30 43 31 73 43 30 |......C1 sC0C1sC0|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 0a 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 54 53 51 4c-00 00 00 00 00 00 00 00 |....TSQL ........|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 04 73 65 72 76 65-72 33 00 00 00 00 00 00 |...serve r3......|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 07 00 0a 43 31 73 43-30 43 31 73 43 30 00 00 |....C1sC 0C1sC0..|
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 0c 05 00 00 00 54 44-53 2d 4c 69 62 72 61 72 |......TD S-Librar|
01e0 0a 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...... ........|

Sending packet @ 17:01:16.973642
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 69 73 6f |........ .....iso|
0020 5f 31 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |_1...... ........|
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 00 06 |........ ........|
0050 6d 7f ff ff ff fe 02 09-00 00 00 00 0a 68 00 00 |m....... .....h..|
0060 00                     -                        |.|

17:01:16.973762 tds_process_login_tokens()
Received header @ 17:01:17.296271
0000 04 01 00 79 00 00 00 00-                        |...y....|


Received packet @ 17:01:17.296319
0000 ad 22 00 06 05 00 00 00-18 41 64 61 70 74 69 76 |."...... .Adaptiv|
0010 65 20 53 65 72 76 65 72-20 41 6e 79 77 68 65 72 |e Server  Anywher|
0020 65 07 00 00 00 e5 40 00-8f 03 00 00 00 10 05 30 |e.....@. .......0|
0030 38 57 31 30 00 00 00 2b-00 41 53 41 20 45 72 72 |8W10...+ .ASA Err|
0040 6f 72 20 2d 38 33 3a 20-53 70 65 63 69 66 69 65 |or -83:  Specifie|
0050 64 20 64 61 74 61 62 61-73 65 20 6e 6f 74 20 66 |d databa se not f|
0060 6f 75 6e 64 00 00 00 00-fd 02 00 00 00 00 00 00 |ound.... ........|
0070 00                     -                        |.|


17:01:17.296447 looking for login token, got  ad(LOGINACK)
17:01:17.296482 looking for login token, got  e5(EED)
17:01:17.296501 tds_process_default_tokens() marker is e5(EED)
tds_get_string: reading 43 from wire to give 43 to client.
17:01:17.296657 looking for login token, got  fd(DONE)
17:01:17.296678 tds_process_default_tokens() marker is fd(DONE)
17:01:17.296697 tds_process_end() more_results = 0, was_cancelled = 0
17:01:17.296715 leaving tds_process_login_tokens() returning 0


------
Ben Vaughn
Security Analyst
Blackbird Technologies
703-796-1438 W / 703-582-4551 C
bvaughn AT blackbirdtech.com
------