Scripts Index
Related Topics
Popular Trends
Trending Topics
ASP.NET Development Tools  

Oracle Data Access Components

download download home home   report broken
important script information
company name:
devart.com
license: Free
minimum requirements: ASP.NET
functional limitations:
Oracle Data Access Components description


Oracle Data Access Components (ODAC) is a library of components that provides native connectivity to Oracle from Delphi, Delphi for .NET, C Builder and Kylix. The ODAC library is designed to help programmers develop faster and cleaner Oracle database applications.

ODAC is a complete replacement for standard Oracle connectivity solutions and presents an efficient native alternative to the Borland Database Engine and dbExpress for access to Oracle.

Advantages:

ODAC is a direct connectivity database wrapper built specifically for the Oracle server. ODAC offers wide coverage of the Oracle feature set, supports both Client and Direct connection modes, and emphasizes optimized data access strategies.

Wide Coverage of Oracle Features
By providing access to the most advanced database functionality, ODAC allows developers to harness the full capabilities of the Oracle server and optimize their database applications. ODAC stands out as the set of components with the widest support of Oracle functionality. It is the only component library to support Oracle distributed transactions and implements support for controlling statement caching, OCI pooling, and Oracle Advanced Queuing.

Native Connection Options
ODAC offers two connection modes to the Oracle server: connection through the Oracle Call Interface in Client mode and direct connection over TCP/IP in Direct mode. ODAC-based database applications are easy to deploy, do not require installation of other data provider layers (such as BDE), and tend to be faster than those that use standard data connectivity solutions.

Optimized Code
The goal of ODAC is to enable developers to write efficient and flexible database applications. The ODAC library is implemented using advanced data access algorithms and optimization techniques. Classes and components undergo comprehensive performance tests and are designed to help you write high-performance, lightweight data access layers. To see results of ODAC performance tests, visit the ODAC performance page.

Compatibility with Standard Data Access Components
The ODAC interface retains compatibility with standard VCL data access components like BDE. Existing BDE-based applications can be easily migrated to ODAC and enhanced to take advantage of Oracle-specific features like alerts, pipes, and the direct-path interface. Project migration can be automated with the BDE Migration Wizard.

How Does ODAC Work?

ODAC allows you to connect to Oracle in two ways: in Client mode, using Oracle client software, or in Direct mode, over TCP/IP.

In Client mode, ODAC connects to Oracle through the Oracle Call Interface (OCI). OCI is an application programming interface that allows an application developer to use a third-generation language's native procedure or function calls to access the Oracle database server and control all phases of SQL statement execution. OCI is a library of standard database access and retrieval functions in the form of a dynamic-link library.

In Direct mode, ODAC connects to Oracle directly without using Oracle client software. In this mode, ODAC requires only TCP/IP support, and lets you build really thin database applications.

In comparison, the Borland Database Engine (BDE) uses several layers to access Oracle, and requires additional data access software to be installed on client machines. Key Features:- Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC) - In Direct mode does not require Oracle client software and works directly through TCP/IP - VCL, VCL.NET, and CLX versions of library available - Full support of the latest versions of Oracle - Support for all Oracle data types - Disconnected Model with automatic connection control for working with data offline - Local Failover for detecting connection loss and implicitly re-executing certain operations - Oracle Transparent Application Failover support - All types of local sorting and filtering, including by calculated and lookup fields - Automatic data updating with TOraQuery, TSmartQuery, and TOraTable components - Unicode and national charsets support - Distributed transaction support - Oracle Advanced Queuing support - Support for many Oracle-specific features, such as alerts, pipes and direct path interface - Advanced script execution functionality with TOraScript component - Support for using Macros in SQL - Integration with OraDeveloper Tools for performing advanced database development and administration tasks - Easy migration from BDE with Migration Wizard - Lets you use Professional Edition of Delphi, C Builder, and Kylix to develop client/server applications



Relates:
Tool - Developer - Asp Net - Database Tool - Data Access - Oracle Data
Similar scripts
PDF Metamorphosis .Net (Popularity: ) : Managed .Net component to convert RTF to PDF, TXT to PDF, HTML to PDF string and files.
Converting directions (absolutely independent converting):
- RTF to PDF
- TXT to PDF
- HTML to PDF

Developers can use our server-component in ASP.Net.
Starting from version 2.0.0 ...

UseOffice .Net (Popularity: ) : UseOffice .Net is a component for developers for converting between RTF, DOC, XLS, PPT, Text and HTML documents.

The UseOffice .Net requires MS Office® installed on your machine. It works with these Office versions: 2000, XP, 2003 and 2007.
Using the UseOffice ...

WebGrid.NET Enterprise (Popularity: ) : Voted as ‘Best Grid Component’ in Peoples Choice 2005 Award, WebGrid.NET Enterprise 4.0 has set grid functions to the next level. Taking advantage from our proprietary FlyPostBack™ technology, which is now popular as AJAX, WebGrid provides a new and faster ...
VBConversions VB.Net to C# Converter (Popularity: ) : VBConversions VB.Net to C# Converter allows you to convert over 99% of your VB code to C# automatically. Features: Unsurpassed Accuracy - Microsoft 101 Sample VB.Net programs convert at 100% accuracy. - Each release is stress tested on hundreds of thousands ...
PPT-to-Flash Converter (Popularity: ) : Faultless quality of converted PowerPoint-to-Flash presentations?PowerPoint-to-Flash Converting for low pricing? Then you really should decide on conaito PPT-to-Flash Converter!With a high performance presentation you are well on the way to make a success of your product. Microsoft PowerPoint® is a ...
WebUI Studio.NET (Popularity: ) : WebUI Studio.NET® is the most comprehensive AJAX suite of indispensable components for building professional ASP.NET® web applications. WebUI Studio.NET® includes 17 highly advanced user interface components for developing Rich Internet Application by using Unified Component System methodology. This results in ...
ZIPCodeWorld Store Locator .NET Component (Popularity: ) : ZIPCodeWorld Store Locator .NET is a store locator control for all .NET developers. Your own United States or Canada store locator service can be up and running within minutes with just a few simple installation steps.
Aspose.PowerPoint for Java (Popularity: ) : Aspose.PowerPoint is a java PowerPoint presentation reporting component. With it, you can:Read, change and save existing Microsoft PowerPoint presentations which support text placeholders, text frames and backgrounds without utilizing Microsoft PowerPoint,- Read and change PowerPoint presentations via API,-Preview slides and ...
Aspose.PDF.Kit for Java (Popularity: ) : Aspose.PDF.Kit for Java is a Java Pdf document manipulating component which allows developers to Edit the existing pdf documents, such as appending and inserting pages, concatenating two pdf documents, splitting one file into two sub-files,- Show and change the meta ...
WebDesktop.NET (Popularity: ) : WebDesktop.NET is the next generation of AJAX-enabled Web presentation components designed to help you professionally build sophisticated “desktop-style” web user interfaces. Developers are enabled to develop enterprise-grade Web applications with the richness of desktop application in behaviors and styles through ...
User reviews

Write a review:
1 2 3 4 5 6 7 8 9 10
1=poor 10=excellent
Write review*
Your name*
Email*
  (Comments are moderated, and will not appear on this site until the editor has approved them)
 
Similar Software
Oracle Data Access Components for Delphi 7 (Popularity: ) : Oracle Data Access Components (ODAC) is a library of components that provides native connectivity to Oracle from the following IDEs: Embarcadero RAD Studio XE2 and XE, Embarcadero RAD Studio 2010, CodeGear Delphi 2009, C++Builder 2009, CodeGear RAD Studio 2007, Delphi ...
Oracle Data Access Components (Popularity: ) : Oracle Data Access Components (ODAC) is a library of components that provides direct access to Oracle database servers from Embarcadero RAD Studio 10 Seattle Embarcadero RAD Studio XE-XE8, CodeGear RAD Studio 2009/2007, Borland Developer Studio 2006, Turbo Delphi Professional, Turbo ...
Universal Data Access Components for Delphi 7 (Popularity: ) : Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database native VCL/FMX/LCL data access components for Embarcadero RAD Studio XE2 and XE, Embarcadero RAD Studio 2010, CodeGear Delphi 2009, C++Builder 2009, CodeGear RAD Studio 2007, Delphi 2007 for ...
Universal Data Access Components (Popularity: ) : Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database native VCL/FMX/LCL data access components for Embarcadero RAD Studio XE-XE8, Embarcadero RAD Studio 2010, CodeGear Delphi 2009, C++Builder 2009, CodeGear RAD Studio 2007, Delphi 2007 for Win32/Win64, C++Builder ...
SQL Server Data Access Components for Rad Studio XE2 (Popularity: ) : SQL Server Data Access Components (SDAC) is a library of components that provides access to Microsoft SQL Server databases from Embarcadero RAD Studio XE3/XE2/XE, Embarcadero RAD Studio 2010 ,CodeGear RAD Studio 2009/2007, Borland Developer Studio 2006, Turbo Delphi Professional, Turbo ...
InterBase Data Access Components for Delphi 7 (Popularity: ) : InterBase Data Access Components (IBDAC) is a library of components that provides access to InterBase, Firebird, and Yaffil database servers from Embarcadero RAD Studio XE2 and XE, Embarcadero RAD Studio 2010, CodeGear Delphi 2009, C++Builder 2009, CodeGear RAD Studio 2007, ...
PostgreSQL Data Access Components for Delphi 7 (Popularity: ) : PostgreSQL Data Access Components (PgDAC) is a library of components that provides direct access to PostgreSQL database servers from the following IDEs: Embarcadero RAD Studio XE2 and XE, Embarcadero RAD Studio 2010, CodeGear Delphi 2009, C++Builder 2009, CodeGear RAD Studio ...
SQL Server Data Access Components for Delphi 7 (Popularity: ) : SQL Server Data Access Components (SDAC) is a library of components that provides access to Microsoft SQL Server databases from Embarcadero RAD Studio XE2 and XE, Embarcadero RAD Studio 2010, CodeGear Delphi 2009, C++Builder 2009, CodeGear RAD Studio 2007, Delphi ...
PostgreSQL Data Access Components (Popularity: ) : PostgreSQL Data Access Components (PgDAC) is a library of components that provides direct access to PostgreSQL database servers from Embarcadero RAD Studio 10 Seattle, Embarcadero RAD Studio XE-XE8, CodeGear RAD Studio 2009/2007, Borland Developer Studio 2006, Turbo Delphi Professional, Turbo ...
SQL Server Data Access Components (Popularity: ) : SQL Server Data Access Components (SDAC) is a library of components that provides access to Microsoft SQL Server databases from Embarcadero RAD Studio 10 Seattle, Embarcadero RAD Studio XE-XE8, CodeGear RAD Studio 2009/2007, Borland Developer Studio 2006, Turbo Delphi Professional, ...
ad


Rate me
supported os
All
stats
downloads 13
version 6.5
size in Kb
popularity   
1839/368880
user rating 5/10
New Scripts
Popular Scripts
Latest Reviews