Hi Chaps could use some advice here. Coldfusion 6.1. The scenario is a user uploads an excel spreadsheet which then needs to be imported into SQL Server.
I've set up an ODBC connection to the uploaded spreadsheet (it'll be the same name, same location every time) and then a odbc socket in the administrator as per: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18656 Now this all works fine, but its maintaining the lock on the spreadsheet after the page has finished processing, which will make it impossible to upload a new one. The only way I have found a way round it so far is to restart the ODBC server service (or cfmx service), which is not really workable. I've tried everything I though might work, for example: run a query against a non existant query/datasource to try and relase the lock (like the old access lock workaround) ran a query against another spreadsheet via a different odbc socket to try to release the query. Tried the purgeQueryCache() and ["disable"] methods of the datasource factory. But no luck, its still maintaining the lock any ideas? thanks mark Mark Smyth Certified Advanced ColdFusion MX Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195168 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
