> Doable, but don't. True.
Best way to work with this is to export data and import into a SQL database. Something else to consider... Filemaker 5.5 includes the ability to udate, insert, delete SQL statements using dynamic data. So, if the client can connect to a SQL database, you could have them "push" the data into your datasource. Dave ----- Original Message ----- From: "Ben Forta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 4:58 PM Subject: RE: FileMaker Pro & Cold Fusion ? > 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
