Moodle, SIMS and Windows

[apeo]

Those of you out there that export information using the commandreporter and import the data into Moodle, can i ask how you import the data into Moodle?

[apeo]

Ok I've been playing with this quite a bit now and im currently testing CyberNerds solution but I've hit a wall. It seems that moodle cant talk to my MS Sql server and the only error i can find is as follows:

 

[ENROL_DB] Could not make a connection

 

Any ideas?

[CyberNerd]

have you done this?

Installing MSSQL for PHP - MoodleDocs

 

edit: to clarify, the moodle database can (and should) stay in mysql, but you need to set up the freetds and phpmssql to be able to get the connection to the SIMS server

[apeo]

Ok I've made changes to php config but we run apache 2.2 on a windows 2003 server. Php is also installed. Same error comes up.

[apeo]

Man this is frustrating, I've gotten to the state now that php no longer reports an error but i dont think any courses are being autocreated. Im not sure exactly what I'm suppose see really but i dont think its working, only now its not even giving me any errors.

 

I found out (with the help of penfold_99) that i couldnt connect to the sql server using mssql_connect and it was down to ntwdblib.dll. This now works but moodle still didnt. I messed around with the config abit and found that if i state the host in the following format it stops giving errors:

 

Hostname,port i.e. ServerName,1433
instead of Hostname:Port i.e. ServerName:1433

 

The reason i used ',' instead of ':' is that mssql_connect host is stated in that format but mssql_pconnect uses the ':' format of defining port. mssql_pconnect doesnt work at the moment.

 

Any ideas... anything at all..

Edited January 8, 2009 by apeo

[apeo]

It works!! I think... As stated above putting in , does actually work but what was failing when it checked the idnumber with (in my case) adno. I found that it was expecting a 6 character variable of type char and i had only defined 4 i.e. adno in sims is something like 001234 and you have to specify it as that or it wont match (stupid me). It now auto creates all the courses, the only thing i have to sort out is that when you click on the course for the first time, 'Could not add a new course module to the course' is stated at the top. Dont really think this is major as it does what i think its supposed to now.. FINALLY!.

[penfold_99]

It works!! I think... As stated above putting in , does actually work but what was failing when it checked the idnumber with (in my case) adno. I found that it was expecting a 6 character variable of type char and i had only defined 4 i.e. adno in sims is something like 001234 and you have to specify it as that or it wont match (stupid me). It now auto creates all the courses, the only thing i have to sort out is that when you click on the course for the first time, 'Could not add a new course module to the course' is stated at the top. Dont really think this is major as it does what i think its supposed to now.. FINALLY!.

 

Glad you have got it up and running.

[apeo]

Thanks for all your help mate. Funny I went from knowing nothing about Moodle, PHP and Apache to knowing enough to bash it to get it work .

 

Now i have to look at what you've done and match it with our needs.