I have a PHP app running happily on the following system:
web app: PHP version 5.2.3
OS: Windows Server 2003 Standard 32 bit
database: SQL Server 2005 (express)
web server: IIS 6
I'm trying to get the same thing running on the following:
web app: PHP version 5.2.11
OS: Windows Server 2008 Standard 64 bit
database: SQL Server 2008 Standard 64-bit
web server: IIS 7
After doing the install and setup I usually do, phpinfo() is running but there is no MSSQL section. I've looked around and found some MS documentation to set up the system using a php_sqlsrv.dll and tried that but it seems to use a different interface to connect to the database (no more mssql_connect(), now it's sqlsrv_connect()). Is this the only way to connect php to SQL Server 2008 or do I just have the setup wrong? If I can go back to PHP 5.2.3 and have it work, that will be fine but I didn't want to undo what I have if it won't help.
Thanks,