Description
Oracle Data Access Components library provides high performance direct access to Oracle database server. ODAC is a set of VCL native components for Kylix, Delphi and C++ Builder. It supports many Oracle specific features and simplifies developing of client/server applications. With Net option ODAC works directly through TCP/IP and doesn't require Oracle's software on client side. Using ODAC gives you the following advantages: Doesn't require Oracle's software on client side with Net option; Supports Oracle 8 features: BLOB, CLOB and BFile data types, objects, arrays, references, nested tables; Oracle 9 scrollable cursors, timestamp and interval datatypes support;Simplifies data updating; Offers two ways of updating data: more flexible with TOraQuery and easier with TSmartQuery;Speeds up fetch record from database;Provides automatic locking and refreshing records;Allows to execute longtime stored procedure separated thread;Advanced design-time editors;Interface (methods, properties) of ODAC components is similar to standard data access components (TDatabase, TQuery, ..);Supports all data-aware components;Uses OraTools Add-in to build and check queries with OraDesigner, design and debug PL/SQL blocks with OraDebugger and explore database schemas with OraExplorer;DB Monitor support.Advantages of Net option: ODAC Standard as the most of applications which work with Oracleuses Oracle Call Interface to connect to Oracle database server. This is usual way to develop Oracle application with a third-generation language. As all OCI routines are in external libraries compiled application has small size. But it requires Oracle client software installed on workstation that is the cause of additional expenses for its installation and administration. Sometimes installation of Oracle client can be not advisable or even impossible. For example, if you need to set your application on remote machine where you don't have respective specialist.ODAC Net allows your application to work with Oracle directly through TCP/IP protocol anddoesn't require Oracle client software. To run your application built with ODAC Net it is only needed to have operation system and TCP/IP protocol support.To connect to Oracle server with ODAC Net you need know the address of computer whereOracle server is, listening port number and database instance name.
Related:
Bde - Borland - Borland Delphi - C++ - C++ Builder - Core Lab - Data Access - Dataset - Db Express - Dbexpress - Delphi - Kylix - Linux - Oci - Odac - Oracle - Oracle And Delphi - Oracle Call Interface - Oracle Data Access - Oracle Data Access Components - Sql - Sql Server - Sql*Net - Tdataset
User Reviews:
Related:
SQLDAC - universal access to SQL databases 1.0SQLDAC - is a database-independent layer that defines a common interface for access to SQL database servers. Interaction with a database is carried...By: Dmitry Konnov |
Freeware |
AnyDAC for Delphi 4.0.7Universal high-speed Delphi Data Access Components for Firebird, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere and more. |
Shareware |
SQL Server Data Access Components 4.80SDAC is a VCL/VCL.NET/CLX component library for fast direct access to SQL Server from Delphi and C++Builder. Supports all SQL Server data types and...By: Devart |
Shareware |
Object DBF Library 3.2The whole power of Delphi's native tools for databases manipulation is not required in small single-user applications. There are many cases when...By: Leonid Schavelev |
Shareware |
Luxena Informix Data Access Components 2.6.3IDAC allows you create Informix access applications in common BDE fashion without known BDE constraints. IDAC ensures reliability as well as... |
Shareware |
Oracle Data Access Components for Delphi 4 2.50Oracle Data Access Components (ODAC) library offers some nonvisual components for Borland C++ Builder and Delphi. They serve for accessto Oracle...By: Core Lab |
Shareware |
Oracle Data Access Components for Delphi5 2.50Oracle Data Access Components (ODAC) library offers some nonvisual components for Borland C++ Builder and Delphi. They serve for accessto Oracle...By: Core Lab |
Shareware |
Oracle driver for dbExpress 1.10Oracle driver for dbExpress is lightweight database driver which provides fast and high performance access to Oracle database server. Using...By: crlab.com |
Shareware |
NCOCI8 V 1.0.3This is a very powerfull component library for direct access to Oracle8i server. NCOCI8 support a lot of Oracle features, that are not accessable...By: Dmitry Arefiev |
Freeware |
Atom components 1This software was created for fast access to Oracle database without using Borland Database Engine, SQL-links, and ODBC drivers. Main...By: geocities.com |
Shareware |
- Data Access: Implement a Data Access Layer for Your App with ADO.NET
This article outlines five ideas to consider when building a data access layer with Visual Studio .NET and the .NET... - AnyDAC (Any Data Access Components)
A multi-DBMS data access framework with multi-layered, plugable architecture for Borland Delphi. [Freeware] - Softvector Data Access Components
ODBC Data Access Components (DAC) and DbExpress Driver for SAP DB. By Softvector Company. [Commercial] - Pooling in the Microsoft Data Access Components
Discusses the benefits, features, and behavior of pooling within the context of the MDAC architecture, including... - ADO.NET: Building a Custom Data Provider for Use with the .NET Data Access Framework
An article by Bob Beauchemin that explains how to write your own data provider using .NET's data access interfaces and... - .NET Data Access Architecture Guide
The information in this article covers the data access objects including the DataSet and DataAdapter classes in ADO.NET.... - Designing Data Tier Components and Passing Data Through Tiers
Learn how to best expose your data to Microsoft .NET applications and how to implement an effective strategy for passing... - Direct Oracle Access
Allround Automations has a set of Delphi components that access Oracle direct. - Deploying .NET Software Components
An introduction to .NET Software Components Deployment. By Jean-Claude Batista. - Oracle-developer.net
Articles and utilities for Oracle developers by Adrian Billington
