ID: 49288
User updated by: claudio_reis at aeiou dot pt
Reported By: claudio_reis at aeiou dot pt
-Status: Open
+Status: Closed
Bug Type: MSSQL related
Operating System: Windows Server 2003
PHP Version: 5.2SVN-2009-08-18 (snap)
New Comment:
I remove the "ntwdblib.dll" from the php directory and it starts to
work in both browser and task context
Previous Comments:
------------------------------------------------------------------------
[2009-08-18 14:08:44] claudio_reis at aeiou dot pt
Description:
------------
The code used to create a connection to a MS SQL database works fine
when running under a webserver (IIS 6.0) but fails when running from a
command line. I used the same file in both scenarios to be 100% sure.
Using the netcap2 tool i found that when running as a command line(or
task) it tries to comunicate to the ms sql server using SMB protocol and
tries to do a tree connect. The sql server responds with a
STATUS_BAD_NETWORK_NAME. Result the connection cannot be done.
When running in the webserver context it queries the dns for the server
ip then it stablish a connection to the 4414 port(ms-sql-m).
Why this strange behaviour? Thanks for your help.
Other info that can be usefull
PHP VERSION:
PHP-5.2.9-2
MS SQL SERVER:
SQL Server Enterprise Edition
8.00.2184(SP4)
Microsoft Windows NT - 5.0(2195)
Windows Server:
MS Windows Server 2003 R2
SP2
php.ini:
[MSSQL]
mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
Reproduce code:
---------------
/* connection string ommited for security reasons */
if ($con = mssql_connect("SERVER","USER","PASSWORD")){ print("YES");}
else{ print("NO")}
Expected result:
----------------
YES
Actual result:
--------------
can't connect to server
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=49288&edit=1
