[freetds] php sybase asa 7 connection problem

RCS Computers randy at rcs-comp.com
Mon May 24 12:35:59 EDT 2004


Hi,

I have a Sybase ASA 7.0.4 database server running on a windows server.  I 
have just compiled and installed Freetds 0.62.3 on a linux server and am 
trying to get it to interface with the ASA server.  I am running into this 
when trying to connect.  Thank you for any help you can provide.

rsyring at gateway:/usr/local/freetds/bin$ tsql -H server.barnesnet -p 
49154  -U DBA
locale is "C"
locale charset is "ANSI_X3.4-1968"
Password:
Msg 6004, Level 14, State 0, Server , Line 0
ASA Error -75: Request to start/stop database denied
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

Here is my TDSDUMP file:

Starting log file for FreeTDS 0.62.3
         on 2004-05-24 10:20: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 "ANSI_X3.4-1968" character set
10:20:39.188758 tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
10:20:39.188997 Connecting to 192.168.0.252 port 49154, TDS 5.0.
Sending packet @ 10:20:39.189741
0000 02 00 02 00 00 00 00 00-67 61 74 65 77 61 79 00 |........ gateway.|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0020 00 00 00 00 00 00 07 44-42 41 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 |........ ........|
//password line
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 73 65 72 76 65-72 2e 62 61 72 6e 65 73 |...serve r.barnes|
00c0 6e 65 74 00 00 00 00 00-00 00 00 00 00 00 00 00 |net..... ........|
00d0 00 10 00 03 53 51 4c 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 @ 10:20:39.191429
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 36 34 36 00 00 00 00 00-00 00 00 00 00 00 00 00 |646..... ........|
0030 00 00 00 00 00 00 00 00-00 00 00 06 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                     -                        |.|


10:20:39.191910 tds_process_login_tokens()
Received header @ 10:20:39.192913
0000 04 01 00 82 00 00 00 00-                        |........|


Received packet @ 10:20:39.193079
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                   |........ ..|
10:20:39.193495 looking for login token, got  ad(LOGINACK)
tds_get_string: reading 24 from wire to give 24 to client.
10:20:39.193850 looking for login token, got  e5(EED)
10:20:39.193949 tds_process_default_tokens() marker is e5(EED)
tds_get_string: reading 52 from wire to give 52 to client.
10:20:39.194282 looking for login token, got  fd(DONE)
10:20:39.194375 tds_process_default_tokens() marker is fd(DONE)
10:20:39.194467 tds_process_end: more_results = 0
                 was_cancelled = 0
                 error = 1
                 done_count_valid = 0
10:20:39.194564 tds_process_end() state set to TDS_IDLE
10:20:39.194642 leaving tds_process_login_tokens() returning 0
10:20:39.194969 tds_client_msg: #20014: "Login incorrect.".  Connection 
state is
  now 2.


--------------------------------------
Randy Syring
RCS Computers

"For by grace you have been saved through faith [in Jesus Christ]; and that 
not of yourselves, it is the gift of God"
Ephesians 2:8 




More information about the FreeTDS mailing list