Valid Oracle Database Connection String for DAS or DB Query Action

Issue

You can use DAS to connect to any database for which an OLE DB driver is available. The Data Access Service in TotalAgility supports connections to Oracle databases.  

Before you can create a DB query action, you must set up a database connection string.

Below details those Oracle Database Connection strings which may be used.

Solution

Standard Security
This connection string uses a provider from Oracle. 
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
 
 
Trusted Connection
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;

Level of Complexity 

Easy

Applies to