Mike, You could use the ColdFusion Admin API to create the datasource on the fly, do whatever you need to do and then kill the datasource programatically. I have a code sample but it'll be another week or so before I can get to it.
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=basiconfig_37.html On Wed, Sep 15, 2010 at 11:58 AM, Mike Kear <[email protected]> wrote: > > I have to make an Access database containing updated data from my > SQLServer database, which can be downloaded by my users by FTP. I > can make the Access database a coldfusion datasource, and fill it up > with the data I want, but I need to release it from the lock > ColdFusion puts on it. Does anyone have a technique for releasing > that lock nowdays? (I'm using CF9 Enterprise). > > IN CF5, which is the last time i used Access with ColdFusion, it was > a simple case of doing an invalid query but that doesnt work in MX > days. There was a non-documented function once as well ... > CFusion_DBConnections_Flush( ) ... but that's not valid in CF9. > > Has anyone found a way to break that connection programmatically in CF9? > > -- > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
