| Note | ||
|---|---|---|
| ||
This topic is for customer who are using Oracle unmanaged drivers. GenerallyGenerally, this topic will be relevant to customers who are using an Oracle database where the original version of ET installed was 4.7 or earlyearlier.
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. |
...
These instructions only apply when using the unmanaged Oracle driver, we strongly recommend for new customers to use the managed oracle driver, which does not require installation of additional software (ODAC) on their ET Enterprise Tester server.
Enterprise Tester no longer ships with Oracle drivers. To use Enterprise Tester with an Oracle database you must download and install the Oracle ODP.Net drivers from the Oracle website (part of ODAC). You can install either:
...
Enterprise Tester is a .Net Framework application and makes use of ODP.Net to connect to Oracle databases.
ODP.Net provides a an ADO.Net Provider for Oracle, which communicates with Oracle using the native drivers.
...
Please visit the Oracle website to download the latest ODAC release - for convenience I have included links to both these are below:
...
If you have downloaded an ODAC release with an installer, you can now install it (as per instructions accompanying the download) - each release changes the installer slightly, so I this process won't document this process be documented here. More details are here on the Oracle site.
...
| Code Block |
|---|
Data Source=TORCL;User Id=myUsername;Password=myPassword; |
Using Integrated Security
| Code Block |
|---|
Data Source=TORCL;Integrated Security=SSPI; |
Using ODP.NET without tnsnames.ora
| Code Block |
|---|
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT =MyPort)))(CONNECT_DATA=(SERVER=DEDICATED (SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword; |
...