ODAC provides access to Oracle from Borland Delphi and C++ Builder skiping BDE.
Oracle Data Access Components provides high performance direct accessto Oracle database server. ODAC is set of VCL native components for Kylix,Delphi and C++ Builder. It supports many Oracle specific featuresand simplifies developing of client/server applications. With Net optionODAC works directly through TCP/IP and doesn't require Oracle's softwareon client side.
Using ODAC gives you the following advantages: - Doesn't require Oracle's software on client side with Net option; - Supports Oracle 8 feathers: BLOB, CLOB and BFile data types, objects, arrays, references, nested tables; - Simplifies data updating; - Offers two way of updating data: more flexible with TOraQuery and more easy 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.
Advantages of Net option:
ODAC Standard as the most of applications which work with Oracle usesOracle Call Interface to connect to Oracle database server. This is usualway to develop Oracle application with a third-generation language. As allOCI routines are in external libraries compiled application has small size.But it requires Oracle client software installed on workstation that isthe cause of additional expenses for its installation and administration.Sometimes installation of Oracle client can be not advisable or evenimpossible. For example, if you need to set your application on remotemachine where you don't have respective specialist. ODAC Net allows your application to work with Oracle directly through TCP/IP protocol and doesn't require Oracle client software. To run yourapplication built with ODAC Net it is only needed to have operationsystem and TCP/IP protocol support. To connect to Oracle server with ODAC Net you need know the addressof computer where Oracle server is, listening port number and database instance name.
Oracle Data Access Components Standard for Windows Related Software: