Moodle/Sims - Timetable and course integration HELP

[Danlewis3]

Hello All,

I am having difficulty setting up the Moodle-SIMS integration

We already have all users set up in active directory. If i am led to believe correct the employeeid is what needs to be set to join LDAP and SIMS

What i have done is as follows

Using sql 2005, php-cgi.exe on iis

Moodle Install and can connect to SIMS
LDAP works as i have logged in as some users
i have manually set the employeeid on some accounts
When i login as the user and click on the timetable it says it can't connect to sims.net

Enrolment settings

SIMS.net Server Settings
enrol_dbtype = mssql
enrol_dbhost = 192.168.16.17\sims2005
enrol_dbport = 1427
enrol_dbuser = [user]
enrol_dbpass = [SA Password]
enrol_dbacyear = 2009 (or current academic year)

Connect to mssql page

<?php
$link = mssql_connect('192.168.16.17:1427\sims2005', '[user]', '[password]');
if(!$link) {
echo'Could not connect';
die('Could not connect: ' . mssql_error());
}
echo'Successful connection';
mssql_close($link);
?>

And that connects fine.

So any ideas anyone?

Thanks

[Danlewis3]

moodle config file

<?php /// Moodle Configuration File

unset($CFG);

$CFG->dbtype = 'mssql_n';
$CFG->dbhost = '192.168.16.17\sims2005';
$CFG->dbname = 'moodle';
$CFG->dbuser = '[user]';
$CFG->dbpass = '[password]';
$CFG->dbpersist = false;
$CFG->prefix = 'mdl_';

$CFG->wwwroot = 'http://portal/moodle';
$CFG->dirroot = 'C:\Inetpub\wwwroot\moodle';
$CFG->dataroot = 'C:\Inetpub/moodledata';
$CFG->admin = 'admin';

$CFG->directorypermissions = 00777; // try 02777 on a server in Safe Mode

$CFG->passwordsaltmain = 'k?bg#3{gQk)pd_v^g)49-ld5%)';

require_once("$CFG->dirroot/lib/setup.php");
// MAKE SURE WHEN YOU EDIT THIS FILE THAT THERE ARE NO SPACES, BLANK LINES,
// RETURNS, OR ANYTHING ELSE AFTER THE TWO CHARACTERS ON THE NEXT LINE.
?>

[Danlewis3]

freetds.conf

[global]
host = 192.168.16.17 (ip of the MSSQL server)
port = 1427
client charset = UTF-8
tds version = 8.0
text size = 20971520

[Danlewis3]

Right i have just checked for the views that should install onto the 2005sql

CREATE VIEW mdl_student_timetable_v1_0
AS SELECT TOP (100) PERCENT sims.rpt_vix_timetable.period_name, sims.rpt_vix_timetable.class_name,sims.stud_via_st udent_browse.unique_pupil_no,sims.rpt_vix_timetabl e.staff_initials, sims.rpt_vix_timetable.room_name
FROM sims.stud_via_group_members INNER JOIN sims.curr_class_period ON sims.stud_via_group_members.base_group_id = sims.curr_class_period.base_group_id
INNER JOIN sims.stud_via_student_browse ON sims.stud_via_group_members.person_id =
sims.stud_via_student_browse.person_id INNER JOIN sims.rpt_vix_timetable ON sims.curr_class_period.class_period_id = sims.rpt_vix_timetable.class_period_id
WHERE (sims.curr_class_period.person_id IS NOT NULL) AND (sims.rpt_vix_timetable.end_date > GETDATE()) AND (sims.stud_via_group_members.start_date < GETDATE()) AND (sims.stud_via_group_members.end_date > GETDATE())
ORDER BY sims.rpt_vix_timetable.period_name

This one is erroring when i try to create it manually
Msg 102, Level 15, State 1, Procedure mdl_student_timetable_v1_0, Line 2
Incorrect syntax near '.'.

this table dont exist sims.rpt_vix_timetable.period_name,

[penfold_99]

@Danlewis3

It looks like Capita have modified the database. The version of SIMS and Moodle Integration you are using is not supported.

Both Myself and webanywhere offer supported versions of SIMS and Moodle Integration. If you would like some more information PM me.

Sorry i couldn't be more help.

[Danlewis3]

Thanks for the info, i have pm'd you.

[penfold_99]

Thanks for the info, i have pm'd you.

I have replied.