Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "blackwater dev" <blackwaterdev AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Please Help...Log files Included-Connection kicked off of MSSQL db
  • Date: Mon, 10 Apr 2006 10:56:51 -0400

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|

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



  • [freetds] Please Help...Log files Included-Connection kicked off of MSSQL db, blackwater dev, 04/10/2006

Archive powered by MHonArc 2.6.24.

Top of Page