Dick, Hope the openlink drivers work out. Now onto more important info. Being that I'm splurging on a new Apple PowerBook (when ever they release the next speed bump), the first thing I thought of is running cf on the laptop so I could run around to clients and show them examples with cf running.
I read this acticle from O'reily http://www.oreillynet.com/pub/a/javascript/2002/06/21/coldfusion_one.html Is this the way you set it up? If so, how's MX running for you (speed wise). I want to run it with mysql for the database. My dreams would come true if things are quick on the Mac! Brett At 10:25 PM 10/9/02 -0700, you wrote: >On Wednesday, October 9, 2002, at 08:34 PM, Brett Frisch wrote: > > > I finally understand where you're coming from on this. I do have a > > quick > > question for you: > > > > In your initial question you stated that you made a cf script convert > > the > > access DB into ms sql or oracle. How did you convert that info back > > to the > > access DB file? I haven't used access in a long time and never heard > > of > > that. I could actually use that for one client right now. > > > > >Brett > >Traditionally, you would dump to a CSV file, etc. > >With the OpenLink setup, you can process the MS-Access database, with >CFMX, just as you would any other online db -- create,drop and >populate tables--- so you could use the original MS-Access tables, >delete all the records, then repopulate them from the online data >(denormalizing in the process if necessary). > >Again, one big advantage is that all the logic is contained in >program(s) that are repeatable -- if you need to do this every quarter, >just run the programs. > >I have one client that has a web-centric database -- totally maintained >on line. At the end of the year they need to make offline MS-Access >copies of the database for reporting and statistical analysis. Some >of the data is given to their clients and outside firms for analysis, >marketing, etc. MS-Access is an excellent common denominator for this >purpose -- and they do not expose the online database (SQL-Server , in >this instance). > >I am really jazzed to have this capability on the (non-windows) >desktop, and to be able to choose a Host platform without limiting it >to one that can manipulate MS-Access dbs. > >Stated simply -- CFMX on OS X or Linux can now use MS-Access dbs! > > >Dick > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ 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.
