Nice one, my school has only just started looking into moodle and this would sure help integration.
I've got a php script:
But I am receiving this error:PHP Code:
$server = 'SERVERNAME\INSTANCE';
$link = ($server, 'sa', 'SA PASSWORD');
Do I need to do anything on the MSSQL server to ensure other machines can connect to it? What is going wrong?!Code:Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: SERVERNAME\INSTANCE in /var/www/test.php on line 5
(or 1433)Code:telnet xxx.xxx.xxx.xxx 1427
if you can't connect it is an MSSQL issue.
If you can connect, then try tsql.
Download the source and compile it, then try tsql - it should install in /usr/local/bin/tsql and the config will be here /usr/local/etc/
extract, configure,compile, installCode:wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
Code:tar xzvf freetds-stable.tgzCode:cd freetds-0.82Code:./configureCode:make && sudo make install
Tried telnet - can't connect. Any steps to resolve this?
Hightower (29th January 2009)
Thank you so much! Lets see where I get stuck now ;
Ok, here we go again. TestPupil now has assigned courses of 10x/Ma5,10c/En1 etc etc even though them courses do not exist - so I'm guessing these are being pulled somehow from the DB - but the timetable is still blank.
Is this an easy fix? Am I getting closer?
10x/Ma5,10c/En1 etc sound suspiciously like they could have come from the SIMS database.
Penfold_99 is usually on hand for sims timetable problems.
Ok, thanks CyberNerd. I await the help of the shopkeeper
Just as an after thought - the connection is working somewhere as it has created the course as mentioned above, and enrolled the user on them.
I'm wondering if I've installed the blocks correctly - is there any special method to it? Or is it a case of wacking them on the server as is and away we go.
Could my problem be caused by the moodle plugin I downloaded? Have I installed it correctly? Here's what I did - was this correct?
1) Downloaded from Moodle
2) Uploaded the 'simstimetable' folder in mod to the mod folder on my server
3) Uploaded the 'simstimetable' folder in blocks to the blocks folder on my server
4) Went to the admin homepage to complete install - no errors given
5) Added College timetable block to homepage
Get a blank timetable. Are more steps than this required?
Also, if I click the 'Configuration' button on the College Timetable block (as admin of course) I get:
This block has not been implemented correctly and thus cannot provide a configuration interface.
This doesn't sound normal - what have I done wrong. Argghhhhh!
There are currently 1 users browsing this thread. (0 members and 1 guests)