Skip to Content.
Sympa Menu

freetds - RE: [freetds] Connection Errors...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rick Conner" <rick AT rickconner.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Connection Errors...
  • Date: Sat, 18 Jun 2005 13:48:18 -0400


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Friday, June 17, 2005 10:39 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Connection Errors...

Rick D Conner wrote:
>
> I have to ask for some help because I'm at the end of my rope with this.
> First off, I'm restricted in that the web host has the "real" control
> over the freetds configurations, but they will take "suggestions".
...
> We are on a unix box, running apache. if it's necessary I can get the
> ver
> #'s .. And we are connecting to a remote mssql server running MsSql
> #server
> 2000.
> 15:33:45.275589 Connecting to 66.208.184.170 port 1433, TDS 7.0.
...
> 15:38:45.787660 goodread: errno=104, "Connection reset by peer"
> 15:38:45.787717 tds_client_msg: #20004: "Read from SQL server failed.".
> Connection state is now 0.
...
> If you notice on the freetds.log file, there is a 5 minute "pause" where
> the connection is finally reset by the peer (mssql server I'm assuming).
> Now, before you say the same thing that my host did, I HAVE checked the
> username and password, and they are correct. I even setup a new account
> on the mssql server and tried it to no avail..

>From the host making the connection, does "telnet 66.208.184.170 1433"
work? I bet it doesn't. Is there a firewall in between?


=========================
Yes, my web host is able to do a telnet to the remote server. And I am able
to connect from my system as well. All the necessary ports are open (1433).

=========================

>If the address were invalid or the server were listening on a different
>port, you'd get an immediate failure. The fact that there's a 5-minute
>pause says to me the server accepted the connection, but couldn't transmit
>it back to the client.

=========================
Is there any possibility that the FreeTDS installation could be installed
into PHP incorrectly? What I'm wondering now is the lines that read:

16:33:45.235066 tds_put_string wrote 0 bytes
16:33:45.235247 tds_process_login_tokens()

Why is the first line writing 0 bytes? Is that not where the login
information is sent? Just prior to the tds_process_login_tokens?

Thanks again for your help!

Rick Conner
Rick AT wedosites.com






Archive powered by MHonArc 2.6.24.

Top of Page