ODP. Net oracle. NET database access [reprinted]

(Note: This article is helpful if you want to use the Oracle 9i Database in vs.net)

Original Author name
OTN

Original Article Source
Oracle OTN

Introduction
Introduction to ODP. net

Body
Oracle data provider for. net release 9.2.0.2.102 installation and FAQs
Author: OTN

ODP. NET offers high performance and efficient access to Oracle Data from Microsoft. NET applications.

Oracle provides a new development kit ODP. Net for DOTNET developers. ODP. Net is a set of efficient Oracle database access packages provided for Microsoft DOTNET applications.

The latest version is: Oracle data provider for. net release 9.2.0.2.102 (74 m)
: Http://otn.oracle.com/tech/windows/odpnet, download the previous example for otnuser login (OTN registered address: http://profile.oracle.com/jsp/reg/register.jsp? Src = 1180585 & act = 5 ).

The system requirements for installing ODP. NET are:
-Windows 98, Windows NT 4.0, Windows 2000, Windows XP Professional
-Oracle client (9.2.0.1.0)
-Microsoft. NET Framework
-To use the enterprise transaction management function, you must: Oracle services for Microsoft Transaction Server (9.2.0.1.0 or higher)

Installation steps:
1. Download the Installation File odpnet9202102.exe.
2. Execute and decompress the file.
3. Run the general installation program of Oracle, the program of universal installer,. \ disk1 \ install \ Win32 \ setup.exe to start.
4. After installation, you can delete the extracted files and directories.
5. Windows 98 needs to be restarted, not for other systems.

ODP. NET is installed in the ORACLE_HOME \ odp.net directory. The document is installed in the ORACLE_HOME \ odp.net \ doc directory.

About ODP. Net tutorial video: http://www.oracle.com/pls/ebn/live_viewer.main? P_shows_id = 1547368 & p_referred = undefined. You can check the details to learn more.

Below are some ODP. Net FAQs I have translated.
Original article: http://otn.oracle.com/tech/windows/odpnet/faq.html

Does ODP. Net need to be installed on the Oracle database server?
No. You only need to install it on the host that runs the DOTNET application.

Can ODP. Net Access database servers of oracle8, Oracle8i, and Oracle9i and access databases running on Linux or UNIX?
Yes. However, you must install the Oracle Release 2 client on Windows.

Can ODP. net use the original oracle8, Oracle8i, or oralce9i clients?
No. You must install the Oracle 9i Release 2 client.

Which Oracle products must be installed to use ODP. Net?
Installation required:
-Windows 98, Windows NT 4.0, Windows 2000, Windows XP Professional
-Oracle client (9.2.0.1.0)
-Microsoft. NET Framework
-Oracle Net Services
-To use the enterprise transaction management function, you must: Oracle services for Microsoft Transaction Server (9.2.0.1.0 or higher)

Can ODP. Net be used in Windows server2003,. NET Framework 1.1, and vs 2003?
Yes.

Can I distribute or sell ODP. Net with my applications. Is Oracle charged?
In most cases, there is no charge. Refer to the consent form you signed when purchasing or downloading Oracle products.

How can I solve the unable to load DLL (oraops. dll) error?
First, ensure that oraops. dll is in the bin directory where you install the Oracle directory, and then check whether the bin directory is added to the Windows PATH environment. Otherwise, you must reinstall ODP. net.

Is data provider for Oracle on ODP. NET and Microsoft DOTNET the same product?
No. ODP. NET is developed by Oracle and is more powerful and faster than Microsoft's data provider for Oracle.

If some of my previous applications require clients of earlier versions of Oracle, can I run ODP. NET and previous applications on the same machine.
Follow these steps:
Do not overwrite the previous files when installing the Oracle9i Release 2 client. Create a new directory for installation.
At this time, you will have two oraclehome directories, one for the previous Oracle client and the other for ODP. net. The oraclehome directory installed later will be used by all your applications.
Switch between different oraclehome instances and use oraclehome selector for selection.

How to use distributed transactions in ODP. Net?
You must install Oracle services for MTS.

What are the differences between ODP. NET and Microsoft. NET Framework data provider for Oracle, ole db. net, and ODBC. Net?
In terms of accessing the Oracle database, ODP. NET is more efficient than other database access solutions mentioned above.

Text complete