5 Replies Latest reply on May 23, 2012 5:38 AM by taylorsharpe

    ODBC/MySQL and Filemaker Server 12 Advanced (Windows 2008 R2)

    joris.bruijnzeels

      We're deploying our new Filemaker servers and are running into some trouble.

       

      Installation, deployment and uploading of our databases is going smoothly, the problems start when we open a database from our Filemaker Pro (Mac OS X) clients.

      As soon as we open a layout with ESS fields (or go into ERD and edit an ESS occurance on the graph) the client hangs. Worse, after about a minute the database server stops (only server overview and log viewer available from the admin panel).

       

      The server:

      - Windows Server 2008 R2 Standard (64 bit)

      - MySQL ODBC connector 5.1.11 (64 bit)

       

      The clients opening the database are Filemaker Pro 12 and Filemaker Pro 12 Advanced running on OS X 10.6.8 and 10.7.4

       

      Error in te Event Viewer:

       

      Log Name: Application

      Source: Application Error

      Date: 23-5-2012 9:38:26

      Event ID: 1000

      Task Category: (100)

      Level: Error

      Keywords: Classic

      User: N/A

      Computer: azion02

      Description:

      Faulting application name: fmserver.exe, version: 12.0.1.172, time stamp: 0x4f62af5c

      Faulting module name: myodbc5.dll, version: 5.1.11.0, time stamp: 0x4f9b1ada

      Exception code: 0xc0000409

      Fault offset: 0x00000000000053de

      Faulting process id: 0xf0c

      Faulting application start time: 0x01cd382c1538ae08

      Faulting application path: C:Program FilesFileMakerFileMaker ServerDatabase Server x64 mserver.exe

      Faulting module path: C:Program FilesMySQLConnector ODBC 5.1myodbc5.dll

      Report Id: 47d04494-a4aa-11e1-b587-0050569d000f

      Event Xml:

      <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

      <System>

      <Provider Name="Application Error" />

      <EventID Qualifiers="0">1000</EventID>

      <Level>2</Level>

      <Task>100</Task>

      <Keywords>0x80000000000000</Keywords>

      <TimeCreated SystemTime="2012-05-23T07:38:26.000000000Z" />

      <EventRecordID>575</EventRecordID>

      <Channel>Application</Channel>

      <Computer>azion02</Computer>

      <Security />

      </System>

      <EventData>

      <Data>fmserver.exe</Data>

      <Data>12.0.1.172</Data>

      <Data>4f62af5c</Data>

      <Data>myodbc5.dll</Data>

      <Data>5.1.11.0</Data>

      <Data>4f9b1ada</Data>

      <Data>c0000409</Data>

      <Data>00000000000053de</Data>

      <Data>f0c</Data>

      <Data>01cd382c1538ae08</Data>

      <Data>C:Program FilesFileMakerFileMaker ServerDatabase Server x64 mserver.exe</Data>

      <Data>C:Program FilesMySQLConnector ODBC 5.1myodbc5.dll</Data>

      <Data>47d04494-a4aa-11e1-b587-0050569d000f</Data>

      </EventData>

      </Event>