+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, FMS database selector.... anyone use it? in Technical; Hi guys been setting up this database selector to allow the school two have two FMS databases. bugger me it ...
  1. #1

    Join Date
    Jan 2011
    Location
    Southampton
    Posts
    30
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    FMS database selector.... anyone use it?

    Hi guys

    been setting up this database selector to allow the school two have two FMS databases. bugger me it looks straight fwd and was until i try and login. i have the "original" FMS database and a "new" blank one. i have installed on 4 machines, which include 2008 sever and 3 Windows7 machines. However no matter which database i try and login to it just loads the original database, apart from on just one of the the 4..... which happens to be the only 32bit machine... any advise chaps or is that my issue... does not work on 64bit

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,145
    Thank Post
    522
    Thanked 2,550 Times in 1,979 Posts
    Blog Entries
    24
    Rep Power
    877
    We use it on 64bit. How are you using it? Can you tell me the process you're using to select the database?

  3. #3

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,250
    Thank Post
    404
    Thanked 630 Times in 575 Posts
    Rep Power
    185
    I installed this onto a 64 Bit the other day and I'm pretty sure it worked. I'll check it out tomorrow. Have you tried copying the config over from the working machine to the other? I'm pretty sure it's just an INI file with the database names in.

  4. #4

    Join Date
    Jan 2011
    Location
    Southampton
    Posts
    30
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    OK well i have the two databases attached and i can access both by editing the ini file. i ran the FMS database selector and completed the steps. it made a master ini file on the SIMS drive, so all can see it, that appears to work as if i change the database name that updates. it works on the one machine, the others ignore the selection and load the original database..

  5. #5

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,250
    Thank Post
    404
    Thanked 630 Times in 575 Posts
    Rep Power
    185
    Something very odd going off, I admit.

    Check your SS_FMS_COMPANIES.INI is correct. Then, try to sign in to a database that isn't your standard one. Then check your SS_FMS_COMPANIES.INI. Ours keeps resetting the database names to be the same, even though they're different companies.

  6. #6

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,250
    Thank Post
    404
    Thanked 630 Times in 575 Posts
    Rep Power
    185
    Ours is doing the exact same. Only loading the first database.

  7. #7

    Join Date
    Jan 2011
    Location
    Southampton
    Posts
    30
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    glad im not alone, that was what it was doing for me at first, changing the ini file to the same database.

    odd it works fine on 32bit machine, but the 64's i just get the same database

  8. #8

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,250
    Thank Post
    404
    Thanked 630 Times in 575 Posts
    Rep Power
    185
    Do you have that INI file on each machine? We point to a shared one on our S:\ drive. It's really odd.

  9. #9

    Join Date
    Jan 2011
    Location
    Southampton
    Posts
    30
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Edu-IT View Post
    Do you have that INI file on each machine? We point to a shared one on our S:\ drive. It's really odd.
    yeah just a shared one on the "S" drive.

  10. #10

    Join Date
    Feb 2013
    Posts
    47
    Thank Post
    11
    Thanked 8 Times in 6 Posts
    Rep Power
    6
    I was experiencing this problem last week on a number of machines. I managed to fix it by finding a machine where it was working properly and copying the entire FMS folder (C:\Program Files\SIMS\FMSSQL) and then using it to overwrite the folder on the faulty machines. Once I had replaced the folder the DB selection started to work properly.

  11. #11

    Join Date
    Jan 2011
    Location
    Southampton
    Posts
    30
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by NewFormz View Post
    I was experiencing this problem last week on a number of machines. I managed to fix it by finding a machine where it was working properly and copying the entire FMS folder (C:\Program Files\SIMS\FMSSQL) and then using it to overwrite the folder on the faulty machines. Once I had replaced the folder the DB selection started to work properly.
    i could try that, i did try coping the ini files, but that did not do the job,

  12. #12

    Join Date
    Apr 2007
    Location
    Cornwall
    Posts
    309
    Thank Post
    19
    Thanked 85 Times in 57 Posts
    Rep Power
    38
    Hi,

    Our usual problem usually relates (I'm not sure its your problem, but perhaps worth a look) to the fact that FDS wants to write the FMSConnect.ini to the FMS directory, but windows 7 doesn't like that, so creates a writeable area called 'virtual store' which it then magically behind the scenes uses instead of program files regarding the writeable content.

    Capita seem to switch between storing FMS in finance and FMSSQL directories. We usually find it best if we have problems to delete both and reinstall again, checking that the SIMS.ini in windows is pointing to the right location.

    For the virtual store, have a look in C:\Users\[Username]\AppData\Local\VirtualStore\Program Files\SIMS\Finance. You may need to look in program files (x86) and indeed FMSSQL rather than finance.

    HTH,

    Meldrew

  13. #13

    Join Date
    Jan 2011
    Location
    Southampton
    Posts
    30
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thank you i will do so now

  14. #14

    Join Date
    Jan 2011
    Location
    Southampton
    Posts
    30
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    ALL working, replaced the finance folder on the local drives with the one that worked and hey presto! cheers guys!

  15. #15

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,250
    Thank Post
    404
    Thanked 630 Times in 575 Posts
    Rep Power
    185
    Are you saying you replaced the file called Finance in the virtual store? *confused*

    Or the FMS folder?
    Last edited by Edu-IT; 28th April 2013 at 07:00 PM.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Moodle & Google Apps integration by Moodle Rooms - anyone using it?
    By morganw in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 1st April 2011, 12:51 PM
  2. CASPA - anyone using it?
    By speckytecky in forum How do you do....it?
    Replies: 0
    Last Post: 4th February 2009, 12:03 PM
  3. P2V converter - anyone used it?
    By Sirbendy in forum Thin Client and Virtual Machines
    Replies: 5
    Last Post: 3rd July 2008, 03:06 PM
  4. NAS - anyone using it?
    By pmassingham in forum Hardware
    Replies: 10
    Last Post: 22nd May 2008, 02:26 PM
  5. WinAudit - Free Program, Anyone used it ?
    By Galway in forum Downloads
    Replies: 2
    Last Post: 29th June 2007, 08:30 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
  •