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

Edited January 8, 2010 by Danlewis3
adding

[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.