文件列表:

odac570src_0.28\Contacts.html (1073, 2005-08-01)
odac570src_0.28\CRGrid\Help\CRControls.cnt (2037, 2004-08-10)
odac570src_0.28\CRGrid\Help\CRControls.hlp (66839, 2004-08-10)
odac570src_0.28\CRGrid\Help (0, 2006-03-21)
odac570src_0.28\CRGrid\Images\CoreLab.Vcl.CRGrid.TCRDBGrid.bmp (822, 2004-02-10)
odac570src_0.28\CRGrid\Images (0, 2006-01-26)
odac570src_0.28\CRGrid\Source\CBuilder5\crcontrols50.bpk (4021, 2006-01-12)
odac570src_0.28\CRGrid\Source\CBuilder5\crcontrols50.cpp (745, 2001-11-21)
odac570src_0.28\CRGrid\Source\CBuilder5\crcontrols50.res (1356, 2006-01-12)
odac570src_0.28\CRGrid\Source\CBuilder5 (0, 2006-03-21)
odac570src_0.28\CRGrid\Source\CBuilder6\crcontrols60.bpk (4040, 2006-01-12)
odac570src_0.28\CRGrid\Source\CBuilder6\crcontrols60.cpp (745, 2002-02-19)
odac570src_0.28\CRGrid\Source\CBuilder6\crcontrols60.res (1356, 2006-01-12)
odac570src_0.28\CRGrid\Source\CBuilder6 (0, 2006-03-21)
odac570src_0.28\CRGrid\Source\CRControls.res (600, 2001-08-06)
odac570src_0.28\CRGrid\Source\CRControlsReg.pas (547, 2006-01-12)
odac570src_0.28\CRGrid\Source\CRGrid.inc (2515, 2005-09-06)
odac570src_0.28\CRGrid\Source\CRGrid.pas (124544, 2006-01-12)
odac570src_0.28\CRGrid\Source\CRGrid.res (1668, 2001-04-03)
odac570src_0.28\CRGrid\Source\Delphi10\CoreLab.snk (596, 2004-06-29)
odac570src_0.28\CRGrid\Source\Delphi10\CoreLab.Vcl.bdsproj (12190, 2006-01-12)
odac570src_0.28\CRGrid\Source\Delphi10\CoreLab.Vcl.cfg (1138, 2005-09-06)
odac570src_0.28\CRGrid\Source\Delphi10\CoreLab.Vcl.dpk (3248, 2006-01-12)
odac570src_0.28\CRGrid\Source\Delphi10\CoreLab.Vcl.reg (220, 2005-09-19)
odac570src_0.28\CRGrid\Source\Delphi10\CRControls.reg (129, 2005-09-16)
odac570src_0.28\CRGrid\Source\Delphi10\CRControls100.bdsproj (10780, 2006-01-12)
odac570src_0.28\CRGrid\Source\Delphi10\CRControls100.cfg (1070, 2005-12-21)
odac570src_0.28\CRGrid\Source\Delphi10\CRControls100.dpk (644, 2006-01-11)
odac570src_0.28\CRGrid\Source\Delphi10\CRControls100.res (1356, 2006-01-12)
odac570src_0.28\CRGrid\Source\Delphi10 (0, 2006-03-21)
odac570src_0.28\CRGrid\Source\Delphi5\crcontrols50.cfg (813, 2004-03-25)
odac570src_0.28\CRGrid\Source\Delphi5\crcontrols50.dof (2688, 2006-01-12)
odac570src_0.28\CRGrid\Source\Delphi5\crcontrols50.dpk (616, 2001-11-21)
odac570src_0.28\CRGrid\Source\Delphi5\crcontrols50.res (1356, 2006-01-12)
odac570src_0.28\CRGrid\Source\Delphi5 (0, 2006-03-21)
odac570src_0.28\CRGrid\Source\Delphi6\crcontrols60.cfg (813, 2004-04-06)
odac570src_0.28\CRGrid\Source\Delphi6\crcontrols60.dof (2609, 2006-01-12)
odac570src_0.28\CRGrid\Source\Delphi6\crcontrols60.dpk (628, 2006-01-11)
odac570src_0.28\CRGrid\Source\Delphi6\crcontrols60.res (1356, 2006-01-12)
odac570src_0.28\CRGrid\Source\Delphi6 (0, 2006-03-21)
... ...

Core Lab Oracle Data Access Components 5.70 Copyright 1997-2006, Core Lab. All Rights Reserved -------------------------------------------------- Oracle Data Access Components (ODAC) library offers some nonvisual components for Borland Delphi for Win32, Borland Delphi for .NET, C++ Builder, Kylix. They serve for access to Oracle RDBMS. ODAC is an alternative to standard way processing data by Borland Database Engine (BDE). ODAC uses Oracle Call Interface (OCI) directly. The Oracle Call Interface is an application programming interface (API) 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. The OCI provides a library of standard database access and retrieval functions in the form of a dynamic runtime library, ORA*.DLL, that can be linked in by the application. Also with Net option ODAC allows to connect without Oracle client software installed on workstation. In such case ODAC requires only TCP/IP protocol and allows to build really thin database application. Using BDE in Oracle oriented client/server applications has some deficiencies. So in consequence of BDE community get unable server specific features, use more resources, reduce speed of processing data, cumbrous distribution of an application and its administration. In case of using BDE transfer way of data is: [Oracle RDBMS] <> [SQL*Net] <> [OCI] <> [SQL Links] <> [BDE] <> [Application] ODAC works directly through Oracle Call Interface. It allows to avoid using BDE and SQL Links: [Oracle RDBMS] <> [SQL*Net] <> [OCI] <> [Application] ODAC Net provides optimal transfer way: [Oracle RDBMS] <> [TCP/IP] <> [Application] ODAC includes following components: TOraSession - controls server connection; TOraQuery - queries execution, operates record set, flexible way updating database tables; TSmartQuery - easy in using and an alternative to TOraQuery, automatically builds INSERT, DELETE, UPDATE queries, automatic locking and refreshing records; TOraSQL - executes SQL statements, PL/SQL blocks, stored procedure; TOraPackage - allows to execute package procedures and functions and provides access to package variables; TOraTable - allows to retrieve and update data single table without writing SQL statement; TOraStoredProc - executes stored procedures and functions, allows to edit cursor data returned as parameter; TOraNestedTable - controls nested table's data; TOraProvider - provides data to and applies updates from a client dataset; TOraScript - executes sequence of SQL and PL/SQL statements; TOraAlerter - allows to transfer messages between sessions; TOraLoader - provides quick loading data to Oracle database; TOraSQLMonitor - allows to monitor dynamic SQL executing in ODAC based applications; TOraErrorHandler - translates error messages; TBDESession - allows to integrate ODAC components into BDE based application; TConnectDialog - serves for enter username, password and server name; TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search; TVirtualTable - dataset stores data in memory. OraDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet Features -------- Following list describes the main features of Oracle Data Access Components: - Direct access to Oracle data. No distributing, installing and configuring the BDE and ODBC; - Doesn't require Oracle's software on client side with Net option and works directly through TCP/IP; - Extended Oracle data types support including XML types, LOB's, objects, nested tables, references, timestamps and intervals; - High performance controlled fetch of large data blocks; - Optimized string and raw data storing; - Easy work with Unicode data; - Automatic data updating with TSmartQuery and TOraTable components; - Automatic record locking and refreshing; - NonBlocking mode allows to run long lasting background queries in separate threads; - Oracle 9i scrollable cursors support; - Transparent Application Failover support; - Supports many Oracle specific features such as alerts, pipes and Direct Path interface; - Separated run-time and GUI specific parts allow to create pure console applications such as CGI; - SmartRefresh option allows two or more datasets to be synchronized automatically; - Advanced design-time editors; - OraTools Add-in extending design-time capabilities by set of tools to build and check queries, design and debug PL/SQL blocks and explore database schemas; - Extended SQL tracing capabilities provided by TOraSQLMonitor component and DBMonitor application; - Wide data-aware and reporting components support; - Easy migration from BDE; - Allows to use Professional Edition of Delphi, C++ Builder or Kylix to develop client/server applications. Compatibility ------------- ODAC supports Oracle 10g including Express Edition, 9i, 8i, 8.0 and 7.3 including Personal and Lite. Following IDE are supported by ODAC: Borland Delphi 2006, 2005, 8, 7, 6 and 5, C++ Builder 6 and 5, Kylix 3 and 2. Architect, Professional and Enterprise editions are supported. ODAC does not support Kylix Open Edition. Note: Update Pack 3 is required for Delphi 8 Update Pack 2 is required for Delphi 6 (Build 6.240) Installation ------------ ODAC installer copies these files to folders where they should be resided. The following packages are used with Delphi 5, Delphi 6, Delphi 7, Delphi 2005, Delphi 2006, C++ Builder 5, C++ Builder 6 projects: dacXX.bpl - DAC run-time package (located in Windows\System folder) dcldacXX.bpl - DAC design-time package (located in Delphi\Bin folder) dacvclXX.bpl - DAC VCL support package (located in Delphi\Bin folder) odacXX.bpl - ODAC run-time package (located in Windows\System folder) dclodacXX.bpl - ODAC design-time package (located in Delphi\Bin folder) odacvclXX.bpl - VCL support package (located in Delphi\Bin folder) oraprovXX.bpl - TOraProvider component (located in Delphi\Bin folder) crcontrolsXX.bpl - TCRDBGrid component (located in Delphi\Bin folder) The following packages are used with Delphi 2006, Delphi 2005, Delphi 8 projects: CoreLab.Dac.dll - DAC run-time package (located in Global Assembly Cache) CoreLab.Dac.Design.dll - DAC design-time package CoreLab.Odac.dll - ODAC Delphi 8 run-time package (located in Global Assembly Cache) CoreLab.Odac.Design.dll - ODAC design-time package CoreLab.Vcl.dll - TCRDBGrid component CoreLab.Odac.AdoNet.dll - OraDataAdapter component Delphi ====== To compile ODAC based application add $(DELPHI)\ODAC\Lib to Project Options|Search path. Delphi for .Net =============== To register OraDataAdapter component in Delphi 2006, Delphi 2005, Delphi 8 Tool Palette follow these steps: - Open Delphi and go to "Tool Palette" window; - Add "ODAC" category using popup menu; - Select "Installed .NET Components..." from popup menu; - Go to "Installed .NET Components" tab within opened dialog; - Check OraDataAdapter component; - Press OK button. To compile ODAC based application add CoreLab.Dac and CoreLab.Odac to Namespace prefixes. C++ Builder =========== To compile ODAC based application add $(BCB)\ODAC\Lib to Project Options|Library path and $(BCB)\ODAC\Include to Project Options|Include path. Kylix ===== At first it is required to get ODAC packages reachable for Kylix IDE. To do it you should add directory where ODAC packages are installed to LD_LIBRARY_PATH using following command LD_LIBRARY_PATH=$LD_LIBRARY_PATH: Another way is to copy all ODAC packages (*.so) to any reachable directory, for example kylix/bin. Now you can install ODAC in Kylix IDE. Please select Component/Install Packages from Kylix menu. Press Add button and select bpldclodacX.so.X.XX package. On pressing OK button components are available in Oracle Access group. Also you should add odac/lib directory to Search Path of your project. TOraProvider component ====================== If you use Delphi or C++ Builder Enterprise edition you can install TOraProvider component separately. To do it compile and install oraprovXX.bpk package. OraTools add-in =============== Since ODAC 3.50 oratoolsXX.bpl design-time package doesn't exist. OraTools now is provided as a separate add-in. It is installed once and can be used by Delphi and C++ Builder. Kylix is not supported by now. Writing GUI applications with ODAC ---------------------------------- Since version 3.80 ODAC GUI part is standalone. This means that to make available GUI elements such as sql cursors, connect form, connect dialog etc. you should explicitly include OdacVcl (OdacClx under Linux) unit to your application. This feature is needed for writing console applications especially under Linux. Delphi and C++ Builder ====================== By default ODAC does not require Forms, Controls and another GUI related units. Only TConnectDialog and TOraErrorHandler components require Forms unit according to their needs. Kylix ===== By default ODAC does not require QT library. Only TConnectDialog, TOraErrorHandler and TOraAlerter components include QT-dependant code. In addition, SmartRefresh feature is disabled under Kylix. But having professional version this feature can be enabled if to define SMART_REFRESH macro for Linux in Odac.inc file. By default SMART_REFRESH macro is defined for Windows only. But be aware that SmartRefresh function requires QT. Trial version restrictions -------------------------- Note following restrictions when using ODAC trial version: - you can use ODAC during 60 days starting from the moment of installation. - ODAC Trial version needs additional "bpl" files to be present on the user PC. If you build your project without run-time packages you nead: dacXX.bpl odacXX.bpl Using several products in one IDE --------------------------------- ODAC, SDAC and MyDAC components use common base packages listed below. dacXX.bpl dacvclXX.bpl dcldacXX.bpl Note that product compatibility is provided for current build only. In the other words, if you upgrade one of the installed products it may conflict with older builds of other ones. In order to continue using products simultaneously you should upgrade all of them at the same time. -------------------- Web: http://www.crlab.com/odac eMail: odac@crlab.com Forum: http://www.crlab.com/forums

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：