freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Problem with MSSQL Server 2000 SP1 / Apache 1.3.20 + PHP 4.0.6 + freetds 0.53 during queries

From: "Stefan Carstens" <s.carstens AT coolspot.de>
To: <freetds AT franklin.oit.unc.edu>
Subject: Problem with MSSQL Server 2000 SP1 / Apache 1.3.20 + PHP 4.0.6 + freetds 0.53 during queries
Date: Fri, 9 Nov 2001 14:00:18 +0100

Hi out there,

The problem occurs only sometimes but it does an entry in the apache error_log

Error: 104 (Connection reset by peer) TDS: Write failed in tds_write_packet"

If we use pconnect, the problems comes up more often, than with the use of a "normal" connect !

The webserver is a Mandrake Linux 8.0 System, Apache 1.3.20 + PHP 4.0.6 with FreeTDS 0.53.

PHP was configured this way :

./configure --with-apxs --enable-versioning --enable-trans-sid --without-mysql --enable-track-vars --enable-sysvsem --enable-sysvshm --enable-
sockets --with-zlib=/usr/local/ --with-apxs --with-curl=/usr/local/lib --with-sybase=/usr/local/sqlserver

Apache was compiled with support for SSL.

FreeTDS was compiled with --prefix=/usr/local/sqlserver --with-tdsver=7.0

The MS SQL Server is a 2000 SP1 running on a 2000 Server SP2.

Both maschines are IBM xSeries 330 with 2 x PIII 866 and 512 MB RAM.

MS's Query Analyzer runs perfectly, so all other tools do, only the combination mentioned above make problems.

Thanks in advance,

Stefan

Problem with MSSQL Server 2000 SP1 / Apache 1.3.20 + PHP 4.0.6 + freetds 0.53 during queries, Stefan Carstens, 11/09/2001
- <Possible follow-up(s)>
- Re: Problem with MSSQL Server 2000 SP1 / Apache 1.3.20 + PHP 4.0.6 + freetds 0.53 during queries, Brian Bruns, 11/09/2001
- Re: Problem with MSSQL Server 2000 SP1 / Apache 1.3.20 + PHP 4.0.6 + freetds 0.53 during queries, Stefan Carstens, 11/10/2001