Why would Excel ODBC data sources that have been working for several months all of a sudden all break?
We have a CF application that uses about a dozen different Excel spreadsheets for data sources. Depending on the type of report requested, we query one of the Excel spreadsheets using ODBC to pull out data and then we build the report. This has worked fine since last October. Last week we upgraded our server from CF 4.5.1 to 5.0 and it still worked fine - until yesterday. We made no changes to the CF server configuration yesterday and we did not upload new files. The only out-of-the-ordinary thing that happened yesterday is that we had a team reviewing each page on our site using a new desktop image that will be distributed throughout our organization. They successfully accessed each of the types of reports in this application without getting any errors on the Excel data sources. It wasn't till later in the afternoon that we discovered this problem. I could not verify any of the Excel data sources through CF Administrator. I tried uploading new Excel files to the server and they would not verify. I tried opening and saving a file and then uploading it and it still would not verify. Stopping and restarting the CF service fixed the problem, but I'd like to find out what caused it in the first place. Any ideas on what broke our Excel ODBC data sources? Thanks! George ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
