IBProvider Release Candidate 4

New release candidate of IBProvider Professional Edition has appeared. Is the modern driver for access to 16 versions of the Firebrd and Interbase servers.

Improved support of DDEX (Data Designer Extensibility) when working with Firebird and Interbase

IBProvider RC4 has the new option of stored procedures calling in Visual Studio 2008 style via ODBC escape sequences. This innovation allows to create queries and TableAdapters based on stored procedures.

Optimized working with named parameters in SQL query text

  • Fewer limitations for multiple use of same named parameter in SQL query text
  • New algorithm for choosing named parameter data type.
  • Some errors of named parameters procession detected via profound testing by exhaustive method have been eliminated.

Metadata schemes and column descriptions (IColumnsRowset) support user encoding

Metadata schemes and IColumnRowset interface now consider user charset . This allows working with metadata in set encoding.

What comes next?

New IBProvider allows comprehensive work in Unicode applications, enhanced work with NONE encoding, and supports charset markers.

New IBProvider v. RC3

  • All the detected problems that prevented comprehensive work with Firebird and Interbase from UNICODE applications have been eliminated.
  • Supports charset markers in SQL queries.
  • Supports exclusions processing when working with Interbase and Firebird via ADODB.
  • Supports working with database object names containing national symbols for connections with NONE charset.
  • Enhanced work with metadata schemes when working with database via NONE charset.
  • Advanced testing allowed detection and elimination of errors.
  • ISO8859_15 charset support.

Please read details on the Firebird driver homepage.

IBProvider for Firebird and Interbase has been released.

Changes in IBProvider v2 (build

  • Addition of UTF-8 charset support
  • Loading of charset information for COLUMN and PROCEDURE_PARAMETERS metadata schemes from system tables.

Changes in IBProvider v3 (build RC3)

New IBProvider v3 offers the brand new method for working with text data charsets:

  • We added ctype_user property that allows setting the encoding of data coming to client irrespective of the encoding in which this data is coming from database server.
  • New algorithms of BLOB fields converting provide for quick work with flowing data, optimization of interaction with ICU library.
  • We added ctype_none property that allows setting the charset for working with text data in NONE encoding.
  • Other important changes.
  • Support of Firebird and Interbase charsets aliases.

See detailed information on working with new character set processor in Firebird and Interbase character sets.

Text columns size in Firebird 2.X

IBProvider started to control text columns size when working with Firebird 2 servers in Unicode mode. If the length of loaded data exceeds the text column size the exclusion will be generated.

Access to Firebird from Delphi using dbGo components

The new article was published: Working with Firebird and Interbase from Delphi using IBPRovider and dbGo components.

Table of content:

  • TADOConnection component
  • TADOTable component
  • TADODataSet component
  • Sending changes to database – updatable rowsets technology
  • Client and server cursors
  • What provider to choose?
  • TADOQuery component
  • SQL-queries with parameters
  • TADOStoredProc component
  • TADOCommand component
  • Transactions

New IBProvider support of 49 code pages

The new IBProvider version:

Read details on: Firebird driver news channel

New article: Start working with Firebird

IBProvider announce the artcile: Start working with Firebird
Table of content:
What is Firebird SQL Server?
What Firebird version to choose?
Firebird installation: choosing server type
       Firebird Super Server
       Firebird Classic Server
       Firebird Embedded
       If it is difficult to choose
Start working with Firebird
      New Firebird database creation
Firebird security
      SYSDBA User. Changing default password
Connection to Firebird from client’s application
     Firebird and VBScript, Visual Basic, VBA
     Firebird and Delphi
     Firebird and .Net
     Firebird and C++
Firebird database editing
    The List of Firebird administration utilities
Useful links

Original manual: Firebird

In the new edition of IBProvider Professional 7 codepages support was implemented, bugs were fixed, BLOB-fields access and memory management was improved

IBProvider v3 Release Candidate 3

  • Support of the following codepages added: DOS858, TIS620, BIG5, KSC_5601, GB_2312, SJIS_0208, EUCJ_0208;
  • Bug in the errors handling for OUT-parameters of query was fixed;
  • BLOB-fields access was improved;
  • Memory management was improved;

IBProvider v2/v1

  • BLOB-fields access was improved;
  • Memory management was improved;

Source: Interbase and Firebird driver site

New packages of IBProvider Professional Edition came out

IBProvider v3 Release Candidate 3 [build]

  • NUMERIC-types support was improved.
  • Disabled metadata cache mode performance was increased in 2.5 times.
  • Metadata schemes were updated. Among them in schemes TABLE_INFO and TABLES classification of external (EXTERNAL TABLE) and temporary tables (GLOBAL TEMPORARY PRESERVE/DELETE) was added starting from Firebird 2.1 and Interbase 7.5.
  • Correct processing of active transactions in the connection pool.

New build IBProvider v1.9.9.2547 and IBProvider v2.6.3.2547

  • BLOB-columns metadata description bug was fixed.
  • Correct processing of active transactions in the connection pool.

Details on the Firebird driver site.

IBProvider Release Candidate 3 is available

  1. Support of the integrated Windows authentification (SSPI) for
    Firebird 2.1.
  2. Support of the system auth using environment variables: ISC_USER and ISC_PASSWORD.
  3. Feature of enable/disable database triggers for separate connection is available.
  4. Support of long names and BOOLEAN type in Interbase 7.x and Interbase 2007 was added.
  5. Support of arrays was improved. Access to arrays via IBProvider now becomes more robust in comparison with other Firebird database access components.

Read details on the IBProvider site.

1 8 9 10 11