note 48982 deleted from function.mssql-connect by danbrown
| From: | danbrown@php.net | Date: | Sun, 07 Dec 2008 19:45:22 +0000 |
| Subject: | note 48982 deleted from function.mssql-connect by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-147876@lists.php.net to get a copy of this message | ||
Note Submitter: PyRo
----
There seems to be an issue with the MSSQL extension and Windows Server 2003 Web Edition that
prevents a connection to an SQL server, reporting an error like this "Not associated with a
trusted SQL Server connection" when trying to use mssql_connect().
However, the bug seems to be residing in ntwdblib.dll, which comes with PHP and also with the
Microsoft SQL Client. I've found that using the SQL Client's version of ntwdblib.dll
(version 8.0+) fixes the issues with MSSQL, but unfortunately the SQL Client cannot be installed on
the Web Edition version of Server 2003.
So, the simple work-around or fix would be to obtain a newer version of ntwdblib.dll (8.0+) supplied
from one of Microsoft's SQL applications and then overwrite your PHP version (7.0) with it on
the Web Edition machine. This should allow proper connectivity with mssql_connect().