IBProvider v3.0.0.3861 RC2. Visual Studio 2008 support was improved, work with DTC was corrected

IBProvider v3 RC2 [build 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

• ODBC function TIMESTAMPADD gets an optional parameter QUARTER.
• ODBC function LOCATE was optimized.
See the completed guide to ODBC Escape Sequences.

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.
• Fixed implementation of a two-phase commit.

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.

---