Bug #40034 [Com]: mssql_connect(): Unable to connect to server
Edit report at https://bugs.php.net/bug.php?id=40034edit=1 ID: 40034 Comment by: DennisThen at yahoo dot com Reported by:chris dot clos at lmcu dot org Summary:mssql_connect(): Unable to connect to server Status: Assigned Type: Bug Package:MSSQL related Operating System: Windows Server 2003 PHP Version:5.2.0 Assigned To:fmk Block user comment: N Private report: N New Comment: I am using php 5.1.6 with apacher 2.2 and windows xp sp how to config php.ini for me access sql server 2008 ? Previous Comments: [2011-02-22 08:40:03] satyanarayana at egbsystems dot com i am using PHP Version 5.2.5 , xampp , mssql windows 2005. i am not able to connect mssql server . it saying unable to connect [2010-12-28 13:44:36] paj...@php.net @shutzel at gmx dot de Unrelated to this bug report, you simply have to install the MS SqlServer connection drivers, as usual :) [2010-12-28 13:27:54] shutzel at gmx dot de I had the same problem with mssql_connect() Unable to connect to server. Type in the shell php -m and if you get an error that the MSVCR71.dll is missing, just download it from this address http://www.dlldump.com/download-dll-files.php/dllfiles/M/MSVCR71.dll/download.html and copy it to c:\windows\system32 - thats it! Greetings from munich germany ;) [2010-07-18 16:57:39] opc dot three at gmail dot com Related to Bug #29074 [2009-10-19 16:08:48] guoxinzz at 163 dot com To correct a small error: mssql.connect_timeout = 60 http://blog.csdn.net/gumanren From mainland China 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 https://bugs.php.net/bug.php?id=40034 -- Edit this bug report at https://bugs.php.net/bug.php?id=40034edit=1
Bug #40034 [Com]: mssql_connect(): Unable to connect to server
Edit report at http://bugs.php.net/bug.php?id=40034edit=1 ID: 40034 Comment by: satyanarayana at egbsystems dot com Reported by:chris dot clos at lmcu dot org Summary:mssql_connect(): Unable to connect to server Status: Assigned Type: Bug Package:MSSQL related Operating System: Windows Server 2003 PHP Version:5.2.0 Assigned To:fmk Block user comment: N Private report: N New Comment: i am using PHP Version 5.2.5 , xampp , mssql windows 2005. i am not able to connect mssql server . it saying unable to connect Previous Comments: [2010-12-28 13:44:36] paj...@php.net @shutzel at gmx dot de Unrelated to this bug report, you simply have to install the MS SqlServer connection drivers, as usual :) [2010-12-28 13:27:54] shutzel at gmx dot de I had the same problem with mssql_connect() Unable to connect to server. Type in the shell php -m and if you get an error that the MSVCR71.dll is missing, just download it from this address http://www.dlldump.com/download-dll-files.php/dllfiles/M/MSVCR71.dll/download.html and copy it to c:\windows\system32 - thats it! Greetings from munich germany ;) [2010-07-18 16:57:39] opc dot three at gmail dot com Related to Bug #29074 [2009-10-19 16:08:48] guoxinzz at 163 dot com To correct a small error: mssql.connect_timeout = 60 http://blog.csdn.net/gumanren From mainland China [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 -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 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/bug.php?id=40034 -- Edit this bug report at http://bugs.php.net/bug.php?id=40034edit=1
Bug #40034 [Com]: mssql_connect(): Unable to connect to server
Edit report at http://bugs.php.net/bug.php?id=40034edit=1 ID: 40034 Comment by: shutzel at gmx dot de Reported by:chris dot clos at lmcu dot org Summary:mssql_connect(): Unable to connect to server Status: Assigned Type: Bug Package:MSSQL related Operating System: Windows Server 2003 PHP Version:5.2.0 Assigned To:fmk Block user comment: N Private report: N New Comment: I had the same problem with mssql_connect() Unable to connect to server. Type in the shell php -m and if you get an error that the MSVCR71.dll is missing, just download it from this address http://www.dlldump.com/download-dll-files.php/dllfiles/M/MSVCR71.dll/download.html and copy it to c:\windows\system32 - thats it! Greetings from munich germany ;) Previous Comments: [2010-07-18 16:57:39] opc dot three at gmail dot com Related to Bug #29074 [2009-10-19 16:08:48] guoxinzz at 163 dot com To correct a small error: mssql.connect_timeout = 60 http://blog.csdn.net/gumanren From mainland China [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 -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. 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/bug.php?id=40034 -- Edit this bug report at http://bugs.php.net/bug.php?id=40034edit=1
Bug #40034 [Com]: mssql_connect(): Unable to connect to server
Edit report at http://bugs.php.net/bug.php?id=40034edit=1 ID: 40034 Comment by: opc dot three at gmail dot com Reported by: chris dot clos at lmcu dot org Summary: mssql_connect(): Unable to connect to server Status: Assigned Type: Bug Package: MSSQL related Operating System: Windows Server 2003 PHP Version: 5.2.0 Assigned To: fmk New Comment: Related to Bug #29074 Previous Comments: [2009-10-19 16:08:48] guoxinzz at 163 dot com To correct a small error: mssql.connect_timeout = 60 http://blog.csdn.net/gumanren From mainland China [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 -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 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/bug.php?id=40034 -- Edit this bug report at http://bugs.php.net/bug.php?id=40034edit=1