Skip to Content.
Sympa Menu

freetds - [freetds] Sybase ASA 7, unixODBC problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Sybase ASA 7, unixODBC problem

Chronological Thread  
    < Chronological >       < Thread >
  • From: "Gene Dymarskiy" <gagarin AT i-dep.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Sybase ASA 7, unixODBC problem
  • Date: Tue, 2 Nov 2004 16:42:02 -0600
Some additional info.

TDSDUMPs for tsql and isql connections look different.

Note: the name of the database I am connecting to is "needles". The
name is being passed with tsql but not with isql if I read the dumps
properly.

The server are on private network so I am not worried about passwords
and such ;) so I post unedited dumps

Thank you for your help!

tsql (working fine, can connect):

~~~~~~~~~~~~~~~~

Starting log file for FreeTDS 0.62.1
on 2004-11-02 13:04:39 with debug level 99.
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "UTF-8" character set
13:04:39.519720 tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
13:04:39.519751 Connecting to 192.168.1.5 port 2638, TDS 5.0.
Sending packet @ 13:04:39.560330
0000 02 00 02 00 00 00 00 00-61 6e 61 70 6f 6c 2e 69 |........ anapol.i|
0010 2d 64 65 70 2e 63 6f 6d-00 00 00 00 00 00 00 00 |-dep.com ........|
0020 00 00 00 00 00 00 10 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 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 6e 65 65 64 6c-65 73 00 00 00 00 00 00 |...needl es......|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 07 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 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 @ 13:04:39.560528
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 75 74 66 |........ .....utf|
0020 38 00 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 04 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 - |.|


13:04:39.560588 tds_process_login_tokens()
Received header @ 13:04:39.616873
0000 04 01 00 5b 00 00 00 00- |...[....|


Received packet @ 13:04:39.616903
0000 e3 09 00 03 06 63 70 31-32 35 32 00 ad 22 00 05 |.....cp1 252.."..|
0010 05 00 00 00 18 41 64 61-70 74 69 76 65 20 53 65 |.....Ada ptive Se|
0020 72 76 65 72 20 41 6e 79-77 68 65 72 65 07 00 00 |rver Any where...|
0030 00 e2 16 00 01 09 00 00-06 61 01 ff ff fe e6 02 |........ .a......|
0040 09 ff ff 00 00 0a 68 00-00 0a fd 00 00 01 00 00 |......h. ........|
0050 00 00 00 - |...|


13:04:39.616948 looking for login token, got e3(ENVCHANGE)
13:04:39.616967 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 6 from wire to give 6 to client.
13:04:39.617132 tds_iconv_info_init: converting "UTF-8"->"CP1252"
13:04:39.617195 tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
13:04:39.617213 looking for login token, got ad(LOGINACK)
tds_get_string: reading 24 from wire to give 24 to client.
13:04:39.617243 looking for login token, got e2(CAPABILITY)
13:04:39.617259 tds_process_default_tokens() marker is e2(CAPABILITY)
13:04:39.617276 looking for login token, got fd(DONE)
13:04:39.617291 tds_process_default_tokens() marker is fd(DONE)
13:04:39.617308 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
13:04:39.617325 tds_process_end() state set to TDS_IDLE
13:04:39.617341 leaving tds_process_login_tokens() returning 1
Sending packet @ 13:04:39.617366
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 - | |


Received header @ 13:04:39.659516
0000 04 01 00 11 00 00 00 00- |........|


Received packet @ 13:04:39.659543
0000 fd 00 00 01 00 00 00 00-00 |........ .|


13:04:39.659563 processing result tokens. marker is fd(DONE)
13:04:39.659579 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
13:04:39.659597 tds_process_end() state set to TDS_IDLE
13:04:39.659613 tds_process_result_tokens() state is COMPLETED

~~~~~~~~~~~~~~~~~~~~~~~~~~

isql (cannot connect):

~~~~~~~~~~~~~

pid: 9258:Starting log file for FreeTDS 0.62.1
on 2004-11-02 13:06:10 with debug level 99.
pid: 9258:names for ISO-8859-1: ISO-8859-1
pid: 9258:names for UTF-8: UTF-8
pid: 9258:names for UCS-2LE: UCS-2LE
pid: 9258:names for UCS-2BE: UCS-2BE
pid: 9258:iconv to convert client-side data to the "ISO-8859-1"
character set
pid: 9258:13:06:10.059541 tds_iconv_info_init: converting
"ISO-8859-1"->"UCS-2LE"
pid: 9258:13:06:10.059606 Connecting to 192.168.1.5 port 2638, TDS 5.0.
pid: 9258:Sending packet @ 13:06:10.372320
0000 02 00 02 00 00 00 00 00-61 6e 61 70 6f 6c 2e 69 |........ anapol.i|
0010 2d 64 65 70 2e 63 6f 6d-00 00 00 00 00 00 00 00 |-dep.com ........|
0020 00 00 00 00 00 00 10 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 53 59 42 41 53-45 00 00 00 00 00 00 00 |...SYBAS E.......|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 06 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...... ........|


pid: 9258:Sending packet @ 13:06:10.372692
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 - |.|


pid: 9258:13:06:10.372774 tds_process_login_tokens()
pid: 9258:Received header @ 13:06:10.428891
0000 04 01 00 82 00 00 00 00- |........|


pid: 9258:Received packet @ 13:06:10.428937
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 49 00-74 17 00 00 00 0e 05 30 |e.....I. t......0|
0030 38 57 32 39 00 00 00 34-00 41 53 41 20 45 72 72 |8W29...4 .ASA Err|
0040 6f 72 20 2d 37 35 3a 20-52 65 71 75 65 73 74 20 |or -75: Request |
0050 74 6f 20 73 74 61 72 74-2f 73 74 6f 70 20 64 61 |to start /stop da|
0060 74 61 62 61 73 65 20 64-65 6e 69 65 64 00 00 00 |tabase d enied...|
0070 00 fd 02 00 00 00 00 00-00 00 |........ ..|


pid: 9258:13:06:10.429016 looking for login token, got ad(LOGINACK)
pid: 9258:tds_get_string: reading 24 from wire to give 24 to client.
pid: 9258:13:06:10.429090 looking for login token, got e5(EED)
pid: 9258:13:06:10.429122 tds_process_default_tokens() marker is e5(EED)
pid: 9258:tds_get_string: reading 52 from wire to give 52 to client.
pid: 9258:13:06:10.429203 looking for login token, got fd(DONE)
pid: 9258:13:06:10.429235 tds_process_default_tokens() marker is
fd(DONE)
pid: 9258:13:06:10.429268 tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
pid: 9258:13:06:10.429301 tds_process_end() state set to TDS_IDLE
pid: 9258:13:06:10.429332 leaving tds_process_login_tokens() returning 0
pid: 9258:13:06:10.429392 tds_client_msg: #20014: "Login incorrect.".
Connection state is now 2.



......CONFIDENTIALITY NOTICE......
The information in this email may be confidential and/or privileged. This
email is intended to be reviewed by only the individual or organization named
above. If you are not the intended recipient or an authorized representative
of the intended recipient, you are hereby notified that any review,
dissemination or copying of this email and its attachments, if any, or the
information contained herein is prohibited. If you have received this email
in error, please immediately notify the sender by return email and delete
this email from your system. Thank You.




Archive powered by MHonArc 2.6.24.

Top of Page