3 Replies Latest reply on May 25, 2015 11:55 AM by sstrom

    Mathematica database connection

    rajahornstein

      I've been trying to access a Filemaker 12 database using Mathematica 9. I have the Filemaker file shared locally using ODBC/JDBC. I've confugured the database on different attempts as a User DSN and a System DSN (although I'm not entirely sure about the difference). In Mathematica I keep getting an error that the connection failed before I even get to the point of specifiying the source. Does anyone know how to do this?

        • 1. Re: Mathematica database connection
          mikebeargie

          If your filemaker server 32 or 64 bit? I know there's two different versions of the filemaker drivers based on what version of FMS you installed. And you also need to use the 32-bit Data Sources manager if you have 32-bit FMS on a 64-bit OS.

           

          Is mathematica/DSNs on the same machine that is hosting the FM file?

           

          Here's all you need to know about DSN differences:

          http://digital.ni.com/public.nsf/allkb/852559036FB6447380256ADF007C3964

          • 2. Re: Mathematica database connection
            sstrom

            I'm currently connecting Mathematica 10 to FileMaker Pro 14, Java 8 (1.8.0_45), on a Mac Yosemite 10.10.3, but I've had success in the past with earlier versions of Mathematica, FileMaker, OS X, and Java. The biggest issues were always getting the FileMaker JDBC driver into Mathematica's Java class path, and then getting the connect string correct.


            Here's how I do it:

             

            I put the FileMaker JDBC driver at the most global level:

             

            /Library/Java/Extensions/fmjdbc.jar

             

            I use the the most verbose version of OpenSQLConnection

             

            In[2]:= Needs["DatabaseLink`"]

            In[3]:= Needs["JLink`"]

            In[4]:= conn = OpenSQLConnection[

                JDBC["com.filemaker.jdbc.Driver", "jdbc:filemaker://localhost/simple"

              ],

                "Name" -> "FMP", "Username" -> "Admin", "Password" -> "password"

              ]


            Out[4]= SQLConnection[Name: FMP ID: 1

            Status: Open Catalog:

            ]

            • 3. Re: Mathematica database connection
              sstrom

              Oh, and in the ODBC/JDBC Settings, I have Sharing turned on, and I specify users by privilege set -- for my purposes currently security isn't an issue, I'm connecting using Admin which has a Privilege Set of 'Full Access'.