Is there a MSSQL Provider for Joomla? I know that there is a MSSQL Client for PHP in beta and I wonder whether it would be hard to change the database provider to point to MSSQL instead of MySQL.
+3
A:
According to this thread (specifically this post) in the official Joomla forum some queries in the Joomla source code are MySQL specific and do not work on Microsoft SQL Server.
It's Joomla itself, some queries in the code are specific for Mysql. Making Joomla work for MSSQL at the moment consists of looking through all queries, checking which ones are Mysql specific and change them to MSSQL or generic ANSI SQL specific.
Albic
2009-09-01 20:51:31