Moodle 1.7 on Server 2003 with IIS and MSSQL

Moodle 1.7 on Server 2003 with IIS and MSSQL

Dave van Suilichem -
回帖数：2

It's funny how much time a simple problem can waste!


A post just to warn others ....

I spent the last three days trying to figure out why I could not get Moodle set up on a server running windows server 2003, IIS (6) and SQL server 2005. I had experimented with a VMware instace running Windows XP, IIS and SQL server 2005 Express. My actual install just wouldn't work though. When I got to the part that sets up the DB and DB connections, it just wouldn't work ..... this error kept coming up:

PHP has not been properly configured with the MSSQL extension so that it can communicate with SQL*Server. Please check your php.ini file or recompile PHP.

Head scratching and searching to no avail ... Then ... after three days, one last check the version of PHP. I had upgraded to php 5.2.0 just released. php_dblib.dll used for the database connection is compiled from the php_5_1 branch.

Hope this helps someone else!


平均分： -
回复Dave van Suilichem

Re: Moodle 1.7 on Server 2003 with IIS and MSSQL

Eric Henson -
Dave,

I am currently in the process of configuring a SuSE Linux server for Moodle 1.7 and use an external Microsoft SQL Server 2005 for its database. You might want to check out the following links because there are known issues with Moodle using the default PHP to MSSQL connector that comes in PHP.

http://docs.moodle.org/en/Installing_MSSQL_for_PHP
http://docs.moodle.org/en/Development:XMLDB_problems#MSSQL.2C_PHP.2C_UTF-8_and_UCS-2

Its been recommended to use either ODBTP or FreeTDS PHP to MSSQL connectors with a Moodle install. Currently, I am planning to use ODBTP unless somebody has a good reason to use one or the other.

Good luck on your install,

Eric

平均分： -