Benefits of OleDBPro

        OleDBPro can open any kind of a data source as long as the data source has either an OLEDB provider, or an ODBC driver, or ISAM driver (MS Jet Engine). It can open tabular data such as MS Excel sheets, tables in a relational database management system, and database meta data like keys, indexes, columns, and so on. It can also talk with tree-structured data like web and email folders and files. Armed with MS remote data service, your applications can easily talk with a remote server through internet connection. For the simplicity, OleDBPro can do whatever OLEDB can do. Additionally, OleDBPro provides some unique features at this writing time.

1. Complete Solution:
           No matter what data sources are, OleDBPro can universally talk with them as long as either OLEDB providers, or ODBC drivers, or  ISAM drivers are available, including relational DBMSs, non-relational DBMSs and OLAPs.
           No matter what a valid statement is, OleDBPro can ALWAYS handle it easily and friendly with less coding, including simple SQL statements, parameterized statements, stored procedures, multiple-rowsets statements, statement batches, MDX statements and XML query statements. No valid statement can not be coped with OleDBPro as long as an OLEDB provider is capable.
           No matter what a rowset is and no matter how many binary large objects (BLOBs) a rowset record has, OleDBPro can ALWAYS handle them easily and friendly with a little coding for both data writing and retrieving,
           OleDBPro virtually wraps all the OLEDB objects, all common and tough OLEDB interfaces and virtually all of them. To see what OLEDB interfaces are wrapped, click here.
           OleDBPro wraps all the database objects such as databases, tables, views, indexes, keys, bookmarks, and so on.
           OleDBPro makes the use of various MS data access services such as client cursor, data shaping, remote accessing and persistence easy. See the examples DataShape and FilterSort.
           OleDBPro makes the use of asynchronously processing various OLEDB objects and notifications easy.

2. Fast:
           OleDBPro module is carefully written by direct use of OLEDB interfaces and specifically designed and optimized for C++ development.
           By default, OleDBPro deals with all the statements using batch (group) model to reduce network traffic if possible. For examples, OleDBPro retrieves a batch (20) of records instead of one by one by default. By default, OleDBPro also sends multiple sets of parameters data into a data source instead of one set by one set with a single call too.
           For reduction of unwanted data movement over internet and increasing data accessing speed, OleDBPro provides functions to easily use OLEDB unique feature, column deferring. For details, see here.
           OleDBPro supports using bookmarks, indexes and keys to pinpoint records.
           OleDBPro has a unique feature, data bindings modification at run time, to increase data accessing speed.
           To see what ways can be used to improve data accessing by OleDBPro, click here.

3. Robust
           OleDBPro is extensively tested over a number of OLEDB providers such as MS ODBC, MS Jets (3.5, 4.0 and ISAM drivers), MS SQL Server, MS Internet Publishing, MS Client Cursor Engine, MS Data Shaping Services, MS Remote, MS Persistence, MS Index, MS Active Directory, MS Oracle, and ORACLE Oracle.

4. Simple to Learn and Use:
           You maybe never deals with memory allocations, any accessors or DBBINDING structures directly, which are most difficult to handle in OLEDB programming,  if using OleDBPro module.
           OleDBPro dramatically simplifies data type conversions, BLOBs managements and error message managements.
           There is no magic MACRO.
           OleDBPro functions don't have many complex arguments.
           OleDBPro has internal functions to check and notify programming errors with debug version of OleDBPro library.

5. Extensibility and Flexibility:
           OLEDB is extremely extensible and flexible. OleDBPro module still keeps this OLEDB advantage by heavy use of templates.
           You can easily extend any one of classes or overwrite a function inside OleDBPro module.

6. Source Codes:
           All of source codes can be available after purchasing this module. Source codes will help you deeply understand OLEDB programming, and avoid lots of OLEDB tricks behind.

7. Enough Examples:
           Thirty real examples with full source codes, which are divided into three levels - beginning, middle and advanced, are included with the OleDBPro module. In addition to common data accessing tasks, they demonstrate how to deal with batch statement, parameterized statements, stored procedures, data base meta data, OLAP and various services available like client cursor engine, data shaping, and so on. More extra examples are also provided.

8. Clean and Uniform Codes:
           The OleDBPro module are purely dynamic and generic.
           You will never have to define a user accessor.
           Light component in size (128K) and Low memory foot. 

9. Exchangeable with ATL consumer templates and ADOs:
            CODataSource and COSession/COSessionEx of this OleDBPro module correspond to CDataSource and CSession in ATL consumer templates. You can use CDataSource and CSession objects to open a data source and a session, and use them to open a CRBase and its derived classes object easily. You can even use an opened CCommand<T> object to open a CRBase-related object using function CRBase::OpenRBase.
           You can also let OleDBPro talk with ADOs.
           If you already use ADO or ATL consumer templates but need particular functions available only from OleDBPro, you can easily attach an interface to an OLEDB object with an OleDBPro object.