<< Click to Display Table of Contents >> Navigation:  Configuration > App Config Files > connectionStrings.config

The connectionStrings.config file is typically found in the \Program Files\EarthSoft\Enterprise7\bin\ folder. The web.config file, the EarthSoft.Workflow.Service.exe.config file, and the register.exe.config file reference the connectionStrings.config file as the shared source for database connections. The connectionStrings.config file manages one or more connections. If there is only one entry as shown in the following example, the value of the name attribute should be "localhost". In this configuration, the name "localhost" will match any URL.

 

Default File

 

<connectionStrings>

 <clear/>

 <!-- Enter your EQuIS database connection string information here -->

  <!-- Example:  connectionString="Data Source=localhost;User ID=username;Password=pwd;Database=demo;" -->

 <add name="localhost" connectionString="" providerName="EarthSoft.Common.Data.SqlConnection" />

</connectionStrings>

 

 

If more than one name entry is present, the value of the name attribute must be a unique URL fragment for the web application. No name attribute value may be a sub-string of another entry.

 

 

The attribute providerName must be the following value: EarthSoft.Common.Data.SqlConnection

 

The attribute connectionString may be any valid ADO.Net connection string value. See SqlConnection.ConnectionString for more information.

 

 

If the process opening the connectionStrings.config file has write permission on the file, the connection string will be encrypted and written back the first time the entry is used.

 

 

Example

 

<connectionStrings>

 <clear/>

 <!-- Enter your EQuIS database connection string information here -->

  <!-- Example:  connectionString="Data Source=localhost;User ID=username;Password=pwd;Database=demo;" -->

 <add name="subdomain1.example.com/SQL" connectionString="Data Source=SQLDB01;User ID=equis_svc;Password=jX45*so36WV7pH;Database=subdomain1;pooling=true;Connection Timeout=600;" providerName="EarthSoft.Common.Data.SqlConnection" />

 <add name="subdomain2.example.com/SQL2" connectionString="Data Source=SQLDB02;User ID=equis_svc;Password=jX45*so36WV7pH;Database=subdomain2;pooling=true;Connection Timeout=600;" providerName="EarthSoft.Common.Data.SqlConnection" />

 <add name="subdomain3.example.com/SQL3" connectionString="f9oeH5Pss59nf39SSV1ksu5lOS79Bys4GS3fo4D" providerName="EarthSoft.Common.Data.SqlConnection" />

</connectionStrings>