Doable, but don't. Not that I have anything against FileMaker, it's a great entry-level desktop database, but it was never designed for use in a Web environment, and the ODBC interface is far from ideal.
For example ... * FileMaker must be running (actual app open) for the ODBC driver to work (so you have to leave the machine logged in). Machine restarts, no app. * The actual databases must be open (the driver only sees open databases), as the client makes requests the application actually moves (the screen changes to reflect the selections). So even if you could auto-start the app you'd have to go to the machine to open the data files. * The SQL is not clean, and Studio will not be able to display available tables etc. All in all, not a secure or reliable or even safe option. Importing the data to another DB would be a better choice. --- Ben -----Original Message----- From: Brian Simpson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 4:45 PM To: CF-Talk Subject: FileMaker Pro & Cold Fusion ? I have a customer (we host their website) that has an internal FileMaker Pro database that he was to put on the web. Can Cold Fusion ODBC directly to FileMaker Pro database? Does anyone know if this can be done or does his database have to be converted to Access, SQL, mySQL first? Thanks Brian PS. The FileMaker Pro people didn't have a clue when I called them. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
