disconnect from a datasource

[8ginga8]

Does any one know if there is a possible way to disconnet from an access database in coldfusion MX. I am uploading a database to our server which is to overwrite an existing database. When the new database is uploaded I want to read from it but all I get is the data from the old one. If I put in a bogus query to cause an error then try again it works fine until I upload a new one. Can anyone help

Thanks in advance...

 

[8ginga8]

I have now tried a bogus query and used a cftry and cfcatach and this did not seem to fix the problem. the only way to get it to work seems to try to upload the database to a location that does not exist and then fix the error and refresh the page and the new data is there

 

[TamedTech]

From my knowledge you should be able to overwrite the old database without having to re-create a datasource.

If you are displaying old data in a query then it sounds as if the results are cached server-side or client-side.

Try clearing the cache.

Rob

 

[Dave3462]

I haven't had this problem but, make sure that "Maintain Connections" is not checked in CF Admin data source. This has caused a lot of problems with Access connections for me.

 

[8ginga8]

that did it thanks