Cached query

[kruse]

I have got this query

<CFQUERY NAME="GetImportData" DATASOURCE="ExcelNordic"
USERNAME="#Application.SQLUserName#" PASSWORD="#Application.SQLPassword#">
SELECT *
FROM #GetSetUp.Workbook#
</CFQUERY>

It connects via ODBC to an excell sheet called ldev.xls.

But it is possible to upload a new document (Excel sheet). When I do this and
then run my query I still gets the result from the old sheet.

When I restart the service "Coldfusion MX 7 ODBC Server" it works again until
i change the document.

Is there something I can do from the code. The user should not be able to
restart a service on the server.

Br Morten

[JMGibson3]

Do you have Maintain Connections checked in the Administrator for the
DataSource? If so, you should leave it unchecked (for Excel for sure, many
would argue for all DataSources). Just guessing but maybe Maintain on an Excel
means retain a pointer to the exact physical address on disk of the Excel
sheet, even though the DOS/FAT has been changed to a new disk location.

[kruse]

I had set the Maintain Connections. But then I set the timeout and interval to some lower values and now it works just fine.