The Definitive Guide to SIMS.net, Moodle and LDAP Integration

[kieran8055]

tried:

Invalid object name 'sys.databases'.

[penfold_99]

tried:

Invalid object name 'sys.databases'.

What version of ms sql server are you running?

[kieran8055]

On Admin Server Its MSSQL 2005

[CyberNerd]

try:
select * from master.dbo.sysdatabases

[kieran8055]

tried:
select * from master.dbo.sysdatabases

It displays 5 rows:

with file name as

d:\sql2000\MSSQL\data\XXXX

[CyberNerd]

The beginning of that row is the database name. our is SIMS. there are other rows such as the sample database "AdventureWorks".

if you then do

1> use dbname
2> select * from mdl_enrolment_v1_0
3> go

where dbname is the name of the database, it should pullout a load of info. if it doesn't then penfold may hava an idea

[kieran8055]

Still no joy........

[kieran8055]

well i have check the network configuration for SQL Server (sims), protocol for sims and TCP/IP is enabled and dynamic port is " 1414 ".

I have changed the freetds and connected again i can use sims database but it says mdl_enrolment_v1_0 is invalid object name.

[penfold_99]

tried:
select * from master.dbo.sysdatabases

It displays 5 rows:

with file name as

d:\sql2000\MSSQL\data\XXXX

I think your connecting to the wrong port.
You are searching a MS SQL 2000 Server not MS SQL 2005 Server.
Change the port to 1427 and see if that works.

[kieran8055]

Hi All,

At last i have managed to connect to Sims Server ( instance ADMINSERVER\SIMS) actually it tcp\ip was enabled on 1414 port.

Well i can connect to mssql server and i can access sims database but when i try select mdl_enrolment_v1_0 table, it says mdl_enrolment_v1_0 invalid object.

Any suggestions,

Thanks :0)

[penfold_99]

the enrolement view is created after the enrolement plugin is configured.

remove the enrolment plugin and reinstall and configure, then it should work.

[kieran8055]

Well Penfold sorry to trouble you again,

The following steps i have done to integrate SIMS2MOOLDE ( as i am intrested in only Timetable block):


1. Installed FreeTDS on ubuntu 8.04lts ( configured freetds.conf ).
2. Created Moodle SIMS.net Course template.
3. Downloaded SIMS2Moodle - Enrolment Plug-in and copied to enrol folder (/var/www/moodle/enrol).
4. configured sims server settings on admin/enrol page:
5. downloaded the Moodle_sims.net _timetable_block, copied to (/var/www/moodle/blocks) and configured the block.

Is that any thing am i missing.

I have uninstalled the enrolment plug-in an reinstalled, i can connect to sims database but to mdl_enrolment_v1_0 object, says invalid object.


Any suggestions,

Thanks

[penfold_99]

Well Penfold sorry to trouble you again,

The following steps i have done to integrate SIMS2MOOLDE ( as i am intrested in only Timetable block):


1. Installed FreeTDS on ubuntu 8.04lts ( configured freetds.conf ).
2. Created Moodle SIMS.net Course template.
3. Downloaded SIMS2Moodle - Enrolment Plug-in and copied to enrol folder (/var/www/moodle/enrol).
4. configured sims server settings on admin/enrol page:
5. downloaded the Moodle_sims.net _timetable_block, copied to (/var/www/moodle/blocks) and configured the block.

Is that any thing am i missing.

I have uninstalled the enrolment plug-in an reinstalled, i can connect to sims database but to mdl_enrolment_v1_0 object, says invalid object.


Any suggestions,

Thanks

The timetable block relise on the enrolment plugin for the settings to connect to the database this doesn't have to be enabled.

Have the views been created for mdl_student_timetable_v1_0 and mdl_staff_timetable_v1_0?

how are you getting this error "mdl_enrolment_v1_0 object, says invalid object"?

[kieran8055]

No i havent created any views ( like mdl_student_timetable_v1_0 and mdl_staff_timetable_v1_0).

When i am testing using

tsql -H XX.XX.XX.XX -p 1414 -U sa -P sapassword

> use sims
> select * from mdl_enrolment_v1_0
> go
error: Invalid object name.

I have missed out Section 1. in your documentation( SIMS2AD) because i am intrested in only SIMS2MOODLE integration.

Thanks

[penfold_99]

No i havent created any views ( like mdl_student_timetable_v1_0 and mdl_staff_timetable_v1_0).

these should be automatically created on install of the timetable block.

Have a look in SQl Server 2005 Management Studio and see if there are any views with the prefix mdl_