Edit report at http://bugs.php.net/bug.php?id=40034&edit=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] pajoye@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:guoxinzz@163.com or guoxinzz@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"
------------------------------------------------------------------------
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=40034&edit=1