Are you guys installing as SAPI or as a CGI module? What's the difference? I simply pointed my iis server to the php executable. Should I be using php as ASAPI? Is there something else that I have to install for my MSSQL server to work?STEP 4: Edit the php.ini and un-comment or add an extension=php_mssql70.dll (this calls the appropiate .dll from the SYSTEM path therefore this php_mssql70.dll must be in the SYSTEM folder. The php.ini must also call the correct name of the file (php_mssql70.dll) not php_mssql.dll). This entry is found in two places but must only be added to one or the other. (Windows Extensions and [MSSQL])
I have php up and running. Verified by the phpinfo(); function. However, when I try to connect to the server and do a simple query I get the following error:
Unknow(); Unable to load the dynamic link library'C:/php/php_dbg.dll' - The specified module could not be found.
When I check the directory, the file is there. What am I doing wrong?
***UPDATE***
Seems I was wrong...the php_dbg.dll file wasn't in the php directory. For some reason it was not commented out in my php.ini. I commented it out and the error is gone (not sure if it's to be used or not). New error is now presenting itself, it is as follows:
SECURITY ALERT! The php CGI cannot be accessed directly.
This php CGI binary was complied with force-cgi-redirect enabled. This means that a page will only be served up if the REDIRECT_STATUS CGI variable is set. e.g. via an Apache Action directive.
For more information as to why this behaviour exists, see the manual page for CGI security.
I obviously have something terribly wrong. Someone please help.