Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 1 of 1
  1. #1
    Senior Moderator - FMT Preferred Developer Consultant - Netherlands, Europe, Asia, USA Maarten Witberg's Avatar
    Join Date
    Mar 2004
    Posts
    6,135
    Location
    netherlands
    FileMaker Pro Software
    version 11, 12, 13, 14, 15
    OS
    Windows & Mac
    Skill Level
    Developer
    Last Post
    06-29-2017
    Local Date
    07-28-2017
    Local Time
    08:48 PM
    Last Active
    07-16-2017

    Lost ODBC connection: error locks up app

    Situation:
    - FM 15 on a macbook pro, latest OS.
    - local file
    - ESS connection to MS SQL Server 2008/R2 on windows 8.1.
    - Actualtech ODBC driver on the mac.
    - LAN connection over the ethernet

    Test:
    What happens if the connection is lost? (I.E. I shut down the windows computer hosting the MS SQL server without closing the FM app on the mac first)

    Error 1413 is what happens. That's fine (Failed communication link). But what is not, is that the app is essentially locked down after that. I find there is no way out but a forced quit. You can't quit, navigate to other layout, open database management, but you can open the script manager and edit and write scripts.
    Error handling in a script works insofar as you can get it to display a dialog but moving out of the layout etc is ignored and no other errors are returned.
    Even if the connection is reestablished, the error stays.

    I found only 1 reference to this exact problem from 2012 on the forums without a solution or an acknowlegdement by FMI that something's not right.
    So either I am missing a very obvious thing or this is a very arcane issue that nobody ever encounters.

    Any insights?



    p.s. fwiw and unsurprisingly, Get ( LastExternalErrorDetail ) returns an empty string.
    Last edited by Maarten Witberg; 05-18-2017 at 06:34 AM.
    Stick to what you don't know.

    http://www.maartenwitberg.nl

    Filemaker 15 Certified Developer

    -------

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 01-15-2015, 09:43 AM
  2. Re-connect to File After Connection Lost
    By maluktuk in forum FileMaker 13 - All Versions
    Replies: 0
    Last Post: 10-21-2014, 03:30 PM
  3. FMP 11 closes files after error (51)...connection lost???
    By rlanthier in forum FileMaker Pro 11
    Replies: 0
    Last Post: 08-17-2011, 12:05 PM
  4. ODBC connection Error
    By Guru D in forum ODBC
    Replies: 11
    Last Post: 09-25-2009, 06:29 AM
  5. Lost my Look Up Connection
    By Gene Ort in forum FileMaker Pro 9
    Replies: 5
    Last Post: 09-02-2008, 10:02 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 42,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.