Gerald, embedded MSSQL is usually for direct sql coding from source, it's going to be headache to change the current code base, and how well it would work may also be a variable. Interesting idea about H2, the switch could be costly, but I don't know much about it, mySQL requires multiples pieces (core db engine, odbc connector and it gui tool etc are not bundled as one., which version matches which is a real issue but could be for compatibility... downloaded all three components, and ran a script to installed them all, status indciated successful for all, and yet, failed to connect to the server... (the box had an old version but mySQL doc says its latest version does not care about it...)
Probably my best bet to stick to sql server express but set teeth into the root cause of installation problem for average users, and go from there. I appreciate it. Don >MSSQL has an embedded version that requires no install. I have not tried it >with CF but it might be worth a look. H2 is another DB you might want to >look at. Sava/ Mura CMS uses it for their Express version. Uses Railo to >boot. Gotta love LGPL. > >Out of curiosity, what features do you require that MySQL could not provide? >It is fast, stable, mature, has a pretty small foot print and requires no >install. > >G! > > >On Fri, May 29, 2009 at 9:39 AM, D > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4