+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, [FMS] - FMS Database Selector & SS_FMS_Companies.ini in Technical; Do any of you guys use the FMS Database Selector in school? If so, where do you store your 'SS_FMS_Companies.ini' ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0

    [FMS] - FMS Database Selector & SS_FMS_Companies.ini

    Do any of you guys use the FMS Database Selector in school? If so, where do you store your 'SS_FMS_Companies.ini' file? We store ours on the S: drive but are seeing an increase in the number of calls where all of a sudden, both FMS databases entries (one for the old school system & one for the new academy system) point to the same database! We then have to manually change the SS_FMS_Companines.ini file back to opoint the changed entry to the original database. I thought that maybe I could just make the ini file read only, but FMS then complains it can't write to the SS_FMS_Companies.ini file, which baffles me as I don't know why the ini file needs to be written to? I would have assumed that it's just being read? Can anyone shed some light on this?

  2. #2

    DaveP's Avatar
    Join Date
    Oct 2006
    Location
    Can't talk now: The mother-ship is calling!
    Posts
    8,876
    Thank Post
    351
    Thanked 1,285 Times in 877 Posts
    Blog Entries
    4
    Rep Power
    1128
    Which operating system are your SIMS clients on?

    I ask because we had exactly the same issue with Windows XP: Pro: 32 Bit: SP3 but the problem went away when we moved them to Windows 7 Pro: SP1: 64 Bit without me having to do any work at all.

    I never did find out what was causing it.

  3. Thanks to DaveP from:

    Rawns (18th June 2012)

  4. #3
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by DaveP View Post
    Which operating system are your SIMS clients on?

    I ask because we had exactly the same issue with Windows XP: Pro: 32 Bit: SP3 but the problem went away when we moved them to Windows 7 Pro: SP1: 64 Bit without me having to do any work at all.

    I never did find out what was causing it.
    I think most of them are XP devices. There have been a few over a long period of time, so unsure if any were Win 7 devices.

  5. #4

    DaveP's Avatar
    Join Date
    Oct 2006
    Location
    Can't talk now: The mother-ship is calling!
    Posts
    8,876
    Thank Post
    351
    Thanked 1,285 Times in 877 Posts
    Blog Entries
    4
    Rep Power
    1128
    Quote Originally Posted by Rawns View Post
    I think most of them are XP devices. There have been a few over a long period of time, so unsure if any were Win 7 devices.
    Is it worth you trying a station on Windows 7?

    [Reminder: We went from XP 32 Bit to Windows 7: 64 Bit]

  6. Thanks to DaveP from:

    Rawns (18th June 2012)

  7. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by DaveP View Post
    Is it worth you trying a station on Windows 7?

    [Reminder: We went from XP 32 Bit to Windows 7: 64 Bit]
    Thank's for the suggestion, I doubt the schools affected will want to re-image devices to Win 7 just to fix this.

  8. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    See my post on SupportNet

  9. #7

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,139
    Thank Post
    403
    Thanked 622 Times in 568 Posts
    Rep Power
    181
    Do you have a link to that post Matt? This is happening here.

  10. #8

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,139
    Thank Post
    403
    Thanked 622 Times in 568 Posts
    Rep Power
    181
    Haha! Fixed the blasted thing. The local FMSConnect.ini on the machine was a redirect one, which of course doesn't work with the database selector.

  11. #9

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,945
    Thank Post
    583
    Thanked 1,017 Times in 783 Posts
    Blog Entries
    15
    Rep Power
    464
    Any information/details on this? This has just started happening to us out of the blue. Been working fine since it was all done in September, then literally 45 minutes ago, this happens and both shortcuts point to the same database! Supportnet link would be useful

  12. #10
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by synaesthesia View Post
    Any information/details on this? This has just started happening to us out of the blue. Been working fine since it was all done in September, then literally 45 minutes ago, this happens and both shortcuts point to the same database! Supportnet link would be useful
    We've now taken to storing this file locally on each FMS machine. Seems to eradicate the issue of a file being somehow modified.

  13. #11

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,945
    Thank Post
    583
    Thanked 1,017 Times in 783 Posts
    Blog Entries
    15
    Rep Power
    464
    That would be a sound solution but I don't quite understand enough about how the FDS works to implement it.
    I found the relevant file thanks to this thread (SS_Companies_FMS.ini or something) in an odd location (S:\SIMS\FMS) and for reasons unknown the academy DB had been changed to the school's one. call logged with Capita to investigate why that happened in the first place, although I'm even more concerned about how it happened with nothing changed whatsoever. Wondering if Solus 3 had something to do with it. For now I've changed that file and fmsconnect.ini but worried this is going to happen again.

  14. #12
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by synaesthesia View Post
    That would be a sound solution but I don't quite understand enough about how the FDS works to implement it.
    I found the relevant file thanks to this thread (SS_Companies_FMS.ini or something) in an odd location (S:\SIMS\FMS) and for reasons unknown the academy DB had been changed to the school's one. call logged with Capita to investigate why that happened in the first place, although I'm even more concerned about how it happened with nothing changed whatsoever. Wondering if Solus 3 had something to do with it. For now I've changed that file and fmsconnect.ini but worried this is going to happen again.
    Sorry if this covers a bit of what you already know!

    FDS allows access to multiple databases. Each FMS client has FDS but is only used in multiple FMS database environments. When ran for the first time, you configure it with LA and DfE number, point it to the SS_FMS_Companies.ini (which contains details about the FMS databases you have) and point it to where the Finance.exe is. Once configured, user can either load into the appropriate FMS databases through FDS, or use it to create direct desktop shortcuts. I think in the tools menu you can reconfigure it. Simply copy the SS_FMS_Companies.ini into the local C:\Program Files\SIMS\FMSSQL folder, run FDS and go to the tools menu and configuration (going from memory here, may be different but sure you CNN find it!). Just amend the location of the SS_FMS file to point to the local one rather than the one on the S: drive.

    Doubt SOLUS3 is to blame on this one as it does not support remote configuring of FDS! We believe it happens when users either try to open other FMS databases when they already have FMS open, or when multiple users access different databases at the same time, but we've not tested it.

  15. #13

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,945
    Thank Post
    583
    Thanked 1,017 Times in 783 Posts
    Blog Entries
    15
    Rep Power
    464
    Cheers. I vaguely remember setting it up originally. Wonder what Capita will come back with.

    My train of thought on Solus3 was that you specify the default fmsconnect.ini in it, wasn't sure if it enforced that (but believe that's just on initial install of FMS).

    Might have a play about with a test setup and see if I can recreate it. Quite a pain when it happens! In the meantime I'll just make sure that the relevant finance staff have different username and passwords for each one (1. they should anyway and 2. I'm sure they do anyway, as this is how it was flagged up). Otherwise it's hard to tell, even when logged into the "wrong database" it very clearly states the correct database name at the top. I'm rather annoyed this hasn't been long patched since you first brought it up well over a year ago!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] FMS Incompatible Database
    By jlucas in forum MIS Systems
    Replies: 6
    Last Post: 1st October 2011, 01:07 AM
  2. [SIMS] Finance Database Selector
    By Rawns in forum MIS Systems
    Replies: 1
    Last Post: 5th May 2011, 09:53 AM
  3. [SIMS] SIMS FMS - Borland Database Engine
    By adamchapman in forum MIS Systems
    Replies: 8
    Last Post: 17th November 2010, 12:33 PM
  4. FMS: unsyncd database
    By Oops_my_bad in forum MIS Systems
    Replies: 3
    Last Post: 31st March 2010, 09:45 PM
  5. HELP with FMS installation - fmsconnect.ini??
    By sidewinder in forum MIS Systems
    Replies: 5
    Last Post: 4th October 2007, 11:10 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
  •