Re: Witango-Talk: Witango to FMP: Still fighting with it.

2011-02-15 Thread Wayne Irvine
On 16/02/2011, at 3:37 PM, Robert Garcia wrote: > 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 wel

Re: Witango-Talk: Witango to FMP: Still fighting with it.

2011-02-15 Thread Wayne Irvine
On 16/02/2011, at 12:25 PM, Robert Shubert wrote: > 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. > That is great news. I have just successfully set up ODBC DSNs with FMP single user version so I

Re: Witango-Talk: Witango to FMP: Still fighting with it.

2011-02-15 Thread Robert Garcia
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 wit

Re: Witango-Talk: Witango to FMP: Still fighting with it.

2011-02-15 Thread Robert Garcia
You can a field at any time, and even set the order of the fields within a table. The key to mysql, is to use a good tool with it. MySQL Workbench is free, and a great tool, but I love Navicat. Try the trial version. -- Robert Garcia President - BigHead Technology VP Application Development - e

Re: Witango-Talk: Witango to FMP: Still fighting with it.

2011-02-15 Thread Wayne Irvine
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 shoul

RE: Witango-Talk: Witango to FMP: Still fighting with it.

2011-02-15 Thread Robert Shubert
Wayne, 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. As for whether or not Witango wi

Re: Witango-Talk: Witango to FMP: Still fighting with it.

2011-02-15 Thread Wayne Irvine
On 15/02/2011, at 11:54 PM, Dan Stein wrote: > > I would not ever suggest using anything but FMS to do this. Using FileMaker > in peer to peer is always risky for more reason then I can count. I would be interested in hearing some of those reasons that justify a ten fold cost increase. I also h

RE: Witango-Talk: Witango to FMP: Still fighting with it.

2011-02-15 Thread Robert Shubert
Wayne, Witango 6 will only focus on ODBC and JDBC connectivity. All native connectivity is deprecated, although what was in the v5.5 server should still work, but it’s not officially supported. I can’t say if I’ll change this position in the future, however, I can say that with the OSX Stu

Re: Witango-Talk: Witango to FMP: Still fighting with it.

2011-02-15 Thread Dan Stein
Wayne. I would not ever suggest using anything but FMS to do this. Using FileMaker in peer to peer is always risky for more reason then I can count. Robert hosts FileMaker at Tronics and I manage the FileMaker part of that server. The pricing is very competitive and you get all the advantages of