Issue with Oracle connectivity

Topics: Data Access Application Block
Apr 6, 2007 at 8:11 PM
Hi, I'm writing a little service that would come up every five seconds, or so and verify that a certain DB connection is alive and well. If not it is supposed to remove TNSNAMES.ORA file, copy a new one in it's place, and test again, until a exaust all files or until I find the one that works. The problem is that inside a Win Process DatabaseFactory.CreateDatabase() cashes the original object so I cannot get a truly freshly minted instance of a Database class, whic slightly undermines my whole strategy. I obviously do not want to override the whole EL, but short of running an external executable I'm sort of out of options - any suggestions?