I am trying to get the database enrolment to work so that students will automatically have their courses listed for them. The external database I am using is our main college student database which is on a separate server to Moodle and uses Microsoft SQL 2000.
I have the correct fields listed (which do match the moodle fields) and I have provided a username and password to moodle that has sufficient access to the MSSQL table. However, no matter how much I try I can not get it to work. My test student logs on and his course isn't listed.
Can anybody please help, I have tried numerous things; security, network problems, dll files all to no avail.
I would appriecate any suggestions as this is an important feature that we would like to get working.