note 48982 added to function.mssql-connect
| From: | PyRo at osu1 dot php dot net | Date: | Thu, 13 Jan 2005 19:31:54 +0000 |
| Subject: | note 48982 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-83213@lists.php.net to get a copy of this message | ||
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().
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+48982
Delete -- http://master.php.net/manage/user-notes.php?action=delete+48982&report=yes
Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+48982&report=yes&reason=bad+code
Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+48982&report=yes&reason=spam
Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+48982&report=yes&reason=useless+example
Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+48982&report=yes&reason=contains+commercial+links
Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+48982&report=yes&reason=useless+note
Reject -- http://master.php.net/manage/user-notes.php?action=reject+48982&report=yes
Search -- http://master.php.net/manage/user-notes.php