InterBase OLE DB Provider (FreeIBProvider) (ID #19013)

Lipetsk Center of Legal Informatization

The Brief Review of Opportunities of IBProvider

- Work with IB4.x, IB5.x, IB6.x and IB7.x.
- Controlled isolation of client from IB6 features.
- Wide range of the data OLE DB types and support of all data InterBase types. Converting of the data types. The mechanism of reading/writing of BLOB fields through streams (storage-objects).
- Support of array data type
- UNICODE mode ensures the special support of codings OF UNICODE_FSS, WINXXX, DOSXXX. Text recoding is supported for the usual columns, the arrays, the BLOB-fields and the storage-objects.
- IN-OUT parameters
- Three levels of transaction isolation: Read Commited, Snapshot, Snapshot Table Stability.
- Support of work in AutoCommit mode with various level of isolation.
- Realization of all logical information and physical information schema rowsets.
- Full support IB SQL. Includung management of the transaction trought SQL.
- Two-phase confirmation of a transaction.
- Support of Microsoft Transaction Server.
- Client Cursor Engine support.
- Provider gives a possibility to attach InterBase to MSSQL server for executing of heterogeneous queries to the different databases.
- Multithreaded access through one connection. Besides, components themselves are realized for multithreaded access.
- Support of named and non-named parameters in request text.
- Support of execute stored procedure.
- Determination of request parameter types.
- Creation of resulting sets with sequential and random access.
- Åffective memory management of cache file and 64bit access to the temporary files.
- Control of internal mistakes and server mistakes.

The library of class, which uses completely opportunities of the provider (with it remaining within the framework of OLE DB specification) and reduces up to a minimum the expenses on its use, is created for the programs written on Builder C++ v3. The basis of the provider is the C++ library of access to IB, checked and used up in several large projects.

Applications Sector

OLE DB is a modern Microsoft standard for access to the data. As against ODBC - the previous technology, OLE DB gives new, the object-oriented interface of work with information. Created on the basis of this technology IBProvider provides an effective work with InterBase databases from the programs created on Visual Basic, Delphi, C++Builder, Visual C++, MS Office. Among advantages of the programs constructed on the basis of the IBProvider are following:

- Effective utilization of COM-technology for internal organization.
- Scaling and flexibility.
- Parallel use of different tools of development in one project.
- Reduction of expenses on modernization and support.
- Use of Active Data Object (ADO), components ScriptControl, VBScript or JScript for data processing in the programs written on C++ and Delphi.

Considering, that:

- OLE DB is a key Microsoft technology and it advances actively it;
- InterBase SQL Server has all necessary opportunities for construction of complex information storehouses and its last version is a free distributed product;

It is meaningful to use IBProvider for construction of new adequate to the modern requirements system for managing the information stored on InterBase server. Systems, which will work tomorrow.

InterBase OLE DB Provider (FreeIBProvider) home page