+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Lesson Monitor - ODBC Error in Technical; We are getting the following error on several machines throughout the school when trying to use Lesson Monitor It completes ...
  1. #1

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498

    Lesson Monitor - ODBC Error

    We are getting the following error on several machines throughout the school when trying to use Lesson Monitor

    It completes database syncronisation, but as soon as someone tries to bring up a class register the following error is generated

    Code:
    [Microsoft][ODBC Microsoft Access driver]Data type mismatch in criteria expression
    Anyone know what this is and how to resolve it?

  2. #2

    Join Date
    May 2006
    Location
    manchester
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Lesson Monitor - ODBC Error

    Dont know what the error is craig, have you tried copying the lessonmonitor.ini from a working machine to a broken one. This was an issue some time ago. Other than that, copy the whole sims.net folder from a working computer to another. Not an ideal solution but usually works in desperate situations.

  3. #3

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498

    Re: Lesson Monitor - ODBC Error

    Went thru all that - have now found what it is!!

    Salford's oh so wonderful ScriptLogic is setting the local Date format to .. M/D/Y !!

    SIMS, naturaly want the format to be DD/MM/YY

    SL is overriding any changes i make locally and putting it back to M/D/Y again :banghead: :banghead:

  4. #4

    Join Date
    May 2006
    Location
    manchester
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Lesson Monitor - ODBC Error

    HAHAHA, Im sure the LEA are meant to make things easier?!?!?!?!?

  5. #5

    Join Date
    Jun 2006
    Location
    Isle of Wight
    Posts
    9
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Lesson Monitor - ODBC Error

    there is a file in the local program~sims~sims.net folder lesson monitor.mdb delete this and this should cure your problem
    we have had lesson monitor for 2 years and it has loads of problems

  6. #6
    jumpinjamez's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    253
    Thank Post
    133
    Thanked 23 Times in 15 Posts
    Rep Power
    27

    Re: Lesson Monitor - ODBC Error

    Quote Originally Posted by whatwherewhen
    there is a file in the local program~sims~sims.net folder lesson monitor.mdb delete this and this should cure your problem
    we have had lesson monitor for 2 years and it has loads of problems
    Thanks for that, we are going live September reg and lessons. 8O

    The trials we have run seem to go ok but that is only for Registration and on two year groups.

  7. #7

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,401
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    Re: Lesson Monitor - ODBC Error

    This Lesson Monitor.mdb file causes lots of problems for us. So much so we have a VBScript scheduled every night to run round all the workstations deleteing the file if it exists, before they're all shut down.

SHARE:
+ Post New Thread

Similar Threads

  1. LEsson Monitor 7 ram hog
    By mark in forum MIS Systems
    Replies: 3
    Last Post: 24th September 2007, 11:04 AM
  2. SIMS / Lesson Monitor Error
    By Gatt in forum MIS Systems
    Replies: 15
    Last Post: 13th September 2007, 07:20 AM
  3. Lesson Monitor for pe
    By Jamie_a in forum Educational Software
    Replies: 7
    Last Post: 23rd January 2007, 03:17 PM
  4. Lesson Monitor Error
    By Gatt in forum MIS Systems
    Replies: 14
    Last Post: 6th October 2006, 07:41 AM
  5. SIMS/Lesson Monitor Error
    By Gatt in forum MIS Systems
    Replies: 7
    Last Post: 12th May 2006, 10:43 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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