Disconnect connection to database in code

[lwd]

I need to include a statement in my code to "disconnect the connection to the
database once you have fetched the data necessary". I researched the
ColdFusion support area and found cfusion_dbconnections_flush(); but this has
been deprecated in ColdFusion MX.

What is the replacement for the above function? I researched this message
board and found question asking about this function in 2004 that had not been
answered.

[palibrarian]

I am also trying to break connections to our databases. We need to disconnect to all of them at the same time so we can back them up regularly. Any ideas on how this can be done, now?

[paross1]

Well, you could de-select the Maintain Connections in your data source setup in
CF administrator, so your database connections only last as long as needed. I
suppose that you may pay a performance penalty, but I have ALL of my data
sources set up this way (Oracle, MS SQL, and Access), and have never had any
significant performance issues. However, this is all dependent on your own
situation.

Phil

[MikerRoo]

For disconnecting individual data sources, the best bet is to configure them
with a short timeout.

In extreme cases, you could use the admin API (CF7) or service factory
(earlier CF) to destroy the datasource and then recreate it dynamically.

For disconnecting all DSN's at once, use the admin API to stop the ODBC
service.

More information on the admin API is
[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=7&thread[/url]
id=912668#3259306

Good Luck,
-- MikeR