sql server - mssql_connect in PHP does not exist

Question

I've been struggling with this for a while now and I don't know what I'm missing. The error is:

call to undefined function mssql_connect()

Having looked into it already, I've done about everything I can.

• I moved the php.ini file to c:windows

• In the ini I changed the extension_dir directive to c:PHPext and uncommented:

  extension = php_mssql.dll
  

• I moved the dll file to c:windowssystem32
• I downloaded the 200.80.194.0 version of ntwdblib.dll and placed it in c:windowssystem32
• I restarted my web server client

PHP is still not recognizing the function and library classes. I'm stumped as to what I didn't do right and would love some help. If it's helpful, I'm running PHP 5.3.2, IIS, and Microsoft SQL Server 2008.

Answer 1

For SQL Server 2008 on Windows it's sqlsrv_connect This is because Microsoft now uses the SQL Driver for PHP which is now on version 2.0 I believe.

Also it's worth noting that with sqlsrv_query, and mssql_query they switched the parameters around (spent half an hour figuring that out).