Re: MSSQL stability problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux