Group Abstract Group Abstract

Message Boards Message Boards

0
|
10.9K Views
|
8 Replies
|
1 Total Like
View groups...
Share
Share this post:

Connect to a FileMaker .fmp12 database using DatabaseLink?

Using DatabaseLink, Is it possible to connect to and query a FileMaker .fmp12 database? If so, how?
POSTED BY: Murray Eisenberg
8 Replies
Sort By:
Colin Grace
Colin Grace
Posted 7 years ago

This routine doesn't seem to work for FileMaker Pro Advanced v17 and Mathematica 12- any ideas?
POSTED BY: Colin Grace

It's working for me with FileMaker Pro Advanced 17 and Mathematica 12 (under macOS Mojave 10.14.4).

Did you install the jdbc driver that is included in the FileMaker Pro Advanced .dmg? It's in the Extras > xDBC > JDBC Client Driver folder.

Moreover, to connect from Mathematica, you already need to have FileMaker Pro Advanced running, of course, and to have the particular .fmp12 database open, too, so far as I can determine.

See https://fmhelp.filemaker.com/help/17/fmp/en/index.html#page/FMP_Help/odbc-jdbc.html
POSTED BY: Murray Eisenberg
Colin Grace
Colin Grace
Posted 7 years ago

Ah..I forget to position the driver in Math'a Java folder. I had to download it from the Filemaker Downloads page since it was absent from my FM17 Extras folder. All's well now. Your input very helpful.
POSTED BY: Colin Grace

That's not where the FileMaker docs say to put the jdbc driver, but if it works there, good!
POSTED BY: Murray Eisenberg
Colin Grace
Colin Grace
Posted 7 years ago

Just for the record, its where Wolfram wants it - otherwise OpenSQLConnection reports driver error. Here's the JavaClassPath[] with the driver fmjdbc.jar in position:

{"/Applications/Mathematica.app/Contents/SystemFiles/Java/", \ "/Applications/Mathematica.app/Contents/SystemFiles/Java/WolframSSH.\ jar", "/Applications/Mathematica.app/Contents/SystemFiles/Java/\ WolframSSHKeyGen.jar", \ "/Applications/Mathematica.app/Contents/SystemFiles/Java/fmjdbc.jar", \ "/Applications/Mathematica.app/Contents/SystemFiles/Autoload/\ PacletManager/Java/",.............................} {"/Applications/Mathematica.app/Contents/SystemFiles/Java/", \ "/Applications/Mathematica.app/Contents/SystemFiles/Java/WolframSSH.\ jar", "/Applications/Mathematica.app/Contents/SystemFiles/Java/\ WolframSSHKeyGen.jar", \ "/Applications/Mathematica.app/Contents/SystemFiles/Java/fmjdbc.jar", \ "/Applications/Mathematica.app/Contents/SystemFiles/Autoload/\ PacletManager/Java/",
POSTED BY: Colin Grace

As I reported, OpenSQLConnection is working for me when fmjdbc.jar is in /Library/Java/Extensions and yet is not in /Applications/Mathematica.app/Contents/SystemFiles/Java/.
POSTED BY: Murray Eisenberg
POSTED BY: Murray Eisenberg

Murray, according to this link in FileMaker community the poster states that it can be done. I don't have access to FileMaker and I am assuming Mac OS on your end, but it jives with general JDBC connections.
POSTED BY: Hans Michel
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard