Re: MSSQL stability problem

Robert Twitty wrote:

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? -- Stuart > 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 >> >> > > -- Stuart