Perhaps just dump the subscriber list to a csv file, and use that as the input to your app... Assuming it's a once a month affair it could work.
At 11:14 PM 7/9/02, you wrote: >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 >> > >> > >> >> > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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

