note 79440 added to function.mssql-connect

From: 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

« previous php.notes (#132600) next »