| 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. |
...
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; |
...