Hi, I would also like to know how you got CFMX to run on Mac OSX. Is it running on Mac OSX server or the desktop version?
To answer your question about migrating from Access to MySQL. I simply set up the MySQL db then in Access export the tables using ODBC to the MySQL db. You'll need to setup a dsn to point to the MySQL db. Once you have exported all of the tables you'll need to alter the data types of the columns as they will all be different from what you had on the Access db. I just go through and do lots of alter table tblname modify etc etc... for each table in the mySQL db. If you need any other info then please let me know. Cheers Dave At 11:22 6/30/2002 +0800, you wrote: >Please let me know how you made ColdFusion work on MacOSX. > >P.V.Anthony > >----- Original Message ----- >From: "Dick Applebaum" <[EMAIL PROTECTED]> >To: "CF-Linux" <[EMAIL PROTECTED]> >Sent: Sunday, June 30, 2002 1:52 AM >Subject: CFMX Linux - can you use a MS-Access db > > > > I am new to CF-Linux -- I posted this to CF=Talk, but may have better > > results here. > > > > I am running CfMX Linux (Well, actually on Mac OS X). > > > > I want to convert some MS-Access db's that I have to MySQL, PostgreSQL, > > etc. > > > > I would like to do this with ColdFusion... I already have the CF > > programs from a prior migration to MS-SQL (available on a remote hosted > > site). > > > > I want to functionally duplicate these Access databases on a local site > > using MySQL, PostgreSQL, etc. (I don't have MS-SQL locally). > > > > I already have CF programs that read the Access dbs, then create and > > populate the equivalent on (whatever). > > > > My question is this: > > > > Can I Use CFMX running on non-windows, non-intel to get at the existing > > MS-Access mdbs? > > > > TIA > > > > Dick > > > > > ______________________________________________________________________ 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 ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
