> How hard is it to get MySQL working on NT? Its pretty easy, but it doesn't hurt to have a set of instructions. I posted a step-by-step set of those a few days ago here for another user. Check the archives. The only thing I left out was that when you run the mysqld-nt.exe file, make sure to use the ''--install'' parameter.
> How hard is it to get CF working with MySQL? I can't seem to > find anything on the >CF website about this. Again, its easy once you've done it once or twice. You'll need to manage your dsn's via Windows ODBC, but once you put them in CF can see them just fine. See those instructions I referenced above. > Is it possible to convert a MySQL database to MS Access? Using CF and SQL you could create a copier that sends data to an Access dsn. Thats one way. Using the new myODBC drivers I believe this has been made somewhat easier to accomplish natively, although its a one-way process (and I forget whether the direction is Access --> mySQL or mySQL --> Access). Check their web site and the myODBC 3.51 drivers. It may be smarter to stick with myODBC 2.5x and use CF. > Would I want to do this? Not unless your client stakes you to an anthill and pours honey all over you. > Is MySQL any better than MS Access? Better question: "is anything worse than MS Access?" Perfomance issues aside (mySQL has *much* better speed, *much* better load-handling capability, no discernible memory leaks in their stable-release odbc drivers) its also dirt-simple to work with once you get a decent front end on it (those instrs have a link in them for this as well). mySQL is not quite an enterprise-level heavy-hitter like SQL Server, Oracle et al, but it is a superb Access replacement for low- to medium-traffic sites, in my opinion. --Matt-- ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
