3

I have PHP 5.6 x86 installed on Windows 7 to C:\PHP. IIS is successfully running PHP and MediaWiki when it's configured to use MariaDB. I'm trying to get it to work with MS SQL Server and it's not showing up as an option when I install MediaWiki from scratch.

I've added and enabled php_mssql.dll, php_pdo_sqlsrv_54_nts.dll, php_pdo_sqlsrv_54_ts.dll, php_sqlsrv_54_nts.dll, and php_sqlsrv_54_ts.dll to C:\PHP\ext and MediaWiki still won't see it as a DB option. I added ntwdblib.dll to C:\PHP. I've been trying things from all sorts of different sites with no progress.

How can I configure a MS Sql Server PHP Driver for a fresh install of MediaWiki to use?

I have found that in phpinfo() under "Configure Command" it does have a flag for --without-mssql. Do I have to compile it myself to change that?

EDIT: Screenshot of SQL Server Support

Microsoft SQL Server listed in the supported database list

It has a link for how to compile PHP with SQL Server support, but I'd rather not open that can of worms unless absolutely necessary. Are there easier alternatives?

the
  • 468
  • 8
  • 23
Corey Ogburn
  • 291
  • 1
  • 3
  • 12

2 Answers2

3

It turns out that the SQL Server driver only supports PHP 5.4 (there's also a preview for 5.5) and I was using PHP 5.6. Rolling back to PHP 5.4 and enabling the php_pdo_sqlsrv_54_nts.dll and php_sqlsrv_54_nts.dll extensions worked.

Corey Ogburn
  • 291
  • 1
  • 3
  • 12
0

SQL Server is not supported by Mediawiki according to the Installation requirements [1]. The only way to provide such support is to write your own adapter for SQL Server.

[1] - https://www.mediawiki.org/wiki/Manual:Installation_requirements#Database_server

bjelleklang
  • 111
  • 3