Specify the Database Connection String - Tools - Foundation 23.1 - Foundation 23.1 - Brainware - external

Brainware Intelligent Capture Tools

Foundation 23.1

To specify the database connection string, complete the following steps.

  1. Open DstPmt.exe.config in a text editor.
  2. Search for the <connectionStrings> element.
  3. For a SQL Server database, modify the following values.
    • Set Data Source.
    • Set Initial Catalog to the SQL Server database catalog.
    • Set User ID to the SQL Server user ID.
    • Set Password to the SQL Server password.
    <add name="Entities" connectionString="metadata=res://*/Entity.Entities.csdl|res://*/Entity.Entities.ssdl|r es://*/Entity.Entities.msl; provider=System.Data.SqlClient;provider connection string=&quot;Data Source=<DataSource>;Initial Catalog=<SQLServerDatabaseCatalog>;Integrated Security=false;User ID=<UserId>;Password=<UserPassword>;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  4. For an ORACLE database, modify the following values.
    • Set Data Source.
    • Set User ID to the service account user ID.
    • Set Password to the service account password.
    <add name="Entities" connectionString="metadata=res://*/Entity.ORAEntities.csdl|res://*/Entity.ORAEntities. ssdl|res://*/Entity.ORAEntities.msl; provider=EFOracleProvider; Provider Connection String='Data Source=<OracleServerName\InstanceName>;User ID=<UserID>;Password=<UserPassword>'" providerName="System.Data.EntityClient" />
  5. Save and close the file.