note 79440 deleted from function.mssql-connect by danbrown

Note Submitter: dkman one two three at hotmail dot com ---- 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.