Let me know if this would work.  I have a single application that wants to switch databases on the ES Server side.  If I have Multiplae DataSourceConnections like the sample below, should I just be able to change the RemoteDataSourceKey in the call without any other modifactions?   Second if I'm adding ConnectionStrings does this read in real time or is it populated on the start of the server.  Basically I would need to know if the Server is caching this configure or I could add Databases on the fly.

I ask the first question because I get an error if I use the DEV2 sample otherwise the MultiShip works fine.  The second would be for administration and deployment.

Thanks,

Rich

Sample:

<?xml version="1.0" encoding="utf-8" ?>

<DataSources>
 <DataSource DataSourceKey="MultiShip">
  <ConnectionString>server=localhost;Integrated Security=SSPI;Database=RZMultiShip;</ConnectionString>
  <TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
  <TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
  <TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
  <TypeAssemblyCulture>neutral</TypeAssemblyCulture>
  <TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
  <IsEncrypted>True</IsEncrypted>
  <IsCompressed>True</IsCompressed>
  <EncryptionKey>151, 123, 237, 154, 69, 13, 132, 130, 233, 174, 208, 232, 85, 162, 40, 169, 161, 0, 140, 40, 47, 163, 98, 73</EncryptionKey>
  <EncryptionVector>133, 78, 229, 207, 101, 227, 102, 225</EncryptionVector>
  <TransactionTimeout>3600</TransactionTimeout>
 </DataSource>
 <DataSource DataSourceKey="">
  <ConnectionString>server=localhost;Integrated Security=SSPI;Database=RZMultiShip3;</ConnectionString>
  <TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
  <TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
  <TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
  <TypeAssemblyCulture>neutral</TypeAssemblyCulture>
  <TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
  <IsEncrypted>True</IsEncrypted>
  <IsCompressed>True</IsCompressed>
  <EncryptionKey>151, 123, 237, 154, 69, 13, 132, 130, 233, 174, 208, 232, 85, 162, 40, 169, 161, 0, 140, 40, 47, 163, 98, 73</EncryptionKey>
  <EncryptionVector>133, 78, 229, 207, 101, 227, 102, 225</EncryptionVector>
  <TransactionTimeout>3600</TransactionTimeout>
 </DataSource>
 <DataSource DataSourceKey="Dev2">
  <ConnectionString>server=localhost;Integrated Security=SSPI;Database=RZMultiShip2;</ConnectionString>
  <TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
  <TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
  <TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
  <TypeAssemblyCulture>neutral</TypeAssemblyCulture>
  <TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
  <IsEncrypted>True</IsEncrypted>
  <IsCompressed>True</IsCompressed>
  <EncryptionKey>151, 123, 237, 154, 69, 13, 132, 130, 233, 174, 208, 232, 85, 162, 40, 169, 161, 0, 140, 40, 47, 163, 98, 73</EncryptionKey>
  <EncryptionVector>133, 78, 229, 207, 101, 227, 102, 225</EncryptionVector>
  <TransactionTimeout>3600</TransactionTimeout>
 </DataSource>
</DataSources>