Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Anywhere 11 and FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Anywhere 11 and FreeTDS
  • Date: Sun, 12 Oct 2014 09:18:19 +0100

Yes, this is correct. However the protocol the client is using is quite
different from the one we actually use. I can try adding a logout stream if
this helps.
Il 07/ott/2014 22:40 "James Fisher" <ganoopluslinux AT gmail.com> ha scritto:

> Frediano,
>
> Thank you so much for your response, I have attached here a new tcpdump.
> Sorry I am not too familiar with that tool. Please let me know if this is
> correct.
>
> I am running tcpdump on the client using this:
>
> tcpdump -i eth0 -w native.log -s0 host {client IP}
>
> Thanks again.
>
> On Tue, Oct 7, 2014 at 3:08 PM, Frediano Ziglio <freddy77 AT gmail.com>
> wrote:
>
> > Looks not correct. The capture contains a single UDP packet. Sql
> > server use TCP connections.
> >
> > Frediano
> >
> >
> > 2014-10-07 19:18 GMT+01:00 James Fisher <ganoopluslinux AT gmail.com>:
> > > While reviewing the old thread I found that someone(Mr. James Lowden)
> > > requested a tcpdump in order to capture a 'proper' disconnect but I
> > didn't
> > > see that the OP followed up.
> > > https://lists.ibiblio.org/sympa/arc/freetds/2009q4/025362.html
> > >
> > > I have attached mine here. If this isn't the right information, please
> > let
> > > me know. Thanks again to anyone willing to help.
> > >
> > > On Mon, Oct 6, 2014 at 1:57 PM, James Fisher <ganoopluslinux AT gmail.com
> >
> > > wrote:
> > >
> > >> OP: http://thread.gmane.org/gmane.comp.db.tds.freetds/11976
> > >>
> > >> Hello, I am new to mailing lists, so sorry if it's bad that I am
> > reviving
> > >> this old thread - but I am having the same issue as this guy from
> > several
> > >> years back...
> > >>
> > >> I setup a few debian and ubuntu servers to talk to our database(Sybase
> > SQL
> > >> Anywhere 11) using sqsh and adodb(php) with FreeTDS. Once configured
> to
> > >> use TDS v5.0, both sqsh and adodb can connect and execute queries on
> the
> > >> database. However, when I began looking at the log on the server I
> found
> > >> that each time either application disconnects, it shows a message
> like:
> > >>
> > >> >Connection terminated abnormally
> > >> >Disconnected TCPIP client's AppInfo: HOST=debian-vm;PID=2605
> > >>
> > >> The database doesn't *seem* affected - as far as I can tell...
> > >>
> > >> The statements return the rows or insert the data.
> > >>
> > >> I see no performance hit, etc... but it is concerning none the less.
> > >>
> > >> I have also tested with SQL Anywhere 10, 11, 12, & 16, all have the
> same
> > >> issue(and so does their development versions). I have tried tsql/isql
> > and
> > >> both produce the same error.
> > >> Sybase's dbisql/sa_php extension/native odbc client all work without
> the
> > >> error.
> > >>
> > >> I have a FreeTDS log here:
> > >>
> > >> https://gist.github.com/anonymous/b9146103bb16d4eb94c9
> > >>
> > >> I will be happy to do any other dump that might be helpful,
> > >> including setting up an test environment on digitalocean
> > >> for anyone who'd like to take a look.
> > >>
> > >> Thanks to anyone willing to help in any way.
> > >>
> > >
> > > _______________________________________________
> > > FreeTDS mailing list
> > > FreeTDS AT lists.ibiblio.org
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
> _______________________________________________
> 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