Differences between IBProvider versions

Master table

Capabilities	IBProvider Free Edition	IBProvider Professional Edition
Capabilities	IBProvider Free Edition	Summary	IBProvider v1	IBProvider v2	IBProvider v3
Global
Support of the 64 bit architecture	no	yes	no	no	yes
Support of Firebird, including Firebird 2.1	yes	yes	yes	yes	yes
Support of Yaffil	yes	yes	yes	yes	yes
Support of Interbase up to 6.0	yes	yes	yes	yes	yes
Support of Interbase begin from 6.5 version, including Interbase 2007	no	yes	yes	yes	yes
Allows selecting client library (gds32.dll or fbclient.dll). See the dbclient_library initialization property	yes	yes	no	no	yes
Support information properties which contain client library info. IB Client, IB Client Version, IB Client Name	yes	yes	no	no	yes
No restrictions on data size. Using the own hard disk cache with 64 bit access.	yes	yes	yes	yes	yes
Support of server and client cursors	yes	yes	yes	yes	yes
Bookmark type	8 bytes	4 bytes/8 bytes	4 bytes	8 bytes	8 bytes
Distributed transactions and DTC	yes	yes	yes	yes	yes
Transaction savepoints	yes	yes	yes	yes	yes
Nested transactions	yes	yes	no	no	yes
Subscribtion on transaction commit/rollback events	yes	yes	no	no	yes
Support of information properties and algorithms implemented in Firebird 2 (for example, you can get database creation date)	yes	yes	no	no	yes
Updatable rowsets	no	yes	no	yes	not yet
Read metadata through the OLE DB schematics	no	yes	yes	yes	yes
Extended SQL support
DDL queries (ALTER, DROP, CREATE)	yes	yes	yes	yes	yes
Support of changes in DML (Data Model Language) for Firebird 2.0 - EXECUTE BLOCK, INSERT RETURNING	yes	yes	no	no	yes
Support of changes in DML (Data Model Language) for Firebird 2.1 - UPDATE OR INSERT, UPDATE RETURNING, DELETE RETURNING	yes	yes	no	no	yes
Support of ODBC Escape Sequences (used in Crystal Reports, MS SQL Server, SSAS)	ODBC 3.5	ODBC 3.5	a partly	a partly	ODBC 3.5
ADO, Visual Basic, VBScript, JavaScript, Microsoft Office, etc
Support of ADO (ActiveX Data Objects), Visual Basic, VBScript, JavaScript	yes	yes	yes	yes	yes
Visual Basic For Applications (VBA)	yes	yes	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)	no	yes	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)	no	yes	yes	yes	yes
Visual Studio .Net 2003, 2005, 2008 (Orcas)
Connecting to IB/FB using C++ client library for any OLE DB Provider (Visual C++ only)	yes	yes	yes	yes	yes
Access to Firebird and Interbase from the ADO .Net library (C#, VB.Net, etc)	yes	yes	yes	yes	yes
Extended support of the ADO .Net and Visual Studio wizzards and code generators : Data Source Configuration Wizzard Build queries with Query Builder Generate DataSet Generate Table Adapters DataSet designer Server Explorer	yes	yes	yes	yes
MS SQL Server
Connect Firebird and Interbase to the Linked Server in SQL Server 2005/2000	no	yes	read only	yes	read only
^new! Support SQL Server 2005 Business Intelligence (Analisys services, Integration Services , Reporting Services)	no	yes	no	yes	read only
Borland Delphi, C++ Builder
Interacting with IB/FB through the our C++ client library for any OLE DB Provider	yes	yes	yes	yes	yes
OLE DB Direct VCL library	yes	yes	yes	yes	yes
Interacting with IB/FB through the standard components dbGo (ADO Express)	no	yes	yes	no	no

IBProvider Professional Edition (32 bit)

Professional distribution kit contains:

IBProvider ver. 3.0.0.4773 RC3
It is the most modern provider based on a new core. Our new data control technology is the result of the 5 years research in to large corporate applications and data access libraries. It while not support the updatable rowsets, but we are plan to implement this feature in the next releases.

IBProvider ver. 2.6.2.2537
Special designed for working with SQL Server using the Linked Server.

IBProvider ver. 1.9.8.2537
This provider compatible with components based on the 4-byte rowset bookmarks (for example, dbGo, ADO Express for Delphi and C++ Builder).

IBProvider Professional Edition (32/64 bit)

Special 32/64 bit edition contains all IBProvider drivers from 32-bit edition and latest 64-bit IBProvider ver. 3.0.0.4773 RC3.

Download IBProvider Professional Edition (32/64 bit)

IBProvider Free Edition

We believe in IBProvider v3 quality and robustness. And we want to make a gift for all Interbase and Firebird Community users. New IBProvider v3 Free Edition is absolutely free of charge and most powerful version based on the commercial core of IBProvider v3. We are sure, the community will appreciate our gift, since previous free IBProvider v1.5 (Dec 2001) still counts about a thousand downloads a month.

Download IBProvider Free Edition

All

Site Build No. 3.0.0.1113