note 54201 added to ref.mssql
| From: | hbzxc at 126 dot com | Date: | Mon, 27 Jun 2005 09:14:49 +0000 |
| Subject: | note 54201 added to ref.mssql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-91005@lists.php.net to get a copy of this message | ||
I am trying to connect to SQL Server 2000 from PHP
I bumped to following warning:
Warning: mssql_connect(): Unable to connect to server: SERVER\Portal
....... on line 5
on line 5 there is:
$db_connect = mssql_connect('SERVER\Portal', 'sa', 'my_passwd');
I did the following
1.enabled php_mssql.dll extension in PHP.ini
2.every dll is in proper place(System32 or PHP folder),including ntwdblib.dll
I search lots of profile throught web ,but no one give me proper answer to resolve it.
after a few hour ,I found the problem was caused by
ntwdblib.dll ,which version is 7.00.839 ,when I replaced old ntwdblib.dll with the new ntwdblib.dll
,which version is 8.00.194 ,all problem are solved.
----
Manual Page -- http://www.php.net/manual/en/ref.mssql.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+54201
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+54201&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+54201&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+54201&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+54201&report=yes&reason=useless
Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+54201&report=yes&reason=non-english
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+54201&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+54201&report=yes
Search -- http://master.php.net/manage/user-notes.php