One more thing to consider, is SQLite. Think of it kinda like an open source file database, and there are odbc/jdbc drivers for it, but it definitely works more like FMP, in that it is a file based db, not a server. Navicat also works well with sqlite, and so does SQLite Manager. Never tried witango with it, but I used SQLite as a local datasource for several desktop applications. So I would have the local data stored on SQLite, and then synchonized with servers (MySQL) in the cloud. SQLite is EXTREMELY robust.
-- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Feb 15, 2011, at 8:35 PM, Wayne Irvine wrote: > > On 16/02/2011, at 12:25 PM, Robert Shubert wrote: >> >> According to http://www.filemaker.com/products/compare/ only the Server >> Advanced product supports ODBC/JDBC. If there is some way that I’m unaware >> of that the client version can be used as an ODBC/JDBC data source, then >> Witango 6 should work with it. > > Hadn't seen that before. I was mostly looking at this: > > http://www.filemaker.com/support/technologies/odbc.html > > Using an ODBC client running on a local client, I want to submit SQL queries > or statements to a FileMaker Pro database. > > FileMaker Pro as a Data Source > > FileMaker Pro or FileMaker Pro Advanced > > Using an ODBC or JDBC client running on a remote client, I want to submit SQL > queries or statements to a FileMaker Pro database. > > FileMaker Pro as a Data Source > > FileMaker Server Advanced > >> One option you may wish to experiment with is to use MySQL as your data >> store – hookup Witango to drive the website and then hookup FileMaker as >> your desktop data management. You’ll get to leverage MySQL as a well >> developed and stable database engine and still use FileMaker to build a good >> looking management tool. > > I will look at that, but my understanding of MySQL is that it is quite > cumbersome. For example, can you just add a field to an established database? > I was under the impression that required quite a rebuild. > > If that is not true, then I have been misled. If it is, well that's the > reason I used FMP. > > Wayne > > > To unsubscribe from this list, please send an email to lists...@witango.com > with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.