I posted this up in a couple other forums, but I realize this really belongs here.
I'm having massive troubles getting PHP to work with MS-SQL server on a Win2k box.
I installed the PHP binary on my IIS 5.0 server which has SQL server 7.0. I was already using ASP with SQL server, so I know it's working.
I realized I'd need the extension DLL called php_mssql.dll, so I went out on the web and found it... well, several incarnations of it, it would seem. (3 different sized files, same name)
Then, I changed my php.ini file to point to my php directory, and put a copy of the file in that directory and system32.
So then, I should be ready to roll, right? Wrong. What happens? When one DLL (of the aforementioned three) is used, any php query executed causes an instant php.exe application error. "The instruction at 0x1009a726 referenced memory at 0x6a575651. The memory could not be read." Ooooookay then. However, with this DLL, i notice that if i create a test php file with a call to phpinfo(), that comes up fine with MS-SQL settings listed in it!
The other DLLs yield a different result: Every php file delivers a warning message: Unable to load dynamic library 'c:\php\php_mssql.dll' - The Specified procedure could not be found. And this is spouted out in the browser output: Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\projnos\template.php on line 33
PHP Warning: Unable to load dynamic library 'c:\PHP/php_mssql.dll' - The specified procedure could not be found. in Unknown on line 0
And the test file with phpinfo() loads without MS-SQL settings and, for some reason, without its graphics.
Am I just getting my extension DLL files from bad places? If so, where should I get them?
