I am trying to get mssql to work in php. I am running Windows Server 2008, PHP 5.3, IIS 7, AND MSSQL Server 2008. I have php5.dll.
I downloaded and installed the latest php_sqlsrv_53_nts_vc6.dll and php_pdo_sqlsrv_53_nts_vc6.dll package by extracting all the .dll to the C:\PHP\ext folder.
I modified my php.ini to include
extension=php_sqlsrv_53_nts_vc6.dll and
extension=php_pdo_sqlsrv_53_nts_vc6.dll
and then restarted the IIS server. I have also double checked that it is the only php.ini on the machine.
When I run php -v I get the error:
PHP Warning: PHP Startup: Unable to load dynamic libarary ‘C:\php\php_sqlsrv_53_nts_vc6.dll’ - The specified module could not be found. in Unknown on line 0.
PHP Warning: PHP Startup: Unable to load dynamic libarary ‘C:\php\php_pdo_sqlsrv_53_nts_vc6.dll’ - The specified module could not be found. in Unknown on line 0.
I also cannot see sqlsrv in my Registered PHP streams when I go to phpinfo()
I can see both files I am calling in my c:php\ext folder and I have the folder permissions set to everyone\everything.
When I try to connect in php I get the error "Call to undefined function sqlsrv_connect() in C:\inetpub\wwwroot\mysqltest.php on line 3
I have been trying to get this to work for about 5 hours. PLEASE PLEASE does anyone have ANY ideas?