+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, Installing FMS on a new workstation? in Technical; Hi All, Signed up a little while a go and it seems a very nice community! :-) We havn't had ...
  1. #1
    greengate's Avatar
    Join Date
    Dec 2009
    Posts
    4
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Installing FMS on a new workstation?

    Hi All,

    Signed up a little while a go and it seems a very nice community! :-) We havn't had to use you until now!

    After much nagging, we decided to agree to buy our Business manager a new high spec PC.
    Capita seem to be as much use as a chocolate teapot!

    FMS seems to be causing us a problem.

    SQL Native client has been installed along with FMSApplicationsetup.exe
    The FMSConnect.ini file was then copied from a working FMS machine into the same location on the new machine. (Was told to do this by Capita)

    We have never had to re-installed FMS on any machine - it's just worked, so it all is new to us!

    Is the above the right procedure? Do we have to do anything else afterwards?
    I read somewhere about having to copy the entire MSSQL folder from the Finance folder on a working machine?

    Any help and tips would be much appreciated!

    Many Thanks

    Greengate.

  2. #2

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,196
    Thank Post
    404
    Thanked 627 Times in 573 Posts
    Rep Power
    182
    Quote Originally Posted by greengate View Post
    Hi All,

    Signed up a little while a go and it seems a very nice community! :-) We havn't had to use you until now!

    After much nagging, we decided to agree to buy our Business manager a new high spec PC.
    Capita seem to be as much use as a chocolate teapot!

    FMS seems to be causing us a problem.

    SQL Native client has been installed along with FMSApplicationsetup.exe
    The FMSConnect.ini file was then copied from a working FMS machine into the same location on the new machine. (Was told to do this by Capita)

    We have never had to re-installed FMS on any machine - it's just worked, so it all is new to us!

    Is the above the right procedure? Do we have to do anything else afterwards?
    I read somewhere about having to copy the entire MSSQL folder from the Finance folder on a working machine?

    Any help and tips would be much appreciated!

    Many Thanks

    Greengate.
    Where is the FMS database located, on this machine or on your server? You'll be able to tell by looking in the FMSConnect.ini if you're not sure. If it's on your local machine then you'll need to reinstall SQL etc and copy over the DB.

    I believe there are some SQL components to install on the machine if the database is hosted on another server but I am at home at the moment and can't for the life of me remember what they are. These may be installed by the FMSApplicationSetup.exe.

    According to Capita SupportNet.
    Affected Products FMS
    Notes
    How do you reinstall FMS on a workstation?
    Advice
    To reinstall FMS on a workstation you will need to carry out the following:


    1. Firstly navigate to the FMSSQL folder located within the SIMS directory on the workstation.
    2. Rename the FMSSQL folder to something different (example FMSSQLold).
    3. You will then need to navigate to the FMS setups folder on the server and run the FMSApplicationSetup.exe.

  3. Thanks to Edu-IT from:

    greengate (23rd February 2010)

  4. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Quote Originally Posted by Edu-IT
    I believe there are some SQL components to install on the machine if the database is hosted on another server
    SQL Native Client

  5. #4

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,196
    Thank Post
    404
    Thanked 627 Times in 573 Posts
    Rep Power
    182
    Quote Originally Posted by matt40k View Post
    SQL Native Client
    That's the one, cheers.

  6. #5
    greengate's Avatar
    Join Date
    Dec 2009
    Posts
    4
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for your help guys, has helped alot this morning

    I have now got FMS working on 2 of the machines in our office which have SQL Server 2005 Express including Native Client installed. Have tested FMS and this is fully functional.

    I have done exactly the same on the new machine ie. install fresh copy of SIMS and FMS, i then get the following error opening both databases:

    'An error occurred while attempting in initialize the Borland Database Engine (error $210A)'

    I think somewhere along the line something has screwed up. I might just rebuild the machine and start from scratch?

  7. #6

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,196
    Thank Post
    404
    Thanked 627 Times in 573 Posts
    Rep Power
    182
    Run the setup again. (FMSInst.exe)

    According to SupportNet:

    Advice
    Please run the BDE installation. This can be done using the discs below:


    6.83 disc and below - Reinstall FMS ensuring 'sims applications' is ticked on the 'installation components' screen
    6.91 disc - run the BDE install option

  8. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    I would ask for the latest FMS iso. Burn to a disc. Use that. It's got all the guff you need plus a nice (capita) manual.

  9. Thanks to matt40k from:

    greengate (23rd February 2010)

  10. #8
    greengate's Avatar
    Join Date
    Dec 2009
    Posts
    4
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    After installing BDE.exe which i downloaded from the internet it now works!

    Many Thanks for all your help!


  11. #9

    Join Date
    Jan 2011
    Location
    worcester park
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Talking Thanks to all

    I had the same problem installing FMS on a workstation.
    Error $210 resolved by downloading & installing BDE.
    "Create user DSN Failed" sorted by downloading & installing SQL native.

    Now working.

    Thanks to all who posted on this. Great!!

  12. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    to the 'Geek.

  13. #11
    JJanisch's Avatar
    Join Date
    Nov 2011
    Location
    Swindon
    Posts
    195
    Thank Post
    21
    Thanked 18 Times in 18 Posts
    Rep Power
    9
    Can someone link me to the install of BDE.exe ?

  14. #12
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by JJanisch View Post
    Can someone link me to the install of BDE.exe ?
    It's included in the SIMSInfrastructureSetup.exe I believe. Just run it and select the FMS Components option.

  15. #13
    JJanisch's Avatar
    Join Date
    Nov 2011
    Location
    Swindon
    Posts
    195
    Thank Post
    21
    Thanked 18 Times in 18 Posts
    Rep Power
    9
    Found it online and installed - that particular issue is now fixed. Unfortunately I have a "handle request" error (stupidly I didn't write down the exact name at the time), found one thread on here but can't seem to find it again. Argh! I resorted in copying a working FMS install directory over to the new/broken machine (as suggested on the particular thread) but it didn't work.

    Why can't things just work as expected!?

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Installing FMS?
    By Ben-BSH in forum MIS Systems
    Replies: 14
    Last Post: 27th March 2012, 03:08 PM
  2. installing FMS on 2008R2 Terminal Server
    By sacrej in forum MIS Systems
    Replies: 19
    Last Post: 5th March 2010, 10:13 AM
  3. Installing On Network VRs Installing On Home PC
    By russdev in forum General Chat
    Replies: 1
    Last Post: 14th October 2009, 02:21 PM
  4. FMS installable \ FMS installer
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 5th March 2009, 01:01 PM
  5. Installing FMS
    By lovelldr in forum MIS Systems
    Replies: 0
    Last Post: 4th September 2007, 12:12 PM

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
  •