+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, FMS Prob! in Technical; Hi guys! Hope this is the right place to post about this problem! We have a problem with our FMS ...
  1. #1

    Join Date
    Aug 2007
    Location
    Wiltshire, UK
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    FMS Prob!

    Hi guys!

    Hope this is the right place to post about this problem!

    We have a problem with our FMS Modules. They chuck up this problem:
    UNHANDLED EXCEPTION IN SIMS FMS MODULE
    General SQL Error.
    (Sybase)(OBDC Driver)Unable to Connect to database sever: unable to start database engine


    It was working ok last week..and this happens on every machine...? Does anyone have any ideas?

    Thanks

    P.S. Have attached a screenshot of the problem
    Attached Images Attached Images

  2. #2
    DreddMetal's Avatar
    Join Date
    May 2007
    Posts
    91
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    16

    Re: FMS Prob!

    Have you made sure the sqlanywhere service is running on the server?
    Start > Run > DBSVMN50 and make sure its running

    Is the ODB path correct on the workstations?
    Start > Run > ODBCAD32 > SYSTEMDSN configure the SIMS32 dsn and make sure that the field for database file is pointing to the SIMS.DB file as it appears on the server not the workstation

    Hope this helps

  3. #3

    Join Date
    Aug 2007
    Location
    Wiltshire, UK
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Prob!

    Hi there DreddMetal!

    Thanks for getting back to me so quick. Have checked that the server is running...Thats fine.

    Have also Checked the database file is pointing to the SIMS.DB...which it is.

    Though that has confused us as on the server it points to D:\sims\sql\sims.db
    On the client it points to the same path d:\sims e.t.c But on the client machine the D drive is the CD ROM Drive does that matter? Or is it just mirroring what the server has for its path when it connects so to speak?

    This is really confusing!

  4. #4
    DreddMetal's Avatar
    Join Date
    May 2007
    Posts
    91
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    16

    Re: FMS Prob!

    Have you tried stopping and starting the sqlanywhere service? I know it shouldn't make a difference if its already running but you never know.

    As for the database file directory on the workstations i've never understood it myself, but if its anything other than what it is on the server it throws a wobbly.

  5. #5
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,484
    Thank Post
    10
    Thanked 502 Times in 442 Posts
    Rep Power
    114

    Re: FMS Prob!

    As mentioned above restart the service on the server and make sure it runs sucessfully.

    This happened when I moved my sims server to a different vlan to the clients. It uses a broadcast to find the server. Has the server been moved?

    You can also try adding the host address on one of the machines

    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SIMS32

    My start key looks like this:

    c:\progra~1\sqlany\win32\dbclient.exe -ta 600 -x TCPIP{HOST=10.0.6.3}

  6. #6

    Join Date
    Aug 2007
    Location
    Wiltshire, UK
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Prob!

    DMcCoy you are amazing my friend!!!! Its sorted! It was just missing the {host} bit!! Cred toDreddMetal also for helping us out!

    Thanks so much guys it has taken a day to figure that out! Even Capita couldn't figure that out!

    Thanks again guys!

SHARE:
+ Post New Thread

Similar Threads

  1. Ghost / Network prob!!
    By sLiDeR in forum Network and Classroom Management
    Replies: 7
    Last Post: 23rd July 2009, 09:35 AM
  2. SIMS.NET FMS Module Prob
    By dan4132 in forum Thin Client and Virtual Machines
    Replies: 2
    Last Post: 12th September 2007, 11:09 AM
  3. Webby css prob
    By Kained in forum Web Development
    Replies: 5
    Last Post: 22nd June 2007, 11:13 AM
  4. Printer Prob
    By westbourne in forum Wireless Networks
    Replies: 0
    Last Post: 3rd May 2007, 10:42 AM
  5. mediawiki prob
    By browolf in forum Web Development
    Replies: 2
    Last Post: 25th April 2007, 10:32 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
  •