Oracle Examples - Data Capture Server - English - Foundation 22.1 - OnBase - Essential - Premier - Standard - external - Standard - Essential - Premier

Data Capture Server Deployment Guide

Platform
OnBase
Product
Data Capture Server
Release
Foundation 22.1
License
Standard
Essential
Premier

This connection string would create a data source is called ConnectOracle, used to connect to the Oracle database TestDB:

<connectionStrings>

<add name="ConnectOracle" connectionString="Data Source=TestDB;

User Id=username;Password=password"

providerName="Oracle.ManagedDataAccess.Client"/>

</connectionStrings>

Similarly, this example would connect to the same database, but it would use OS Authentication instead of database user authentication:

<connectionStrings>

<add name="ConnectOracle" connectionString="Data Source=TestDB;

User Id=/" providerName="Oracle.ManagedDataAccess.Client"/>

</connectionStrings>

The following example would connect to the same database, but it uses the connect descriptor for the Oracle database:

<connectionStrings>

<add name="ConnectOracle"

connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)

(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TestDB)));

User Id=username;Password=password"

providerName="Oracle.ManagedDataAccess.Client"/>

</connectionStrings>