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

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

Brainware Intelligent Capture Tools

Platform

Brainware

Product

Tools

Release

Foundation 23.1

License

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

Open DstPmt.exe.config in a text editor.
Search for the <connectionStrings> element.

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.

<connectionStrings>
<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" />
</connectionStrings>

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.

<connectionStrings>
<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" />
</connectionStrings>

Save and close the file.