+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Nova T4 SQL Link application error in Technical; Hi, I realise T4 is ancient and no longer supported but a few people here still use it so would ...
  1. #1

    Join Date
    Jul 2010
    Posts
    60
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Nova T4 SQL Link application error

    Hi,

    I realise T4 is ancient and no longer supported but a few people here still use it so would just like to see if anyone can help. If not I'll tell my staff to just use T6/sims.

    When someone clicks SQL link in T4 and tries to load student data and timetables they get the following error:

    Could not launch application: error=24

    The user now has a windows 7 32bit machine and it previously worked on XP and still does for other XP users. Nothing else has changed and I've tried running it in compatability mode but still no luck.

    If anyone can help would be great, Thanks.

  2. #2
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,349
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60
    Did you perchance just install Windows 7? And it worked in XP with the same users?

    We had this error and it turned out to be the length of the username and password combination. Basically NovaT uses a really odd method to post to SQL and the string it creates can't be longer than a certain length. 80 chars I believe, which is made up of the %TEMP% path (which in Windows 7 is much longer) and the username and password in Nova-T x2.

    Its in a weird Capita support article somewhere, anyway the fix is to run with a really short username and password in Nova-T

  3. Thanks to Jamo from:

    profit10 (1st October 2012)

  4. #3

    Join Date
    Jul 2010
    Posts
    60
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Yeah installed last week, and they tried to use it this morning. How short a username and password are we talking? At current it's 12 characters total. I'll give it a go nonetheless, cheers.

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    From KB29522 :

    The path of the temp directory, user name and password are too long.

    To find the path of the TEMP dir.

    Select START | RUN type command (NOT cmd) and click OK
    At the DOS Prompt type SET and press enter. The path of the TEMP directory will be in the list
    To change the temp path,
    Right mouse click over the My computer Icon
    Select Properties
    Select Advanced
    Select Environment Variables
    In the system variables set the temp path. e.g. c:\windows\temp
    And in the User variables set the temp path to e.g. c:\windows\temp

    (Please also check the TMP path, which is subject to the same restrictions.)

    (Please note you may need to re-boot the computer for this to become effective)

    The total of (the number of characters of the temp path doubled) and (the user name) and (password) MUST not exceed 80 characters.

    i.e. C:\DOCUME~1\jsmith\LOCALS~1\Temp (=32x2=64) with a SIMS user name of smith.john (=10) and a password of 12345678 (=8) therefore making 82 in total.

  6. Thanks to vikpaw from:

    profit10 (1st October 2012)

  7. #5
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,349
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60
    Quote Originally Posted by vikpaw View Post
    From KB29522 :

    Thats the one!!

    Nova-T4 promotes the following message:
    Just remember that your password should be at least 2 characters and no more than 3.

  8. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I didnt actually think it supported more than 8 anyway, and it's not case sensitive. I remember most people having just their first name as username and then only a numeric password. Shocking

  9. #7

    Join Date
    Jul 2010
    Posts
    60
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thanks guys got it working.

  10. #8

    Join Date
    Jul 2010
    Posts
    60
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    This fix was working fine however I'm now recieving this error. If I change the temp path back, I don't recieve the error. This error is with sims.

    simsfault.jpg

  11. #9

    Join Date
    Jul 2010
    Posts
    60
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Not to worry, got it working. Just needed to give the user permissions for the folder!!

  12. #10
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,349
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60
    I would suggest not changing the %TEMP% path as it is a global change and may affect other software. It is better to get the software working on the current system, than change the system to meet an out of date legacy and no longer supported application.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Nova T4 - error with Proof Print
    By jdhfog in forum MIS Systems
    Replies: 6
    Last Post: 8th March 2012, 06:33 PM
  2. [SIMS] Nova T4 - SQLLink Error
    By Sam_Brown in forum MIS Systems
    Replies: 1
    Last Post: 14th July 2011, 11:34 AM
  3. NOVA-T4 errors
    By randle in forum MIS Systems
    Replies: 6
    Last Post: 29th September 2010, 02:08 PM
  4. [SIMS] NOVA T4 error - Help [Solved]
    By timbo343 in forum MIS Systems
    Replies: 1
    Last Post: 7th June 2010, 09:58 AM
  5. NOVA T application error
    By tannajay in forum MIS Systems
    Replies: 8
    Last Post: 1st May 2008, 09:53 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
  •