Skip to Content.
Sympa Menu

freetds - RE: [freetds] php/ASA connectivity troubleshooting

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: RE: [freetds] php/ASA connectivity troubleshooting
  • Date: Wed, 22 Jan 2003 16:52:56 -0500 (EST)

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
>





Archive powered by MHonArc 2.6.24.

Top of Page