Poll: Is this documentation helpful?

+ Post New Thread
Page 3 of 9 FirstFirst 1234567 ... LastLast
Results 31 to 45 of 131
Virtual Learning Platforms Thread, The Definitive Guide to SIMS.net, Moodle and LDAP Integration in Technical; Blank page of School timetable, when we click on my timetable noting comes up just a blank page. I have ...
  1. #31

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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
    Last edited by kieran8055; 1st May 2009 at 11:49 AM.

  2. #32

    Join Date
    Jul 2007
    Location
    West Sussex
    Posts
    264
    Thank Post
    35
    Thanked 11 Times in 11 Posts
    Rep Power
    16
    Hi Kieran,

    wow you're ahead of me.

    I'm still getting the scripting error with employee field.

    Did you not get the scripting error?

    Regards
    Dan

  3. #33

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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
    Last edited by kieran8055; 1st May 2009 at 12:10 PM.

  4. #34


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by kieran8055 View Post
    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
    you should bea ble to use tsql to test a basic connection

    Code:
    tsql -S x.x.x.x -U sa
    x.x.x.x is the ip of the sims/cmis server
    should prompt for a password for the sa account

  5. Thanks to CyberNerd from:

    kieran8055 (1st May 2009)

  6. #35

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

  7. #36


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    our /etc/freetds.conf file looks like this:

    Code:
    [global]
    	host = x.x.x.x
    	port = 1427
    	client charset = UTF-8
    	tds version = 7.0
    	text size = 20971520
    maybe change to version 8

  8. #37

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    its already version = 8.0

  9. #38


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    all I did was install

    freetds-0.64-1.el5.rf.x86_64.rpm
    php-mssql-5.1.6-4.el5.x86_64.rpm

    (on centos/RHEL 5.3 64bit)

    changed the config file /etc/freetds.conf to

    Code:
    [global]
    	host = x.x.x.x
    	port = 1427
    	client charset = UTF-8
    	tds version = 8.0
    	text size = 20971520
    (8.0 also works here)

    then login
    Code:
    tsql -S x.x.x.x -U sa -P PASSWORD
    and run
    Code:
    1> use sims
    2> select * from mdl_enrolment_v1_0
    3> go
    (where sims is the dbname and mdl_enrolment_v1_0 is the table/view)

    this should return a bunch of data.

  10. #39

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

  11. #40
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    @kieran8055

    Have you done all the other bits in CyberNerd's post?

    What OS are you running on?

  12. #41

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

  13. #42


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    does this file exist?
    ~/.freetds.conf
    could it be overriding the global /etc/freetds.conf
    maybe try creating it.

  14. #43

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

  15. #44


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by kieran8055 View Post
    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.
    ok, I see your connecting. this just says that you database is called something other than 'sims' - you need to fins the name of your sims database.

    if you do

    Code:
    select * from sys.databases
    go
    it should display all the databases on your mssql

  16. #45


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    i'm wondering if it gets overriden by a file in you userpath?
    /home/username/.freetds.conf

    a google of that errormessage
    install pymssql and how to deal with DB-Lib error message 20009, severity 9 PyYou Weblog

    So I use an another environnement variable to fix that :

    export TDSVER=7.0

    And miracle , everything work with tsql. So I force version of tds in my ~/.freetds.conf in global section as this

    [global]
    tds version = 7.0

    And after that everything is ok in python. Yahoo!!. I hope that ticket will be useful for you.
    Last edited by CyberNerd; 1st May 2009 at 02:50 PM.

SHARE:
+ Post New Thread
Page 3 of 9 FirstFirst 1234567 ... LastLast

Similar Threads

  1. [SIMS] SIMS.Net Active Directory Integration
    By robknowles in forum MIS Systems
    Replies: 29
    Last Post: 4th October 2011, 02:54 PM
  2. Moodle Error log for LDAP integration
    By apearce in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 19th November 2008, 12: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, 09:31 PM
  4. Moodle LDAP integration
    By zag in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 13th March 2008, 03:03 PM
  5. Moodle/SIMS integration
    By localzuk in forum Virtual Learning Platforms
    Replies: 23
    Last Post: 7th December 2007, 09: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
  •