connectionStrings.config

<< Click to Display Table of Contents >>

EQuIS 7  >>  Configuration > App Config Files >

connectionStrings.config

connectionStrings.config is found in the \Program Files\EarthSoft\Enterprise6\bin\ folder. It referenced by web.config, EarthSoft.Workflow.Service.exe.config, and register.exe.config as the shared source for database connections. It 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 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 substring of another entry.

 

Example:

These entries are invalid since the 2nd is a sub string of the first.

<add name="servername/equis6"...

<add name="servername/equis"...

 

These entries are valid URL fragments

<add name="servername/projA"...

<add name="servername/projB"...

 

 

The attribute providerName may have one of the following values

EarthSoft.Common.Data.SqlConnection

EarthSoft.Common.Data.OracleConnection

 

The attribute connectionString may be any valid ADO.Net connection string value.

SqlConnection.ConnectionString

OracleConnection.ConnectionString

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

 

 

Example 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="subdomain1.example.com/SQL" connectionString="Data Source=;User ID=;Password=;Database=;pooling=true;Connection Timeout=600;" providerName="EarthSoft.Common.Data.SqlConnection" />

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

</connectionStrings>