2 Replies Latest reply on Mar 18, 2013 12:08 PM by ErikLangeland

    ODBC access to database on FileMaker Server via FileMaker Pro

    ErikLangeland

      Title

      ODBC access to database on FileMaker Server via FileMaker Pro

      Post


           We have a number of users currently using local FileMaker Pro installations and accessing those databases through ODBC from other applications on their PCs. Because we soon need muliple users sharing databases, we are now setting up a FileMaker Server to host those databases. However, when we began the project, there was no mention of using ODBC access to FileMaker, so we have only File Maker Server, not FileMaker Server Advanced.

           In this scenario, can users continue to use their local FileMkaer Pro installation and ODBC driver to access the database that has been moved to the server, or are we forced to upgrade to FileMaker Server Advanced and point the ODBC setup on the PCs to point directly to the server.

        • 1. Re: ODBC access to database on FileMaker Server via FileMaker Pro
          davidanders

               How many users? Windows or Mac? Win version?  FMP Server on what computer and OS?
               Currently FMP is installed on all user's computers with a database file that is accessed by what applications using ODBC?

               If all the users that need access have Filemaker, why not access the FMP Server with Filemaker?

          • 2. Re: ODBC access to database on FileMaker Server via FileMaker Pro
            ErikLangeland

                 5 users on Windows 7 Enterprise with SP1 and all current patches.

                 FileMaker Server to be installed on a Windows Server 2008 R2 VM on vSphere 5.0.

                 The database is linked as an attribute table to a file geodatabase (or soon an SDE geodatabase on Oracle) used in ESRI ArcGIS and DAT/EM Summit Evolution.

                 The geospatial editing is done in ArcGIS and Summit Evolution, and the users need to edit the attributes as part of that process. So, I guess what I'm asking is "Can the users access the database by opening it from FileMaker Server in FileMaker Pro, then use ODBC locally between FileMaker Pro and the 3rd party application to allow the 3rd party application to edit the database?"