I have written some code which dynamically modifies the database directory
location for a Microsoft dBase ODBC DSN using registry manipulation with
CFREGISTRY. My problem is that when the directory changes it seems as
though ColdFusion has cached or is holding on to the original connection
because as I iterate of multiple file databases I keep getting results from
the first database directory location. If I go to the ColdFusion Admin I
can see that the directory is changing but I cannot get "fresh" results
unless I click Update or re-verify my DSN is the administrator.
Is there a way to programmatically refresh my datasource connection as I
iterate over my different file locations so that CF does not hang onto the
initial file? I have tried unchecking the "maintain database connection"
box but that does not help. I am using CF 4.01 on NT. If I were using CF
4.5 would this be possible?
Thanks
Aaron
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
