Thanks Matt, Peter for your advise. The situation I'm in is my customer is given MS Access databases which contains subscribers' info. He needs to use the data to generate newsletter emails to these subscribers. Unfortunately, the hosting setup is on Linux and that's what I was concerned about. Part of my app will be to to read in targeted subscribers in the database and send the email newsletter out. From your responses, does that mean the best way would be to migrate the data from the MS Access database to MySQL/Postgres everytime?
Thank you and regards David Siew -----Original Message----- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: 10 July 2002 13:47 To: CF-Talk Subject: RE: Access on CFMX Linux? Generally speaking, nothing should be referred to as a database unless it is ACID compliant. MySQL is not ACID compliant therefore it makes more sense to think of it as a SQL interface to a file system than a database. Matt Liotta President & CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] > -----Original Message----- > From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 09, 2002 10:26 PM > To: CF-Talk > Subject: RE: Access on CFMX Linux? > > Like MySQL > > -----Original Message----- > From: Matt Liotta [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 10 July 2002 3:20 PM > To: CF-Talk > Subject: RE: Access on CFMX Linux? > > > Well, yes and no. It is possible to run MS Access using Wine, but I would > highly recommend against it. If you are just looking for a cheap (free > even) > database that is easy to use and works with CFMX then check out some of > the > open source databases. > > Matt Liotta > President & CEO > Montara Software, Inc. > http://www.montarasoftware.com/ > V: 415-577-8070 > F: 415-341-8906 > P: [EMAIL PROTECTED] > > > -----Original Message----- > > From: David Siew [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, July 09, 2002 10:25 PM > > To: CF-Talk > > Subject: Access on CFMX Linux? > > > > Hi all, > > > > Sorry. I havent got experience with CF on Linux. > > > > Is there anyway that I can set up a MS Access database as a datasource > > on a Linux server installed with CFMX? Any advise is much appreciated. > > > > Thank you and regards > > David > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
