Jump to content

kieran8055

Members
 View Profile  See their activity

  • Posts

    81

  • Joined

  • Last visited

 Content Type 

Everything posted by kieran8055

  1. kieran8055
    There are no views created on Sims database called " mdl_student_timetable_v1_0 and mdl_staff_timetable_v1_0 ". Thanks
  2. 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
  3. 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
  4. kieran8055
    Hi i ve already installed for php5-mysql, Actually i wanted is to install php-mssql to work with FreeTDS0.82 to pull up timetable from sims. Thanks
  5. 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)
  6. kieran8055
    Can any one tell me how to install Php-mssql on ubuntu 8.04lts. And aslo any configuration (php-mssql) need to be done for moodle to talk to mssql server to retrive timetable from sims server. Cheers :0)
  7. 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.
  8. kieran8055
    Still no joy........
  9. kieran8055
    tried: select * from master.dbo.sysdatabases It displays 5 rows: with file name as d:\sql2000\MSSQL\data\XXXX
  10. kieran8055
    On Admin Server Its MSSQL 2005
  11. kieran8055
    tried: Invalid object name 'sys.databases'.
  12. kieran8055
    ya there is a file (freeetds.conf) in /usr/local/etc The following are the file settings: [global] host = XX.XX.XX (ip of the MSSQL server) port = 1433 client charset = UTF-8 tds version = 8.0 (or 8.0 if using FreeTDS 0.82 or later) text size = 20971520
  13. kieran8055
    Hi Penfold Yes i 've done all bits , I am running on " ubuntu 8.04lts server ". 1. I have installed FreeTDS0.82 2 php5-sybase (for php-mssql)
  14. kieran8055
    when i tried :- select * from mdl_enrolment_v1_0 Msg 911, Level 16, State 1, Server ABCServer, Line 1 Could not locate entry in sysdatabases for database 'sims'. No entry found with that name. Make sure that the name is entered correctly.
  15. kieran8055
    its already version = 8.0
  16. kieran8055
    Well CyberN.. I can connect using TDSVER=8.0 tsql -S XX.XX.XX.XX (or server name) -U sa But not through tsql -S XX.XX.XX.XX (or server name) -U sa error: Msg 20017, Level 9, State -1, Server OpenClient, Line -1 Unexpected EOF from the server Msg 20002, Level 9, State -1, Server OpenClient, Line -1 Adaptive Server connection failed There was a problem connecting to the server.
  17. kieran8055
    Well Dan, I have added user employeeID manually from adsiedit for 5 users. Though employeeID field is not visible but still field value is searchable. And simultaneously we are testing script on virtual machine. Cheers
  18. kieran8055
    Blank page of School timetable, when we click on my timetable noting comes up just a blank page. I have tested 1. telnet XX.XX.XX.XX 1433 connected. 2. isql Error could not SQL connect Any help or suggestions Please. Cheers
  19. kieran8055
    In Our AD employeeID field doesnot appear. Any suggestions Please. Thanks.
  20. kieran8055
    Hi Dan, Well we are trying to integrate sims with moodle, firstly we should have employeeID in AD for each account and should set to UPN for student and Staff code for staff. This is to link AD users with SIMS.net, As far i think when account is created on SIMS.net it wont create on AD account automatically. Rest all is in the moodle doucmentation. Well we got stuck at adding employeeID field to AD profile. Cheers :0)
  21. kieran8055
    Can you give me some details on Access Manager Please, we just wanted to pull Timetable from sims.net onto moodle, where as documents for SIMS2AD - Access Manager says to control student access to an education establishments computer network via sims.net. Is that all the thing in the Contents(from documentation) as to be done to pull timetable from sims.net? Thankyou very.
  22. kieran8055
    Hi Penfold, What i wanted to tell you is our SIMS.net server is on different domain and our Network users are on different domain. Our moodle LDAP Caputure is authenticated to Network users Domain. Any Suggestions,
  23. kieran8055
    just wanted to know whether i works with LDAP Capture. Thanks
  24. kieran8055
    Can we integrate it with LDAP Capture, cause we are using LDAP Capture for authentication. Cheers
  25. kieran8055
    Hi FN-GM Make sure display name is same as user login in Active Directory.. cheers
×
×
  • Create New...