FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

You are connecting with TDS 4.2, that is not supported by ASA.  You must 
use 5.0.

Brian

On Wed, 22 Jan 2003, owen gottschalk wrote:

> hello, 
> 
> > > I am trying to use freetds to connect from a web server
> > > running PHP to a
> > You are correct, if I correctly understand "ASA" to be Sybase 
> > SQL Anywhere.
> 
> This is correct. 
> 
> 
> > You need TDS version 5.0, port 2638.  You should at least be 
> > able to connect to the port with telnet.  If you haven't 
> 
> We are able to connect to the port with telnet.
> 
> > I wonder, what does your documentation say about, "ASA Error 
> > -75: Request to start/stop database denied"?  That doesn't 
> > sound like a protocol problem....
> 
> I agree that it doesn't sound like a protocol problem, however the admin
> of the server I am trying to connect to insists that everything on his
> end is correct. Having no experience with Sybase databases, and no
> access to any other sybase database, I am forced to take his word for
> it. 
> 
> > If you can telnet to the port but can't connect with tsql, 
> > and are sure it's not a permissions problem, please post a 
> > TDSDUMP log of the session (taking care to erase the 
> > passwords).  If the server is responding abnormally, it 
> > should show up there.
> 
> Below is the TDSDUMP. Nothing looks abnormal, but if anyone has any
> insight it would be greatly appreciated. 
> 
> Thanks, 
> 
> og  
> 
> 2003-01-16 16:26:43 Connecting addr XXX.XXX.XXX.XXX port 2638
> Sending packet @ 2003-01-16 16:26:43
> 0000  02 00 02 00 00 00 00 00 6d  79 68 6f 73 74 00 00   |........m
> yhost..|
> 0010  00 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00   |.........
> .......|
> 0020  00 00 00 00 00 00 XX XX XX  XX XX XX XX XX XX XX   |.......XX
> XXXXXXX|
> 0030  XX XX XX XX XX XX XX XX 00  00 00 00 00 00 00 00   |XXXXXXXX.
> .......|
> 0040  00 00 00 00 00 XX XX XX XX  XX XX XX XX XX XX 00   |......XXX
> XXXXXX.|
> 0050  00 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00   |.........
> .......|
> 0060  00 00 00 00 09 33 37 38 37  36 00 00 00 00 00 00   |.....3787
> 6......|
> 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 02 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 XX XX XX XX XX XX XX  XX XX XX XX XX XX XX   |...XXXXXX
> XXXXXXX|
> 00c0  XX XX XX XX XX XX XX XX XX  XX XX 00 00 00 00 00   |XXXXXXXXX
> XX.....|
> 00d0  00 XX XX XX XX XX XX XX XX  XX XX 00 00 00 00 00   |..XXXXXXX
> XX.....|
> 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 09 04 02 00 00 54 44 53  2d 4c 69 62 72 61 72   |......TDS

               ^ protocol version 04 02 00 00

> -Librar|
> 01e0  0a 00 00 00 00 00 0d 11 75  73 5f 65 6e 67 6c 69   |........u
> s_engli|
> 01f0  73 68 00 00 00 00 00 00 00  00 00 00 00 00 00 00   |sh.......
> .......|
> 
> 
> Sending packet @ 2003-01-16 16:26:43
> 0000  02 01 00 4c 00 00 00 00 00  00 00 00 00 00 0a 00   |...L.....
> .......|
> 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 00  00 00 00               |......... ...|
> 
> 
> 2003-01-16 16:26:43 inside tds_process_login_tokens()
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 09 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  ad                                                |.|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 0a 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  22 00                                             |".|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 09 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  06                                                |.|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 0c 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  04 02 00 00                                       |....|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 09 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  18                                                |.|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 20 00 00 00 00                           |... ....|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  41 64 61 70 74 69 76 65 20  53 65 72 76 65 72 20   |Adaptive
> Server |
> 0010  41 6e 79 77 68 65 72 65                           |Anywhere|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 0c 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  07 00 00 00                                       |....|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 09 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  aa                                                |.|
> 
> 
> 2003-01-16 16:26:43 inside tds_process_default_tokens() marker is aa
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 0a 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  40 00                                             |@.|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 0c 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  74 17 00 00                                       |t...|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 09 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  00                                                |.|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 09 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  0e                                                |.|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 0a 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  34 00                                             |4.|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 3c 00 00 00 00                           |...<....|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  41 53 41 20 45 72 72 6f 72  20 2d 37 35 3a 20 52   |ASA Error
> -75: R|
> 0010  65 71 75 65 73 74 20 74 6f  20 73 74 61 72 74 2f   |equest to
> start/|
> 0020  73 74 6f 70 20 64 61 74 61  62 61 73 65 20 64 65   |stop data base
> de|
> 0030  6e 69 65 64                                       |nied|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 09 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  00                                                |.|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 09 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  00                                                |.|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 0a 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  00 00                                             |..|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 09 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  fd                                                |.|
> 
> 
> 2003-01-16 16:26:43 inside tds_process_default_tokens() marker is fd
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 0a 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  02 00                                             |..|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 00 00 0a 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  00 00                                             |..|
> 
> 
> Received header @ 2003-01-16 16:26:43
> 0000  04 01 00 0c 00 00 00 00                           |........|
> 
> 
> Received packet @ 2003-01-16 16:26:43
> 0000  00 00 00 00                                       |....|
> 
> 
> 2003-01-16 16:26:43 leaving tds_process_login_tokens() returning 0
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>