ID: 40034 Comment by: guoxinzz at 163 dot com Reported By: chris dot clos at lmcu dot org Status: Assigned Bug Type: MSSQL related Operating System: Windows Server 2003 PHP Version: 5.2.0 Assigned To: fmk New Comment:
To correct a small error: mssql.connect_timeout = 60 http://blog.csdn.net/gumanren >From mainland China Previous Comments: ------------------------------------------------------------------------ [2009-10-19 16:05:48] guoxinzz at 163 dot com A temporary solution, the real problem is not found. Explore the question, please contact my technical blog http://blog.csdn.net/gumanren My E-mail:guoxi...@163.com or guoxi...@gmail.com My name is guoxin. Please view the English portion of the GOOGLE translation. Change PHP.ini configuration, as follows: [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 = 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 = 5 ; 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" ------------------------------------------------------------------------ [2009-07-06 11:07:38] nm dot patel at sahmed dot com I have PHP Version 5.2.10 i have open mssql support from php.ini . I use IIS in Server 2005 Express I can no longer do mssql_connects, instead I get an error. Once I did this I get an error: Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost:1433 in C:\Inetpub\wwwroot\LifeScience\TEST.php on line 8 Couldn't connect to SQL Server on localhost:1433 ------------------------------------------------------------------------ [2009-06-08 16:36:34] wrossmann at gmail dot com Same issue under 5.2.1.1, solved as above. We deploy this same solution to dozens of IIS6/PHP servers with several hundred domains and have not detected any apparent incidental functionality issues. ------------------------------------------------------------------------ [2008-12-11 19:51:39] parvesh_k at hotmail dot com I have a windows dll version 2000.80.194.0 and use php 5.2.6 I am trying to connect to MSQL2K5 but get a following error "Unable to connect to server: " I have following option turned on mssql.secure_connection = On in php.ini ------------------------------------------------------------------------ [2008-10-10 10:40:09] hamzeh dot shaar at ifpexpo dot com Guys, I have the same problem. I have php 5.2.6 on IIS 6. I cannot connect from it my SQL server 2000 (MSDE) running on the same machine knowing that i have another PHP installation 5.2.5 on the same LAN and it connects to the same MSDE 2000 Normally. I tried copying php5isapi.dll and ntwdblib from the working machine to the other and still it dd not work. any suggesstions? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/40034 -- Edit this bug report at http://bugs.php.net/?id=40034&edit=1
