Differences between IBProvider versions

Master table
Capabilities IBProvider Professional Edition
Summary IBProvider v3 Lite (for dbGo) IBProvider v3
Global
Support of Firebird up to 2.0 versionyes yes yes
Support of Interbase up to 6.0yes yes yes
Support of Yaffilyes yes yes
Support of Firebird begin from 2.1 version, including Firebird 3.0yes yes yes
Support of Interbase begin from 6.5 version, including InterBase XE (2010)yes yes yes
Support of the 64 bit architectureyes yes yes
Allows selecting client library (gds32.dll or fbclient.dll). See the dbclient_library initialization propertyyes yes yes
Support information properties which contain client library info. IB Client, IB Client Version, IB Client Nameyes 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 cursorsyes yes yes
Bookmark size4 bytes/8 bytes 4 bytes 8 bytes
Distributed transactions and DTCyes yes yes
Transaction savepointsyes yes yes
Nested transactionsyes yes yes
Subscribtion on transaction commit/rollback eventsyes yes yes
Support of information properties and algorithms implemented in Firebird 2 (for example, you can get database creation date)yes yes yes
Updatable rowsetsyes no yes
Connection poolingyes yes yes
Query poolingyes yes yes
Character sets processoryes yes yes
Read metadata through the OLE DB schematicsyes 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 RETURNINGyes yes yes
Support of changes in DML (Data Model Language) for Firebird 2.1 - UPDATE OR INSERT, UPDATE RETURNING, DELETE RETURNINGyes 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, JavaScriptyes 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:
  • Data Source Configuration Wizzard
  • Build queries with Query Builder
  • Generate DataSet
  • Generate Table Adapters
  • DataSet designer
  • Server Explorer
yes yes yes
MS SQL Server
Connect Firebird and Interbase to the Linked Server in SQL Server 2000/2005/2008yes read only yes new!
Support SQL Server 2005 Business Intelligence (Analisys services, Integration Services, Reporting Services)yes no yes new!
Borland Delphi, C++ Builder
Interacting with IB/FB through the our C++ client library for any OLE DB Provideryes yes yes
OLE DB Direct VCL libraryyes yes yes
Interacting with IB/FB through the standard components dbGo (ADO Express). The article: Working with Interbase and Firebird in Delphiyes yes new! driver does not support 4 bytes server cursor

IBProvider Professional Edition (32 bit)

Professional distribution kit contains:

IBProvider ver. 3.10.1.13145
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.

IBProvider Lite ver. 3.10.1.13145
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.10.1.13145.



>> Download IBProvider Professional Edition (32/64 bit)