Maybe you are running out of connections.
The max connections settings in both php.ini and SQL Server are set to unlimited. Is there another limit I am not aware of?
On Wed, 21 Jan 2004, Stuart wrote:
I have a site that makes heavy use of a local SQL Server database. Every 6-12 hours the site continuously reports not being able to connect to the database. That is the only info in the warning that's given. The only solution I've found is to restart the Apache and MSSQL services.
The [MSSQL] section from my php.ini is appended below. IIRC the only values I've changed are mssql.textlimit and mssql.textsize.
Has anyone seen this before? What causes it and how can I stop it happening short of restarting the services every 6 hours?
[MSSQL] ; Allow or prevent persistent links. mssql.allow_persistent = On
; Maximum number of persistent links. -1 means no limit. mssql.max_persistent = -1
; Maximum number of links (persistent+non persistent). -1 means no limit. mssql.max_links = -1
; Minimum error severity to display. mssql.min_error_severity = 10
; Minimum message severity to display. mssql.min_message_severity = 10
; Compatability mode with old versions of PHP 3.0. mssql.compatability_mode = Off
; Connect timeout ;mssql.connect_timeout = 5
; Query timeout ;mssql.timeout = 60
; Valid range 0 - 2147483647. Default = 4096. mssql.textlimit = 2147483647
; Valid range 0 - 2147483647. Default = 4096. mssql.textsize = 2147483647
; Limits the number of records in each batch. 0 = all records in one batch. ;mssql.batchsize = 0
; Specify how datetime and datetim4 columns are returned ; On => Returns data converted to SQL server settings ; Off => Returns values as YYYY-MM-DD hh:mm:ss ;mssql.datetimeconvert = On
; Use NT authentication when connecting to the server mssql.secure_connection = Off
; Specify max number of processes. Default = 25 ;mssql.max_procs = 25