Publish date: 2010-07-08

New IBProvider Professional v3 RC5 that supports updatable rowsets is now available

We are pleased to announce that we have finished working on the last part of the provider’s third version – updatable rowsets. Starting from the current release, the third version fully surpasses the functionality of the second version, of course with the new level of quality. The key aspects of the new implementation of updatable rowsets:

  • Support of all types of IB/FB data
  • Enhanced processing of user and automatically generated queries for saving changes to the database
  • Usage of centralized cache of queries on connection level
  • New implementation of local cache for updatable rowsets

For backward compatibility with previous releases of the third version, we defined the new initialization property enable_updatable_rowset that allows to enable/disable support of updatable rowsets.

IBProvider v3 and Microsoft Linked Server

When using IBProvider v3 as a linked MSSQL server, we recommend to pay attention to the initialization property «nested_trans». With nested_trans=true in the initialization string, the provider supports embedded transactions and you can write MS SQL Server scripts without «set xact_abort on».

NOTE: Embedded transactions are emulated on the basis of savepoints. Of course, your FB/IB server must support them.

For the users of dbGo components: new edition of the IBProvider — LCPI.IBProvider.3.Lite

LCPI.IBProvider.3.Lite was developed to substitute LCPI.IBProvider.1. It will allow the users of dbGo components to use server cursor for read-only sets, which will drastically reduce storage consumption and increase operation speed of the access component. Moreover, columns with arrays will be available via server cursor.

Main Lite’s parameters:

  • The bookmark size is 4 bytes in the 32-bit build and 8 bytes in the 64-bit build
  • Absence of the support for updatable rowsets

Availability of new builds and editions of the provider

All the clients with active licenses have access to the new and previous builds without any limitations.

Publish date: 2010-07-08. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link required.