[freetds] Please Help...Log files Included-Connection kicked off ofMSSQL db

blackwater dev blackwaterdev at gmail.com
Mon Apr 10 11:09:21 EDT 2006


My FreeTDS.conf file lives where I installed it from in my home folder and I
copied in from that what was in the working server..is that how I change
it?  Where should this file live?

On 4/10/06, ZIGLIO, Frediano, VF-IT <Frediano.Ziglio at vodafone.com> wrote:
>
> >
> > Hello all,
> >
> > I asked this question a few days ago but got no reponse so
> > thought I would
> > try again.  I have two servers (dev and production).  They
> > are both Fedora 3
> > and both have the same versions of FreeTDS and PHP.  The dev
> > server is on my
> > home network and I can make a connection fine to the remote
> > mssql db.  The
> > production server is a dedicated server given to me by my
> > host and the exact
> > same code that works on the dev machine can connect to the
> > remote mssql db
> > but gets kicked off as soon as I try to change the db.  Do I need any
> > special ports open on my production db?  I can't seem to
> > figure it out and
> > it is driving my crazy and my application is now behind
> > schedule waiting on
> > this to be resolved.  I have included part of my log file
> > where you can see
> > the "connection reset by peer":
> >
> > I am connected fine and then this (I found it strange that
> > the db name had a
> > space but I think that is just something in the log, also why
> > is there an
> > exclamation mark before the use?
> >
> > Thanks!
> >
> > 09:24:25.352405 tds_free_all_results()
> > 09:24:25.352544 Sending packet
> > 0000 0f 01 00 1a 00 00 00 00-21 0d 00 00 00 00 75 73
> > |........ !.....us|
> > 0010 65 20 6d 6c 73 6e 68 73-71 6c                   |e carl ot|
> >
>
> Here is the problem. You are trying to use protocol 5.0 which is not
> supported by Microsoft SQL (only by Sybase).
>
> > 09:24:25.352809 in dbsqlok()
> > 09:24:25.381915 goodread: errno=104, "Connection reset by peer"
> > 09:24:25.382069 tds_client_msg: #20004: "Read from SQL server
> > failed.".
> > Connection state is now 0.
> > 09:24:25.382270 dbsqlok() marker is 0
> > 09:24:25.382405 processing result tokens.  marker is  0()
> > 09:24:25.382537 tds_process_default_tokens() marker is 0()
> > 09:24:25.382686 leaving tds_process_default_tokens() connection dead
>
> Use protocol 7.0 or 8.0 and you will be happy :)
>
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



More information about the FreeTDS mailing list