Skip to Content.
Sympa Menu

freetds - Re: More information on using FreeTDS (--with-sybase-ct) & PHP & MSSQL Server 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: <mariuss AT skynet.lt>
  • To: <freetds AT franklin.oit.unc.edu>
  • Subject: Re: More information on using FreeTDS (--with-sybase-ct) & PHP & MSSQL Server 2000
  • Date: Fri, 3 May 2002 08:08:27 +0200 (EET)


hi,
maybe You are using mssql_connect,then try mssql_pconnect.


> I've found that for an unknown reason, after a certain amount of usage,
> apache processes start failing to connect, and the following error
> messages are written to the error_log:
>
> socket: Too many open files in system
> TDS: Write failed in tds_write_packet
> Error: 104 (Connection reset by peer)
>
> (usually only the first line).
>
> I increased the uptime expectation by using sybase_pconnect as opposed
> to sybase_connect, however I did run into one gotcha with this!
>
> I was using a query phrased as following:
> 'set rowcount 1'."\n".'select...'
> And the rowcount setting got "stuck" and affected other pages queries.
>
> I solved this by appending ."\n".'set rowcount 32768' to the end of
> each such query.
>
> --
> Casey Allen Shobe / Network Security Analyst & PHP Developer
> SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
> cshobe AT secureworks.net / http://www.secureworks.net
> Content is my own and does not necessarily represent my company.
>
> ---
> You are currently subscribed to freetds as: [mariuss AT skynet.lt]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')







Archive powered by MHonArc 2.6.24.

Top of Page