Can´t connect to MSSQL from PHP/Apache running on Windows

Arborer,

This is run on Windows, so extensions are .dll and not .so as in Linux. Also, I´m trying to connect to MS SQL Server and not MySQL, so the extension that need to be loaded is php_mssql.dll and not php_mysql.dll nor php_mysqli.dll.

I have TWO IDENTICAL php.ini files, one in c:\appserv\php5 and other in c:\windows. Both have enabled the php_mssql.dll extension.

When I run the testdb.php file from command prompt using php.exe, the php.ini in c:\appserv\php5 is loaded and mssql.dll´s are loaded also. But if I run testdb.php from inside a browser, the php.ini into c:\windows is used instead, and mssql.dll´s are not loaded.

I think the problem could be the link between PHP and Apache.

Any other suggestion, everyone?

Thanks

Where (which directory) is the php_mssql.dll  located in?

Does it match the extension_dir value in the php.ini e.g.

extension_dir="c:\xxxx\yyyyy\ext"

If not either alter the C:\Windows\php.ini    or copy the DLL's to the directory specified in the file.

Yes, the php_mssql.dll is located in the extension dir specified on both php.ini files. In fact, the code works when called directly thru php.exe, that's why I think I've missed something that prevents the code to works when called thru Apache.

Thanx

Well, I've changed PHPIniDir in Apache configuration file to force it to use same php.ini as when running php.exe, that is, the php.ini located at c:\appserv\php5, so now I have onlye one php.ini file.

I've been looking at Apache logs and found errors when loading php_mssql.dll:

[Sun Sep 06 20:55:36 2009] [notice] Apache/2.2.8 (Win32) PHP/5.2.6 configured -- resuming normal operations
[Sun Sep 06 20:55:36 2009] [notice] Server built: Jan 18 2008 00:37:19
[Sun Sep 06 20:55:36 2009] [notice] Parent: Created child process 1608
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\AppServ\\php5\\ext\\php_msql.dll' - The specified module could not be found.\r\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\AppServ\\php5\\ext\\php_mssql.dll' - The specified module could not be found.\r\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\AppServ\\php5\\ext\\php_pdo_mssql.dll' - The specified module could not be found.\r\n in Unknown on line 0
[Sun Sep 06 20:55:37 2009] [notice] Child 1608: Child process is running
[Sun Sep 06 20:55:37 2009] [notice] Child 1608: Acquired the start mutex.
[Sun Sep 06 20:55:37 2009] [notice] Child 1608: Starting 64 worker threads.
[Sun Sep 06 20:55:37 2009] [notice] Child 1608: Starting thread to listen on port 8080.

I don't know why Apache can't make PHP to load those libraries as they are in proper place and can be accessed (tried opening dll file contents from withing a web page and it showed up), also dlls for mysql are loaded and working properly.

Now this question turns into: Why Apache can't make PHP to load php_mssql.dll?

Any comment?
Thank you