Access Filemaker Database via Matlab (Mac OS X)

2 次查看（过去 30 天）
Léon
Léon 2011-10-11
Hi,
since I'm on the mac platform I got a few problems using ODBC/JDBC data-connections and hope one of you might help me, which will be greatly appreciated!
  1. I created a new database in Filemaker 11 pro, activated the sharing via JDBC function and assigned a user with write/read access to the database
  2. I installed the jdbc as told by filemaker by copying the file 'fmjdbc.jar' to library/java/extensions/
  3. Next I copied the file as well into the java directory to /Applications/MATLAB_R2011a.app/java/jar/
  4. I added the file in the classpath file in /Applications/MATLAB_R2011a.app/toolboxes/local as well
Now I should be good to go, right? So I tried to establish the connection via the following code, but was not able to succeed:
filemaker = database('database','user','password','/Applications/MATLAB_R2011a.app/java/jar/fmjdbc.jar','/Users/leon/Documents/database.fp7')
Can somebody help me please?

请先登录，再回答此问题。

回答（1 个）

Theresa
Theresa 2011-12-30
I don't know if you figured this out yet, but just in case - I was trying to figure out the same thing and ran into your question. I managed to get it working, so I thought I would post a reply.
Here's what I did:
1. Installed FMP 11 and copied the "fmjdbc.jar" file to library/java/extensions
2. Added the library/java/extensions path to classpath.txt in Matlab
3. Restart computer and Matlab.
4. Set up your data source
>> confds
In that dialog, you will define your jdbc data source create a file or use a file that is somewhere in your Matlab path
Name: is the name of your database file
Driver: com.filemaker.jdbc.Driver
URL: jdbc:filemaker://localhost/databasefilename
Test - the default user for FMP11 is Admin and the default password is blank
5. >> setdbprefs('JDBCDataSourceFile', 'nameoffilefromconfds')
6. Then you should be able to run:
>> filemaker = database('database', 'user', 'password', 'com.filemaker.jdbc.Driver', 'jdbc:filemaker://localhost/databasefilename')
Good Luck!

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by