Re: MSSQL stability problem

Maybe you are running out of connections. -- bob 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? > > Thanks. > > -- > Stuart > > [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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >