ODAC allows Borland Delphi and C++ Builder users to directly access Oracle without the need for BDE.
One of the key benefits of ODAC is its Net option, which allows for direct communication with Oracle through TCP/IP, eliminating the need for Oracle software on the client side. By using ODAC, users gain a range of advantages, including support for Oracle 8 feathers like BLOB, CLOB, and BFile data types, objects, arrays, references, and nested tables. ODAC also simplifies data updating and provides two ways of updating data; the more flexible TOraQuery and the more straightforward TSmartQuery. Additionally, ODAC speeds up record fetching, provides automatic locking and refreshing of records, and enables the execution of long-term stored procedures separated threads.
ODAC's advanced design-time editors and component interface (methods, properties) make it a familiar and easy-to-use tool for developers of all levels of experience. ODAC supports all data-aware components, making it a reliable and versatile choice for anyone looking to improve their client/server applications.
One of the most significant advantages of ODAC's Net option is that it eliminates the need for Oracle Call Interface, which is usually required to connect applications to the Oracle database server. This connection protocol is a typical way to develop Oracle applications with a third-generation language, but it requires installation of the Oracle client software on the workstation, which can be costly and time-consuming. With ODAC Net, applications can communicate with Oracle directly through TCP/IP, eliminating the need for any Oracle client software. Running an application built with ODAC Net only requires an operating system and TCP/IP protocol support.
To connect to an Oracle server using ODAC Net, users only need to know the address of the computer where the Oracle server is located, the listening port number, and the database instance name. In summary, ODAC is a powerful tool that can streamline the development of client/server applications, while its Net option can significantly reduce the costs and complexities associated with installing and administering Oracle client software.
Version 3: N/A