Release all cached Data Source connections

[Sameer]

Hello,

I am using CF5 and I was wondering how to programmatically do similar action
contained in CF Administrator (Data Sources --> Connection Summary --> 2
Buttons) for : -

1. Release all cached Data Source connections, and

2. Verify all Data Source connections


My objective is to release cached ODBC conncetions on a daily basis and
re-establishing/verifying them back again, al programmtically by means of
scheduler.

Any pointers ?

Sameer.

[MikerRoo]

Not sure why you'd want to do such a thing. But have just discovered that it
is possible in CF7 using the admin API...
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
wwhelp.htm?context=ColdFusion_Documentation&fi le=part_adm.htm Alas, I
don't think there is any equivalent for CF 5. (They really made huge
improvements with CF MX). However, the html spoofing methods may work with CF5
since the security was not as good. You can try posting the same forms that
the CF5 administror does (cross site hacking 101). Good Luck, -- MikeR