We use Filemaker 8 quite a bit. The production department at our paper uses it for a number of things. Any data that we need for our website I grab out of Filemaker using <cfquery> and store it on our SQL Server db. JDBC support is pretty good. I don't know how it will hold up in terms of high load performance. We have generally not more than a handful of users accessing the server at once. When we did use it for a conference registration app last year we ran into some bottlenecks, though my IT guys claim it was a network problem, not Filemaker.
I've pasted below the instructions I found sometime ago on how to set this up so you can add Filemaker DSNs in the CF Admin. Rick ------------------------------------------------------------------------- In Filemaker FMpro database needs to be open! Enable ODBC/JDBC sharing in FMpro. Create a Username/password for coldfusion in your database. Install the JDBC drvier from the FM CD - run the .jar file from the CD, it's an installer which will prompt for an install location, create and choose ~/desktop/newfolder/ and when the installer is finished copy the contents of ~/desktop/newfolder/driver/lib/ (sljc.jar and sljcne.rar) to your CF7 /lib/ folder In Coldfusion: create a data source using 'other' as the driver type. JDBC URL= 'jdbc:sequelink://127.0.0.1:2399;serverdatasource=test' Driver class= com.ddtek.jdbc.sequelink.SequeLinkDriver Driver name= whatever you want, 'FM Pro' or something User Name= the user you created earlier in your FM database Password= the pass for the FM user you made. Submit, and then verify - you should get a lovely understated little 'OK' in status On Tue, Dec 9, 2008 at 6:10 PM, cfcom <[EMAIL PROTECTED]> wrote: > Does any one have any experience using CF with Filemaker... good, bad, etc > > > Thanks > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316576 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
