Thank you for your post.
At this time, the file structure for a FileMaker Pro database file is not available, nor is there an API.
Please enter your post into our Feature Requests web form at:
These suggestion entries are monitored and read by members of Development and Product Management where it will be discussed and considered for a future release.
Although I could easily copy your post and paste it into the web form, there are some additional questions asked that only you can answer.
Just create your UI in what ever you want an hit the FileMaker database via SQL calls back to a central server, or if that is not doable you could cache data like FM Touch does and sync back to the database when they connect to their computer.
I am trying to follow your instructions with mixed success. I would appreciate an example! Before I write any code, I usually setup my SQL connections and test the db with a desktop SQL client (I currently use RazorSQL).
My setup is as follows:
-- FMP 11 running on an iMac with the db open
---- Sharing enabled for: FileMaker Network; Instant Web Publishing; ODBC/JDBC .
-- FM Go on iPhone 4, iPhone 3GS, iPad WiFi +3G
-- AirPort Express forwarding ports 80 (Mac Web Sharing); 591, 5003, 2399, 5013, 5353 to iMac running FMP (10.0.1.2)
(I have other Macs, iPhones and iPads, but have not bothered to test them, as everything works on these devices).
-- URL 10.0.1.2 FM Network WiFi sharing with FM Go to iPhones and iPad
-- URL MyStaticIP:5003 FM Remote 3G (or WiFi) with FM Go to iPhones and iPad
-- URL MyStaticIP:591 FM Web sharing via 3G (or Wifi) with FM Go to iPhones and iPad
-- URL jdbc:filemaker://10.0.1.2/Product Mac WiFi SQL Client JDBC access to Local FMP database
What Doesn't work
Any of several URLS attempting to JDBC access the Remote FMP database with the SQL Client:
I am unable to determine what URL I need to use to JDBC Connect to a Remote FM Network database.
So, I am dead in the water-- I can't begin coding my app until I know what it takes to make the connection.
I've spent several days searching the docs, and testing various setups-- to no avail.
Funny thing, back in 1999-2000 I was developing a web site for a customer and was able to interface an SQL client to the customer's remote FM db (AIR it was FM 6 or 7). Anyway, I prototyped the SQL using the SQL Client, before writing the web app in ColdFusion.
So, I know it can be done-- I just can't figure out how!
Any help will be greatly appreciated!
Have you read http://www.filemaker.com/support/product/docs/fms/fm11_odbc_jdbc_guide_en.pdf and installed the JDBC (fmjdbc.jar) driver? Also make sure you have turned on the the xDBC sharing for the user account you are trying to connect with to the database with.
We have a pretty large client using this currently without problem (but to an FMS Adv server) so not sure why you can not get it to make the connection.
Not sure why you are trying the JDBC connection on port 5003, the documentation is clear it uses 2399
Yes I had read the JDBC guide, installed the driver, turned-on JDBC sharing-- in my prior post I indicated that I had it working thru JDBC using the Local IP address: 10.0.1.2.
Based on your guidance, I reread the JDBC guide.
I played with a few variations of the URL to access the FMP db using ODBC and my static Remote IP address.
Still, Nothing worked!
Frustrated, I downloaded a trial of the FMS Server, uploaded the db, and everything worked!
I tested this using 2 different SQL Clients: RazorSQL, and an old cop[y of ViennaSQL. The JDBC settings that did not work with FMP, without change, worked with FMS.
Here are some examples of the setup:
Driver Class: com.filemaker.jdbc.Driver
Driver Location: assumed to be in Java Path
JDBC URL: jdbc:filemaker://myStaticIP/Product?user=Admin&password=pw
Driver Class: com.filemaker.jdbc.Driver
Driver Location: /Library/Java/Extensions/fmjdbc.jar
JDBC URL: jdbc:filemaker://myStaticIP/Product
-- there is a bug in FMP's JDBC implementation
-- the FMP JDBC docs are incorrect
-- FMP does not support JDBC access to a db from a remote URL
FMS is way overkill in price, machine requirements, and DBA requirements for the type of use I am planning.
FMP is doable!
I have spent many hours over several days trying to get something working that normally would take 30 minutes, max.
I am totally frustrated! It appears that FMP is a not viable solution to custom IOS apps that want to access a remote DB!
What do I do now?
Guessing there is a bug, best thing to do is call it in to tech support or post on the FileMaker Pro forums to see if TS Gal or another user can verify it there.
To be frank though the xDBC support in FileMaker has been known to be buggy, so be careful using it, test throughly.
I'll give that a shot in the morning!
Well, just to close this out!
I contacted support and got a definite answer.
Unfortunately it wasn't the answer I wanted to hear. The email I got from support says that I am prohibited from publishing it or any content of the email message-- so I can't post the answer for others to see.
Hopefully, someone from Filemaker Support will read this thread and publish the definite answer, so it goes into the knowledge base.