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

blackwater dev blackwaterdev at gmail.com
Mon Apr 10 11:53:04 EDT 2006


Brian,

I did have the conf file in my home directory but it wasn't being picked up
so I copied it to user/local/etc and now I get a different error:

*** glibc detected *** double free or corruption: 0x08770cf0 ***

I am just trying to select one row and the row does have a blob field which
messed me up in bcp but the dev server can select this row fine.  Is there
something more that needs to be installed on this server?  I can attach the
log if needed.  I have this in my conf file:
(I changed the ip)

[MyServer2k]
        host = 202.33.333.33
        port = 1433
        tds version = 8.0


On 4/10/06, Brian Morton <bmorton at secureworks.com> wrote:
>
> http://freetds.org/userguide/freetdsconf.htm#FREETDSCONFLOCATION
>
> -----Original Message-----
> From: blackwater dev [mailto:blackwaterdev at gmail.com]
> Sent: Monday, April 10, 2006 11:10 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Please Help...Log files Included-Connection kicked
> off ofMSSQL db
>
> Ok, but how do I specify this?  If it is in the freetds.conf, where should
> this file live?
>
> On 4/10/06, Brian Morton <bmorton at secureworks.com> wrote:
> >
> > SQL Server 2000 is protocol 8.  Otherwise, use 7.
> >
> > -----Original Message-----
> > From: blackwater dev [mailto:blackwaterdev at gmail.com]
> > Sent: Monday, April 10, 2006 11:08 AM
> > To: FreeTDS Development Group
> > Subject: Re: [freetds] Please Help...Log files Included-Connection
> kicked
> > off ofMSSQL db
> >
> > Thanks!...Now, how do I use protocol 7 or 8?
> >
> > 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
> > >
> > _______________________________________________
> > 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>


More information about the FreeTDS mailing list