Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
wheezl said:
All I really want is the ability to use filemaker to build a front end to my PostgreSQL databases with an ODBC driver... or really.. anything else.

The inability for the old filemaker to do anything but poll a SQL db for records was a sure show stopper for me.

If I can use filemaker to write a nice front end to a real database.. then all is well... otherwise filemaker is still for storing recipies and quilt patterns.


Pick the right tool for the right job. Use WebObjects to build your Front-end interfacing via EOF that treats PostgreSQL as pure Objects.
 
mdriftmeyer said:
Pick the right tool for the right job. Use WebObjects to build your Front-end interfacing via EOF that treats PostgreSQL as pure Objects.


Agreed, but I have found it nice on occasion to use something like Access hooked up to PostgeSQL via ODBC so a client can actually muck around a bit without having to call me. I think it would be neat to have that option on the mac as well.
 
phasornc said:
Once again, the press release said no ODBC/JDBC on OS X, is said nothing about OS X SERVER. This could be part of Apple's strategy to simply get people on OS X server. I realize the OS X and OS X SERVER are essentially the same underlying technologies, but SERVER is marketed as different product.

Can anyone clarify whether we get ODBC/JDBC on OS X SERVER?

I can clarify that you won't, at least not for FileMaker. If you look in the FAQ for Filemaker 7 Advanced server, it says you can't use it as an ODBC datasource on OSX. If you look at the requirements for Advanced Server, you must use OSX Server, OSX client is not an option. That added to the fact that OSX Server is just OSX client with some added apps leads to the conclusion that you can't use any version of FileMaker 7 as a datasource on any version of OSX. You can use OSX as an ODBC *client* with the ODBC driver included, but not as a datasource.

The language is a little vague, but given all the pieces parts, it's the only conclusion I can come to.
 
I have a question for you filemaker users.

I want to create a sports database for a website i'm making. like for football.
Can i make a database with this app so all i have to do is choose the game from the scheduled i've entered before hand enter the score and the app does the rest like calcuate position in league point difference wins and provide a table where u can read this in html on a site?
 
Jonnod III said:
Just a note on Access/Mac etc.

Microsoft had one of the first databases on the Mac - called Microsoft File, I believe. So it did have a suite of a sort - Excel, Word and File. (I'm sure no-one in their right minds back then thought of anything as cr@p as Powerpoint back then)

Oh, and I'm amazed that ayone thinks Access is easy - laying out forms and reports was always torture. (and that's being kind).

I knew that MS used to have a DB as part of their Office line up on the Mac. I guess I just assumed that it was an early version of Access. Correction noted.
 
Snowy_River said:
I knew that MS used to have a DB as part of their Office line up on the Mac. I guess I just assumed that it was an early version of Access. Correction noted.
Wasn't FoxPro on the Mac originally too?
 
pkscout said:
It looks like you can't run FileMaker Pro Server Advanced on OSX if you want to do ODBC connections. But if you want to connect to a FileMaker Pro Server on Windows you *can* do that on OSX using FileMaker Pro client (or anything else that understands ODBC).

I can't believe how completely idiotic it is to not support ODBC datasourcing on OSX. I'm canceling one of my G5 XServe orders tomorrow and ordering a Windows 2003 server instead, because we *really* need ODBC connectivity to FileMaker solutions. I can't wait to see the look on my Apple reps face when I tell him I'm canceling a hardware order because one of Apple's fully owned subsidiaries can't support OSX properly.
You must have missed this, from http://maccentral.macworld.com/news/2004/03/09/fm7:
The new FileMaker Server 7 Advanced product also supports JDBC and ODBC, making it possible to share data with other applications or provide data for reporting tools. This connectivity will be missing from the initial Mac OS X release, according to FileMaker, which cited "delays in implementing the technology."

"We are committed to implement technologies cross platform when possible and intend to provide full support for ODBC/JDBC on the Mac as soon as possible but can't provide dates at this stage," said FileMaker spokesman Kevin Mallon.
Emphasis mine.

I'm surprised that you'd change server platforms so hastily, without checking all the facts.

WM
 
Yeah ODBC eventually!!

I wish Filemaker would have stated this on their site, but this is pretty good news. This means easy PHP and JSP support for all Mac server setups. However, the pricetag is steep, $2499 + $499 for Mac OS Server (ten user). This is more than the cost of entry for MS SQL Server/Windows Server 2003.

I see FileMaker Advanced server as filling a nice gap between Access and SQL Server. It is the one product you can use for your office workgroup and simultaneously publish to the web through standard scripting languages. However the price of entry is also high. Well, we all thought the iPod, the iPod mini and the Cube were priced to high and the market proved us wrong twice. So now we wait and see will FileMaker Advanced Server be a Cube or and iPod.

Since people seem to be willing to shell out the money for "appliances", maybe the time is right for an Xserve/FM Advance preconfigured combo. Apple could really outdo the MS Small Business Server, with a little more tweaking of the Server Admin tools.

Oh well . . . enough babbling, time get back to playing with the FileMaker demo, I've got about 30 databases (60 .fp5 files) to start converting. Did anybody notice in the conversion pdf that found sets and sorts in your old scripts won't be carried over to the new filemaker 7 format. This is like Apple's full employment act for FileMaker techs/consultants.


WM. said:
You must have missed this, from http://maccentral.macworld.com/news/2004/03/09/fm7:

Emphasis mine.

I'm surprised that you'd change server platforms so hastily, without checking all the facts.

WM
 
Waiting for JDBC...

Well, my credit card is waiting for that JDBC support, and not just in Advanced Server. A JDBC driver should be available seperately to run against Any Version of FileMaker.

JDBC Drivers can report a LOT of Meta Data about the database, so, I don't think this is trivial to write. But, it's not Rocket Science either.
 
If Apple thinks of JDBC as a server-only function, I beg to differ. I think of this interface the same way I think of RTF for word processing - the common language all products should support. If I have a one-user personal database in my one-user personal copy of FileMaker, I want to be able to query it with a separate SQL-speaking tool. All RDBMSes, client or server, should support JDBC. That's my 2 cents, and Apple won't get my more-than-2 cents for an upgrade until they add it.
 
WM. said:

In fact, I had not seen that. Thanks for the post. I looked at every page on the FileMaker site to find any indication of future support to no avail, and this is the first article I've seen with any indication of future support. We'll still have to decide based on our project timeline what platform to get, as being committed to something and actually delivering it are two very different things.
 
I hope my emphasis wasn't too misleading, BTW...I mean, you're skimming along, and you see this bold thing about "full support", but you go right by the part about "as soon as possible...no dates at this time." I guess that's just my journalistic tendency to mislead. :D (And why isn't there an "evil" smiley???)

Also, since I don't have much interest in FileMaker (although my dad might be able to find a use for it for his small business), I haven't poked around their site at all. So I guess I didn't really check all my facts--I kind of assumed that they'd put something as important as this future ODBC/JDBC support in a fairly prominent place on the product pages.

WM
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.