Poll: Is this documentation helpful?

+ Post New Thread
Page 4 of 9 FirstFirst 12345678 ... LastLast
Results 46 to 60 of 131
Virtual Learning Platforms Thread, The Definitive Guide to SIMS.net, Moodle and LDAP Integration in Technical; tried: Invalid object name 'sys.databases'....
  1. #46

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    tried:

    Invalid object name 'sys.databases'.

  2. #47
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    994
    Thank Post
    60
    Thanked 166 Times in 118 Posts
    Rep Power
    68
    Quote Originally Posted by kieran8055 View Post
    tried:

    Invalid object name 'sys.databases'.
    What version of ms sql server are you running?

  3. #48

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    On Admin Server Its MSSQL 2005

  4. #49


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    340
    try:
    select * from master.dbo.sysdatabases

  5. #50

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    tried:
    select * from master.dbo.sysdatabases

    It displays 5 rows:

    with file name as

    d:\sql2000\MSSQL\data\XXXX

  6. #51


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    340
    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

    Code:
    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

  7. #52

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Still no joy........

  8. #53

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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.

  9. #54
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    994
    Thank Post
    60
    Thanked 166 Times in 118 Posts
    Rep Power
    68
    Quote Originally Posted by kieran8055 View Post
    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.

  10. #55

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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)

  11. #56
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    994
    Thank Post
    60
    Thanked 166 Times in 118 Posts
    Rep Power
    68
    the enrolement view is created after the enrolement plugin is configured.

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

  12. Thanks to penfold_99 from:

    kieran8055 (5th May 2009)

  13. #57

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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

  14. #58
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    994
    Thank Post
    60
    Thanked 166 Times in 118 Posts
    Rep Power
    68
    Quote Originally Posted by kieran8055 View Post
    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"?

  15. #59

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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

  16. #60
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    994
    Thank Post
    60
    Thanked 166 Times in 118 Posts
    Rep Power
    68
    Quote Originally Posted by kieran8055 View Post
    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_

  17. Thanks to penfold_99 from:

    kieran8055 (5th May 2009)



SHARE:
+ Post New Thread
Page 4 of 9 FirstFirst 12345678 ... LastLast

Similar Threads

  1. [SIMS] SIMS.Net Active Directory Integration
    By robknowles in forum MIS Systems
    Replies: 29
    Last Post: 4th October 2011, 03:54 PM
  2. Moodle Error log for LDAP integration
    By apearce in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 19th November 2008, 01:36 PM
  3. Cancelled Intro Guide To Sims.net Thursday 20th Dec 10:30
    By russdev in forum General EduGeek News/Announcements
    Replies: 8
    Last Post: 13th March 2008, 10:31 PM
  4. Moodle LDAP integration
    By zag in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 13th March 2008, 04:03 PM
  5. Moodle/SIMS integration
    By localzuk in forum Virtual Learning Platforms
    Replies: 23
    Last Post: 7th December 2007, 10:18 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •