note 79440 added to function.mssql-connect
| From: | dkmanonetwothreeathotmaildotcom at osu1 dot php dot net | Date: | Tue, 27 Nov 2007 20:01:31 +0000 |
| Subject: | note 79440 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-132600@lists.php.net to get a copy of this message | ||
Using: Apache 2.2
PHP 5.2.5
SQL 2005 (on a separate pc)
Getting error:
Call to undefined function: mysql_connect()...
Fixed by:
copy ntwdblib.dll from php to apache\bin
copy php_mssql.dll from php\ext to apache\bin
Then I received a timeout error, but at least it tried to connect:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server...
Fixed by:
Following a prior suggestion I downloaded a new version of ntwdblib.dll from Webzila (with one L).
You need to enable Javascript and click on downloads, then search.
Put the new ntwdblib.dll (2000.80.194.0) in the apache\bin directory
Restart the apache service
Then I was able to connect!
SQL Notes:
SQL should be in mixed mode (authentication)
I enabled named pipes as others described:
1) On the SQL Server go into "SQL Server configuration Manager" from the start menu.
2) Click SQL Server 2005 Network Configuration
3) Click Protocols for [YOUR SQL]
4) Enable Named Pipes
PHP Notes:
Edit the INI file to uncomment extension=php_mssql.dll
The default for secure is mssql.secure_connection = Off, I left this alone.
----
Server IP: 69.147.83.197
Probable Submitter: 65.41.26.180
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/79440
Del: integrated -- https://master.php.net/note/delete/79440/integrated
Del: useless -- https://master.php.net/note/delete/79440/useless
Del: bad code -- https://master.php.net/note/delete/79440/bad+code
Del: spam -- https://master.php.net/note/delete/79440/spam
Del: non-english -- https://master.php.net/note/delete/79440/non-english
Del: in docs -- https://master.php.net/note/delete/79440/in+docs
Del: other reasons-- https://master.php.net/note/delete/79440
Reject -- https://master.php.net/note/reject/79440
Search -- https://master.php.net/manage/user-notes.php