Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server (SOLUCION)

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to se

Soure: http://ar2.php.net/function.mssql-connect

dkman one two three at hotmail dot com
27-Nov-2007 05:01
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.

Prevenir Resize y Minimización de Ventana -

La propiedad que permite prohibir la opción de minimizar y modificar el tamaño de la pantalla es FormBorderStyle.
Las opciones posibles están en este post de msdn:
http://msdn.microsoft.com/es-es/library/hw8kes41(VS.80).aspx