| Table of Contents |
|---|
Overview
Within the web folder you will find the file "web.config" - this is a XML file containing a number of settings which configure settings for the Enterprise Tester application, including what type of database to connect to and its connection string details.
...
| Tip |
|---|
We provide example connection strings for each database, but each database supports a number of different connection options - we recommend consulting the http://connectionstrings.com/ website for listings of the different connection strings you can try. |
SQL Server
By default the web.config file comes with the settings necessary to connect to Sql Server or Sql Server Express - all you need to do is provide a connection string.
...
| Code Block |
|---|
<add name="Default" connectionString="Server=Server123;Database=EnterpriseTester;User ID=bob;Password=pass123;Trusted_Connection=False;" /> |
Oracle
Enterprise Tester ships with 2 different Oracle drivers. For new installations we would recommend using the Managed Oracle driver.
Managed Oracle Driver
Change Enterprise Tester to use these values:
...
| Code Block |
|---|
<add name="Default" connectionString="User ID=SYSTEM;Password=password;Data Source=192.168.1.10:1521/orcl"/> |
Unmanaged Oracle Driver
| Note | ||
|---|---|---|
| ||
This topic is for customer who are using Oracle unmanaged drivers. Generally, this topic will be relevant to customers who are using an Oracle database where the original version of ET installed was 4.7 or early. New Installations of Enterprise Tester Enterprise Tester 4.8 and above supports managed ODP.Net drivers. No separate installation is required for managed ODP.Net drivers. We recommended using the managed drivers by all new Enterprise Tester customers who wish to connect to an Oracle database. For details on configuration settings required to be set in the web.config for the Oracle managed drivers please consult the "Database Configuration" topic. |
...
For more examples of Oracle ODP.Net connection strings, please see: http://connectionstrings.com/oracle#p12
PostgreSql
Change Enterprise Tester to use these values:
...
| Code Block |
|---|
<add name="Default" connectionString="Server=192.168.1.10;Port=5432;Database=et-prod;User Id=postgres;Password=Password123;Timeout=60;CommandTimeout=120;" /> |
MySql
Change Enterprise Tester to use these values:
...