Excellent observation. I've altered the code to close the connection as well as the resultset and will respond back to confirm that change does allow another dynamic odbc connection to be opened without restarting coldfusion.
> I do not use dynamic odbc excel connections much. But one thing that jumps > out at me is you are closing the resultset, but not the connection object. > Always close both, and use error handling to make sure the objects are > properly closed in the event of an error. > > But you might also consider using a fixed datasource instead. IIRC, you can > read excel files dynamically using a single MS Access or Excel/odbc > datasource. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:323644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
