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

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Mon Apr 10 11:00:01 EDT 2006


> 
> 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


More information about the FreeTDS mailing list