ESS doesnt support Postgres SQL. However, you can import using the driver as well as using Execute SQL () commands.
Your post was tagged with a Solved tag.
IMHO, this problem is not solved at all.
Saying that "ESS does not handle Postgres databases" is true but inadequate.
Saying "data can be imported" is radically insufficient.
"Flights to Honolulu have been cancelled but you can always hire a bike. The issue is resolved. Have a nice trip."
FM Inc needs to wake up to the facts
FM Layoutting is cool.
FM Scripting is cool for the quick and easy stuff.
FM Scripting is a nightmare once you have more than one developper, esp if developper 2 is off site.
Have you tried emailing a snip of a a script to a colleague ?
FM Scripting is a nightmare when you have to jump in and out of dialogue boxes and subscreens.
FM Data and FM Layouts and scripts all together in the one file is a colossal headache when moving from a dev to a prod version.
Thats all IMHO, of course.
FM tables get corrupted and the repair system is unreliable, repaired tables can contain corrupt data, that's what the FM manual says.
FM is not ACID compliant.
That's facts, not opinions.
Just think of what the future could be if FM gave up on the data and the scripting and stuck to providing the front-end. FM Inc should get its ESS stuff to fully cooperate with psqlodbc. And get its script engine to support SQL.
If you believe this, you too can request features here...
I want to connect to a POSTGRES database server via FILEMAKER. I`m using MAC OS.
What should I make to get it done?
thanks any help!
I'm using Filemaker 10 now, and it connects really easily to MySQL using the Actual driver sold here: http://www.actualtech.com/product_opensourcedatabases.php It makes Filemaker a really great front end to a MySQL database. Learned about how to do it here: http://www.amazon.com/FileMaker-Pro-10-Missing-Manual/dp/0596154232 but anyone who's ever used an ODBC datasource can figure it out (hint: open up a blank database, open up the relationship panel, then add a new table whose source is an ODBC data source).
However, the same thing isn't true for Postgresql, and the issue seems to be on Filemaker's side, not Actual's. As of Filemaker 10 you can connect to and retrieve (import, whatever) data from a Postgresql database, but you can't simply link to it and use FileMaker as your front end to Postgres. That's too bad - I'm waiting, because increasingly I like Postgres better than Mysql.
As the previous poster 'fm_on_pg' alluded - I'd personally rather fly to Honolulu then ride a bike.
FM is a great front end and has a fantastic mobile client. But the db itself is laughable in comparison to an enterprise level db like Postgresql. The fact that OS X now comes with Postgresql baked in and that FM still has no ESS support is in a word 'bizarre'.
If Microsoft Access ever came out with a mobile application like FM Go I would likely jump ship immediately as at least Access supports full ODBC access with just about every db including Postgresql.
Wake up FM. Just because Apple owns you doesn't mean you should sit on your you know what doing nothing. You need to stay on top and remain there or else Access GO will come along and eat you for lunch.
Chat with the Actual guys. They walked me through making a single line change to the ini file and making their PostgreSQL driver 'look like' mySQL to FileMaker; thus picky up support for ESS from FileMaker...
Would you mind sharing the one line change to the ini file? Was there a special PostgreSQL driver? You said 'their...driver' rather than the one that can be found here: psqlodbc - PostgreSQL ODBC driver .
This is an old topic, Tom, but references the Actual Tech. drivers. Remember that the driver is placed on the machine making the calls, not the SQL server machine. For Mac: http://www.actualtech.com
They have Macintosh drivers for many external sources (including Access!)
If, however you are on a Windows machine, then the drivers provided by the DB companies are the ones to use (dependent on Win. version, FM version, and DB version, possibly)