Hi,
I want to setup Moodle application to use MS SQL Server 2005 instead of MySQL.
I am using PHP 5.1.4, IIS 5.0 and Windows XP/2003.
I have setup one Moodle demo application on my machine using MySQL. It works fine.
Now I want to implement Moodle application with MS SQL Server 2005 because I want to integrate it with my other web application.
I tried different things to get this but still not succeed. Please help me.
Thanks in Advance.
Ankit Prajapati
Have you configured PHP to run under FreeTDS? PHP itself can't communicate directly with MSSQL (at least, not in any way that is supported by Moodle). You have to connect to MSSQL using FreeTDS. (There are alternatives, but FreeTDS seems top be the best option...)