Databases: mssql database

Databases: mssql database

by leslie nielson -
Number of replies: 3

hi

im trying to get moodle working with mssql instead of mysql, i got the connection working and he has created the first tables in the database, however when i get to the variables page (http://localhost/admin/config.php) he gives the following errors for all config options.

Notice: Undefined property: stdClass::$name in c:\Inetpub\wwwroot\lib\setup.php on line 87

Notice: Undefined property: stdClass::$name in c:\Inetpub\wwwroot\lib\setup.php on line 88

Notice: Undefined property: stdClass::$value in c:\Inetpub\wwwroot\lib\setup.php on line 88

When i save them he will just return to the same page with the same erros again. Any help will be appreciated.

im running

  • windows 2003
  • iis6.0
  • mssql enterprise edition  withsp3

i have inlcuded the config files.


Average of ratings: -
In reply to leslie nielson

Re: Databases: mssql database

by Zbigniew Fiedorowicz -
Moodle does not support mssql as the database backend.  You would need to write extensive modifications of the sql syntax used in  Moodle database code to enable mssql support in Moodle.  Somebody did write such modifications last year to version 1.2 of Moodle, but has not updated it to more recent versions.  See the following discussion for details: http://moodle.org/mod/forum/discuss.php?d=7957