Caching the Connection String - How??

[sodakotahusker]

I was told by someone from Microsoft that I can create an MTS component and cache a connection string in it so all subsequent calls to objects within MTS can lookup the database connection string in this cache instead of reading the registry/ an ini file etc to get that string. Can anybody confirm that and explain how I can make that one object persist until MTS itself gets shut down?? Or should we store this value in the Shared Group Property Manager???

 

[jmarler]

Exactly what you just said . . . Store the value (not the object) in the Shared Property Manager (SPM or SPaM). Don't ever try to store objects in SPM and don't ever try to maintain state in your objects. These things make it so you application does not scale well. - Jeff Marler B-)