> Anyone have any pointers or examples of CF or PHP > application which have > been constructed with the ability to work on multiple > Databases? IE the > application can easily be run on MSSQL, Access, MySQL etc > and all the user > has to do is changed a config variable or point to another > DB file. > I'm trying to do the leg work now for a future upgrade to > our CMS. Right > now it runs on MSSQL, but we want to make it so users can > easily install it > into mysql, etc. > thanks in advance. > jonese
You might have a look at the onTap framework. I've already done a lot of this leg-work, plus it's got lots of nice dba features not available with native CF tools. Currently it supports MS SQL 7+, MS Access, MySQL 4 (not sure about older versions) and Oracle 8i and later. You have to set a canonical name for the server type (mssql,msaccess,mysql or oracle) but beyond that most of the db information is gathered directly from JDBC. And it's open-source, so of course, while I'd love for you to be involved in the framework community :) you're free to pillage if you'd prefer. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
