I was playing around Smith and got a SQLite data source working. The steps I used are mentioned in their forum and probably have enough hints for using the JDBC driver with CFMX:
http://www.smithproject.org/forum/posts/listByUser/16.page Otherwise, I think you should be able to the SQLite ODBC driver with CFMX (which is easier to setup). I have always used the SQLite DB browser tool to create the tables and then used PHP for the server side web stuff. If they open source Smith then I will convert that project to CFML. Best, David ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4