New IBProvider releases have appeared. Visual Studio 2008 support and DTC support were improved, known bugs were fixed and Firebird/Interbase compatibility was enhanced.

IBProvider v3 RC2 [build 3.0.0.3861]:

  1. Implemented support of Server Explorer for Visual Studio 2008.
  2. New WIN1258 code page was added.
  3. Loading CHAR-arrays bug was fixed.
  4. Errors handling implementation for Ole DB properties was strongly conformed to OLE DB standard.

IBProvider v1, v2

The bug concerning dynamic memory heap was fixed.

Firebird 2.x compatibility was improved

Firebird 2 and Firebird 2.1

Text arrays' support was improved. Known FB server bugs were fixed on the IBProvider level.

Backward compatibility mode

When you tried to attach database which was created in older versions of FB (FB1.5, FB1, FB 0.9.4) to Firebird 2.x you can get an incorrect behavior. Now all known issues were closed.

ODBC escape sequences parser was improved

VIEWS support was improved

  • Solving problems while using FB/IB views from MS SQL Linked Server.
  • COLUMNS scheme. Nullable attribute for view columns is now calculated correctly for Firebird 1.5, FB 2.x, Interbase 2007.
  • Interbase 4 compatibility was improved. Loading VIEWS scheme issue was fixed.

Essential improvement of the DTC support

DTC - Distributed Transaction Coordinator.

DTC applies in:
  • MS SQL Linked Server uses DTC for synchronization the local transactions with linked server transactions.
  • The realization of the distributed transaction through the TransactionScope class in .Net Framework

For all IBProvider versions

  • Control improvement: Now if transaction is connected to DTC, it can not be finished through session methods (Commit or Rollback).
  • ITransaction::GetTransactionInfo. If the transaction is connected to DTC, the method returns UOW (UnitOfWork) identifier of the distributed transaction.
  • Two-phase commit was supported.
Two-phase commit (Two-phase transaction)

The Transaction commit has 2 phases:
Preparation phase - all the members of the distributed transaction are interrogated on commit end.

Commit phase - If all the members are ready to commit transaction, the coordinator sends the commit order.

It is guaranteed that all the members of the distributed transaction stay in agreed circumstances.

IBProvider v3

Additional control for commit the transaction connected to DTC through the SQL requests.

Summary

We constantly work to provide our clients with the reliable, functional and general-purpose decision that lets realize any projects on Firebird and Interbase.

The new release is one more possibility to feel the whole power of modern development tools, reduce the expenses and solve tasks in a short period of time.

New releases are available to anyone .