Publish date: 2006-09-27
Updated: 2023-08-30
Differences between IBProvider versions
| Capabilities | IBProvider Professional Edition | |||||
|---|---|---|---|---|---|---|
| Summary | IBProvider v5 Lite (for dbGo) | IBProvider v5 | ||||
| Global | ||||||
| Connection to Firebird without fbclient.dll | yes | yes | yes | |||
| Support of Firebird from 0.9.4 up to 4.0 version | yes | yes | yes | |||
| Support of InterBase from 4.0 up to 2020 | yes | yes | yes | |||
| Support of Yaffil | yes | yes | yes | |||
| Support of the 64 bit architecture | yes | yes | yes | |||
| Allows selecting client library (gds32.dll or fbclient.dll). See the dbclient_library initialization property | yes | yes | yes | |||
| Support information properties which contain client library info. IB Client, IB Client Version, IB Client Name | yes | yes | yes | |||
| No restrictions on data size. Using the own hard disk cache with 64 bit access. | yes | yes | yes | |||
| Support of server and client cursors | yes | yes | yes | |||
| Bookmark size (in bytes) | 4/8 | 4 | 8 | |||
| Distributed transactions and DTC | yes | yes | yes | |||
| Transaction savepoints | yes | yes | yes | |||
| Nested transactions | yes | yes | yes | |||
| Subscribtion on transaction commit/rollback events | yes | yes | yes | |||
| Support of information properties and algorithms implemented in Firebird 2 (for example, you can get database creation date) | yes | yes | yes | |||
| Updatable rowsets | yes | no | yes | |||
| Connection pooling | yes | yes | yes | |||
| Query pooling | yes | yes | yes | |||
| Character sets processor | yes | yes | yes | |||
| Read metadata through the OLE DB schematics | yes | yes | yes | |||
| Access to Firebird/InterBase via ADODB. | yes | yes | yes | |||
| Support of IDBDataSourceAdmin interface and Firebird/InterBase database creation via ADODB Ext library (ADOX) | yes | yes | yes | |||
| Extended SQL support | ||||||
| DDL queries (ALTER, DROP, CREATE) | yes | yes | yes | |||
| Support of changes in DML (Data Model Language) for Firebird 2.0 — EXECUTE BLOCK, INSERT RETURNING | yes | yes | yes | |||
| Support of changes in DML (Data Model Language) for Firebird 2.1 — UPDATE OR INSERT, UPDATE RETURNING, DELETE RETURNING | yes | yes | yes | |||
| Support of ODBC Escape Sequences (used in Crystal Reports, MS SQL Server, SSAS) | ODBC 3.5 | ODBC 3.5 | ODBC 3.5 | |||
| ADO, Visual Basic, VBScript, JavaScript, Microsoft Office, etc | ||||||
| Support of ADO (ActiveX Data Objects), Visual Basic, VBScript, JavaScript | yes | yes | yes | |||
| Visual Basic For Applications (VBA) | yes | yes | yes | |||
| new! Microsoft Word. Using FB/IB databases as the source for emailing through the Mail Merge (menu item: Tools->Letters and Mailings->Mail Merge) | yes | yes | yes | |||
| new! Microsoft Excel. Using FB/IB databases as the source for importing in Excel (menu item: Data->Import External Data->Import Data) | yes | yes | yes | |||
| Visual Studio .Net 2003, 2005, 2008 (Orcas), 2010 | ||||||
| Connecting to IB/FB using C++ client library for any OLE DB Provider (Visual C++ only) | yes | yes | yes | |||
| Access to Firebird and InterBase from the ADO .Net library (C#, VB.Net, etc) | yes | yes | yes | |||
Extended support of the ADO .Net and Visual Studio wizzards and code generators:
|
yes | yes | yes | |||
| MS SQL Server | ||||||
| Connect Firebird and InterBase to the Linked Server in SQL Server 2000/2005/2008 | yes | read only | yes | |||
| Support SQL Server 2005 Business Intelligence (Analisys services, Integration Services, Reporting Services) | yes | no | yes | |||
| Borland Delphi, C++ Builder | ||||||
| Interacting with IB/FB through the our C++ client library for any OLE DB Provider | yes | yes | yes | |||
| yes | yes | yes | ||||
| Interacting with IB/FB through the standard components dbGo (ADO Express). The article: Working with InterBase and Firebird in Delphi | yes | yes | no dbGo does not support 8-bytes bookmarks |
|||
IBProvider Professional Edition (32/64 bit)
Professional distribution kit contains:
IBProvider v5
It is the most modern provider based on a new core. Our new data control technology is the result of lots of years research in to large corporate applications and data access libraries.
IBProvider Lite v5
This provider compatible with components based on the 4-byte rowset bookmarks (for example, dbGo, ADO Express from Delphi and C++ Builder).
Publish date: 2006-09-27. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link https://www.ibprovider.com/eng required.