1 Reply Latest reply on May 24, 2010 1:57 AM by kapitaen_1

    ODBC service drops on our FileMaker Server version 10

    GustavForssell

      Title

      ODBC service drops on our FileMaker Server version 10

      Your post

       

      We have problem with our FileMaker Server 10’s ODBC service which sometimes unexpectedly drops.

       

      The drop rate is about 1.5 times every month but is a real pain since the two connected systems is very critical for our business. To restore the connection I need to restart the FileMaker Server several times, this leads to interruption times up to 20 minutes for our 40 users and even worse, I always need to be on watch in case of service interruption.

       

      We are using a Mac Pro 2.66 GHz with 5 GB RAM running Mac OS X 10.4.11 and FileMaker Server Advanced version 10.0.2.206 hosting our business system. It’s hosting 29 files and we usually have around 40 clients connected. Our main data file is quite heavy and weights in on 1.66 GB. Our two next biggest files is on 192 and 132 MB but the other files are mostly smaller GUI files and personal databases. The server only runs the ODBC/JDBC service except it’s core database service.

       

      We then have a web based customer interface based on Python (Django) connected to our FileMaker Server using the provided ODBC drivers (DataDirect 32-BIT SequeLink 5.5 version 1.41.00.00).

       

      When the ODBC service crash a portscan won’t report port 2399 as open (which it obviously does when the service works) on the FileMaker Server and sometimes we see the account used for the connection stuck logged in, but simply disconnecting the user won’t solve the problem.

       

      We often need to restart the database server several times before the port appears to be open and to be able to connect via the ODBC service. I’ve had no luck getting it back only starting and stopping the database using the provided tools from FileMaker, i need to restart the background processes using the launchctl command, but it’s not necessary to restart the machine.

       

      Anyone else having this problem or even better, anyone having a clue about what’s causing this?

       

        • 1. Re: ODBC service drops on our FileMaker Server version 10
          kapitaen_1

          i had similar problems with odbc ... on windows server 2003.

           

          The fm server console told me that odbc was running and healthy (green dots everywhere), but a netstat and tcpview told me  that port 2399 didn´t reply a single bit.

           

          De- and reinstalling fm server didnt help, only a clean and slim reinstallation from scrap (starting with w2k3) got odbc to work.

           

          In your case i would suggest a regular reboot once a week. At a time, where (when?) you have the least (or none) traffic on your server. Maybee midnight would be a good time to do.

           

          greetings from germany

          Chris