PHP连接SQLServer2005出现mssql_pconnect 经常性连接错误解决方案
PHP连接SQLServer2005出现mssql_pconnect 经常性连接错误解决方案终于在上线前解决了.....
我的环境是windows2003pro+php5.2+sql2005+apache2，当负载稍微有点大的时候就会出现
Warning: mssql_pconnect() : Unable to connect to server。。。
Warning:mssql_connect unable to connect to server
的bug，一旦出现就非常频繁，甚至达到80%的连接都报这个错误,时断时续，只有重启apache才能解决，很奇怪的是一个包含多个iframe的页面，竟然会出现有的连接正常有的连接不正常，请问这是怎么回事呢？php.ini设置，允许持续连接，持续连接数以及最大连接数都是-1。php下的ntwdblib.dll版本与sql2000一致，都是2000.80.194.0
我在项目开发的是很遇到上面类似问题,解决办法如下:
更改php.ini配置一切正常(黑色粗体部分)
问题分析:可能是连接超时导致出错.将连接超时时间设置为60,问题不在出现(本人做股票数据,数据量比较大,所以经常出现类似问题...)
; 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 = 1000
; Minimum message severity to display.
mssql.min_message_severity = 1000
; Compatibility mode with old versions of PHP 3.0.
mssql.compatability_mode = Off
; Connect timeout
mssql.connect_timeout = 60
; Query timeout
mssql.timeout = 60
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096
; 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 = on
; Specify max number of processes. -1 = library default
; msdlib defaults to 25
; FreeTDS defaults to 4096
;mssql.max_procs = -1
; Specify client character set.
; If empty or not set the client charset from freetds.comf is used
; This is only used when compiled with FreeTDS
;mssql.charset = "ISO-8859-1"
不过PHP官方网站的BUGS上有人提到了这个问题.不知道是否为bug还真实配置问题,反正更改好配置,问题解决.真正的问题出处还不知晓.
http://bugs.php.net/bug.php?id=40034
页:
[1]