a) Oracle Developer Tools for Visual Studio (126.96.36.199.2)
b) Oracle Data Provider for .NET 2.0 and 4 (188.8.131.52.2)
c) Oracle Providers for ASP.NET 2.0 and 4 (184.108.40.206.2)
d) Oracle Database Extensions for .NET 2.0 and 4 (220.127.116.11.2) -- upgrade only
e) Oracle Services for Microsoft Transaction Server (18.104.22.168.0)
f) Oracle Provider for OLE DB (22.214.171.124.0)
g) Oracle Objects for OLE (126.96.36.199.0)
h) Oracle ODBC Driver (188.8.131.52.0)
i) Oracle SQL*Plus (184.108.40.206.0)
j) Oracle Instant Client (220.127.116.11.0)
k) Oracle Universal Installer (18.104.22.168.0)
The following items are required for ODAC:
Windows operating system 32-bit: Windows 7 (Professional, Enterprise, Ultimate editions), Windows Server 2008, Windows Vista (Business, Enterprise, Ultimate editions), Windows Server 2003, Windows Server 2003 R2, Windows XP Professional
x64: Windows 7 (Professional, Enterprise, Ultimate editions), Windows Server 2008 R2 and Windows Server 2008 (all editions, except HPC), Windows Vista (Business, Enterprise, Ultimate editions), Windows Server 2003, Windows Server 2003 R2, Windows XP
Microsoft .NET Framework 2.0, 3.0, 3.5, or 4
Note: .NET Framework 1.x is not supported.
Access to an Oracle Database Server (Oracle 9i Release 2 or later)
If you use .NET Framework 2.0, 3.0, and 3.5, then only the following ODAC .NET components are supported
ODP.NET for .NET 2.0
Oracle Providers for ASP.NET for .NET 2.0
Oracle Database Extensions for .NET 2.0
If you use .NET Framework 4 or .NET Framework 4 Client Profile, then only the following ODAC .NET components are supported
ODP.NET for .NET 4
Oracle Providers for ASP.NET for .NET 4 -- not supported with .NET Framework 4 Client Profile
Oracle Database Extensions for .NET 2.0
Oracle Database Extensions for .NET 4
Oracle Services for Microsoft Transaction Server, which is included. Required only for applications using distributed transactions.
Note: Microsoft introduced changes to the Distributed Transaction Coordinator (DTC) with Windows Vista and Windows Server 2008. Oracle Services for MTS support this new DTC when the minimum operating system level is Windows Vista with Service Pack 1 or Windows Server 2008.
Oracle Developer Tools for Visual Studio requires either Visual Studio 2010, Visual Studio 2008, or Visual Studio 2005.
Note: Visual Studio Express Editions are not supported with the Oracle Developer Tools. However, ODP.NET is supported with Visual Studio Express Edition.
Oracle Database Extensions for .NET, a server feature of Oracle Database 10.2 and higher, can only be upgraded with this ODAC release. You must already have Oracle Database Extensions for .NET 22.214.171.124.0 installed and configured on the Oracle database server in the same Oracle Home where Oracle Database Extensions for .NET 126.96.36.199.2 will be installed.
The instructions below apply to installing ODAC using Oracle Universal Installer. For instructions on xcopy ODAC installation, refer to the README included with that particular installation.
Note: Oracle ODBC Driver and SQL*Plus are not listed separately as individually installable items in the OUI tree view control. If you wish to install these two products, choose Oracle Instant Client in the tree view control.
There are a number of methods to connect Oracle client to a database server. Two of the most common include EZCONNECT and TNSNAMES. EZCONNECT is the easiest to setup. TNSNAMES is much more maintainable in the long term. If you are new to Oracle, we recommend you use EZCONNECT. You only have to choose one or the other to connect.
These quick start instructions assume you have a valid username and password for the database server.
Note: In the setup instructions below, ORACLE_HOME represents the directory where the Oracle client Home was installed on your machine. A typical directory for an OUI Oracle client Home is:
You will need to know where this directory is before proceeding.
Copy the sqlnet.ora file located in the following directory: ORACLE_HOME\Network\Admin\Sample\ to this directory: ORACLE_HOME\Network\Admin\
This file tells the Oracle client by what methods (e.g. EZCONNECT) Oracle client can connect to the Oracle database server.
The Oracle client must then specify a valid user name, password, and data source to connect to the database server. To specify a data source, you can use the EZCONNECT format. In the ODP.NET data source attribute, use the following format to define how the client connects to the database server:
host = the database server machine's host name
port = the database server machine's port on which it listens for incoming connection requests
service_name = the database's global name
For example, some syntactically valid connection strings follow:
"user id=hr;password=hr;data source=//sales-server:1521/sales.us.acme.com" "user id=hr;password=hr;data source=//sales-server/sales.us.acme.com" "user id=hr;password=hr;data source=sales-server/sales.us.acme.com"
An Oracle Net service name allows the Oracle client to use a simple alias to connect to the database server. The alias definition contains all the information needed to create a connection to the database server. Alias information is stored in the tnsnames.ora file typically located in the ORACLE_HOME\Network\Admin directory. This alias is used as the data source value in your connection string. ODAC installations do not create a tnsnames.ora file so you need to create one. Alternatively, you can copy an existing tnsnames.ora file from an existing Oracle client installation to your new ODAC installation. The following instructions assume you will have to create a new tnsnames.ora file.
Copy the tnsnames.ora file located in the following directory: ORACLE_HOME\Network\Admin\Sample\ to this directory: ORACLE_HOME\Network\Admin\ = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
)(PORT = )) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ) ) )
data source alias = the shortcut name given to identify the connect descriptor. In the ODP.NET connection string, developers set the "Data Source" attribute to the data source alias.
hostname or IP = the database server machine's host name or IP address
port = the database server machine's port on which it listens for incoming connection requests. In general, this value is set to port "1521". database service name = the database's global name
The data source alias, hostname/IP, port, and database service name in the tnsnames.ora should be modified appropriately. If the TNS entries in the ORACLE_HOME\network\admin\tnsnames.ora file are not recognized by the Oracle client, create a ORACLE_HOME\oracle.key file using any text editor and type in the following line:SOFTWARE\ORACLE\
< home key >
The PDF and HTML documentation can be viewed from the ORACLE_HOME\ODACDoc\DocumentationLibrary\welcome.html page. To view this page, go to Start Menu
--> Oracle - < Oracle Home > --> Application Development --> Oracle Data Access Components Documentation.
Additionally, the Oracle documentation is installed as part of Visual Studio Dynamic Help.
For any bugs and issues, you may participate in one of the OTN discussion forums for ODAC.