mssql_connect no longer working as of PHP 5.3

Question

I just received an email from our host and they've upgraded our PHP to 5.3, unfortunately though, all the scripts have now broken. I traced it down to the function mssql_connect failing. Support told me this has now been deprecated under 5.3 - how can this be true?

How can you connect to a mssql database under PHP 5.3 now??

Solution

http://www.php.net/manual/en/intro.mssql.php

"This extension is not available anymore on Windows with PHP 5.3 or later."

Maybe you should look into converting your app to use PDO: http://www.php.net/manual/en/ref.pdo-sqlsrv.php

Comments

[DaveRandom]

I think he knows that. This doesn't answer the How can you connect to a mssql database under PHP 5.3 now? question though, which is what really matters.

[Gabriel Baker]

Thanks @DaveRandom fixed a suggestion.