Probably less elegant than you are looking for, and certainly not an answer to your problem, but having the users upload a .csv file and then using cffile to read the contents to a variable and then loop through that to insert into SQL Server might also work.
Pete On Thu, 17 Feb 2005 15:24:19 -0000, Mark Smyth <[EMAIL PROTECTED]> wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195176 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
