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:
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"
Previous Comments:
------------------------------------------------------------------------
[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?
------------------------------------------------------------------------
[2008-10-10 08:35:20] dirk dot melcher at mdk-nord dot de
thanks everybody for the hints that helped me a lot!
I'm using php Version 4.2.1 and the same problem applied to me.
I downloaded an appropriate version of ntwdblib.dll at:
http://www.dlldll.com/ntwdblib.dll_download.html
Bye,
Dirk
------------------------------------------------------------------------
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