About releasing database connections

Releasing database connections is helpful when you want to perform database maintenance tasks, especially if you are using a Microsoft Access database. Access databases cannot be moved, updated, or deleted while ColdFusion Server is running. You may also want to release a database connection when it is processing slowly or hanging. Releasing the connection provides a way to terminate the process without restarting the server.

 

Unless you disable the database connection for a data source before you release the connection, it remains released only until a request is made that requires the server to reconnect to that data source. To ensure that a connection is disabled during your maintenance period, access the ColdFusion Settings page for the data source and disable the connection. For details about releasing database connections, see View and manage data source connections.

Related topics