New packages of IBProvider Professional Edition came out

Brief release annotation

IBProvider v3 Release Candidate 3 [build 3.0.0.4963]

• 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 builds of 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.

IBProvider v3 Release Candidate 3 build 3.0.0.4963

NUMERIC-types support was improved

• Correct view of NUMERIC-columns types with zero scale. This feature will not work for Interbase 4.x and Interbase 5.x.
• Precisions for NUMERIC-columns were changed to 4,9,18. In previous releases precisions were equal to 5/10/19. Precision depends on base type in which NUMERIC is stored (SHORT, LONG or INT64).
• Changes are true for simple columns and columns with arrays.

Backward compatibility

3 initialization properties: n numeric_i2_rules, numeric_i4_rules, numeric_i8_rules for backward compatibility were added. Set these properties in getline on value 3 and you will rollback provider.

Common troubles with NUMERIC and solution

Common troubles with NUMERIC and solutions. Servers Interbase/Firebird/Yaffil implement simplified precision control. For example, they allow storing 32000 value in NUMERIC(4,0). MS SQL Server 2005 checks uploaded data precision. If data precision is not in the allowed range MS SQL will generate the error:

To define behavior of a provider in this case, use properties numeric_i2_rules, numeric_i4_rules, numeric_i8_rules.

Correct processing of active transactions in the connection pool

• When using SQL for transactions start ADODB may put connection with active transaction to the connection pool. As a result, when you open connection again pool may return connection with unfinished transaction. In IBP v1, v2, v3 initialization property reset_ds_tr_rule.
• Reset to initial state of session settings of the multiple connections was implemented.

Metadata query optimization for disabled metadata cache mode

If you disable metadata cache schema_cache=0 new build of IBProvider use query with parameters with limits considered.

This feature cuts traffic between client and server and increase running speed in 2.5 times with cache disabled if compared to previous versions. schema_cache=1 by default (metadata cache is enabled).

Classification of external and temporary tables

In TABLES, TABLES_INFO metadata schemes in TABLE_TYPE column new tables classifications were added:

• EXTERNAL TABLE - all server types and versions supported
• GLOBAL TEMPORARY PRESERVE - Interbase 7.5, Firebird 2.1 or above.
• GLOBAL TEMPORARY DELETE - Interbase 7.5, Firebird 2.1 or above.

Other metadata changes

• In TABLES_INFO, TABLES schemes "EXTERNAL_FILE" column was added.
• In TABLES_OWNER scheme "TABLE_OWNER" column was added.
• Ignoring text case for column restriction in "TABLE_CONSTRAINT::CONSTRAINT_TYPE".

New builds of IBProvider v2, v1

• IBProvider v1 [1.9.9.2547]
• IBProvider v2 [2.6.3.2547]

Some features from IBProvider v3 RC3 are implemented

• Ignoring text case for field restriction in "TABLE_CONSTRAINT::CONSTRAINT_TYPE" was added.
• Correct interaction with connection pool.

Besides, a bug in BLOB-columns description was fixed

Due to the bug in release 2.6.1 (2.6.2), BLOB-columns were published with wrong flag DBCOLUMNFLAGS_ISFIXEDLENGTH.

Download IBProvider Professional Edition (64/32 bit) [build: 3.0.0.4963]

All

Publish date: 2008-07-30. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link to http://www.ibprovider.com required. Printable version: New packages of IBProvider Professional Edition came out

All IBProvider news:

2011-11-15 The new IBProvider 3.9.4 improves compatibility with .NET. Fixed known bugs. 2011-09-23 New IBProvider v3.9.1 become more faster. 2011-08-22 The new version of IBProvider v.3.9 is delivered with the warranty(!) of stable performance within systems operating around the clock. 2011-06-07 IBProvider v3.8.2. Are your data access components ready for Firebird 3? 2011-05-11 IBProvider v3.8. UDF in metadata schemas. Configuring of transaction isolation parameters. New "Free". 2011-04-03 IBProvider v3.7. Support for BOOLEAN [Firebird v3]. 2011-03-03 IBProvider v3.6. New interfaces for rowset and new metadata schema. 2011-02-14 IBProvider v3.5. Support for Firebird 2.5.1. Automatic generation of SQL queries has been improved. Support for parameters in SQL scripts. 2011-01-14 4 key distinctions of the new IBProvider v3.4 that make your applications faster 2010-12-18 In the new IBProvider version, we introduced support of the BASE64 charset of InterBase XE, improved algorithms, reduced requirements to memory and corrected errors 2010-11-16 Do you want to enable execution of SQL scripts in your programs and spend less time for exhausting coding? 2010-11-11 Do you want to receive the full-featured IBProvider 64/32? Participate in our contest! 2010-10-20 Do you use TIME and TIMESTAMP in your applications? The new IBProvider version will further simplify your work! 2010-09-16 The new IBProvider version has a new interface and can work correctly with case-dependent names of database objects via MS SQL. 2010-08-26 Download the final build of IBProvider Professional v3(!). 2010-07-08 New IBProvider Professional v3 RC5 that supports updatable rowsets is now available. 2010-06-11 Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. 2010-05-07 New IBProvider 3.0.0.9496 RC4 release appeared. Query parameters parsing and COM-locking was updated. 2010-04-19 Changes in SQL-parser. Support for SQLSTATE and NativeError. 2010-03-15 Three Reasons Why You Should Upgrade to the New IBProvider 2010-02-14 Be quick to get a free license for IBProvider Professional v.3.0.00.8628 2010-01-18 Today, on January 18, 2010, IBProvider celebrates its 10th anniversary. The grand banquet is preceded by the release of the latest IBProvider version with enhanced support of DDL and updatable rowsets. 2009-12-15 We have improved PROCEDURES scheme loaders to obtain the text of stored procedures in PROCEDURE_DEFINITION. 2009-11-16 Performance of the new IBProvider increased by 4.5 times 2009-10-07 IBProvider 3.0.0.7798. The work with large volumes of data was improved. 2009-08-13 New IBProvider 3.0.0.7575 with queries pool and enhanced working with Delphi. 2009-07-10 IBProvider now supports free ways of NULL-processing. 2009-07-04 New IBProvider version can emulate BOOLEAN and GUID types when working with Firebird and Interbase. 2009-06-11 New IBProvider version has the option of cancelling commands execution and supports the new type of Firebird 2.5 queries containing SQL_NULL. 2009-05-05 The option of working with TIME type via MS SQL Linked Server. 2009-04-17 16 versions of Firebird and Interbase are now available for recording on 64-bit platforms via MS SQL Linked Server. 2009-03-05 IBProvider v3 Release Candidate 4 with enhanced DDEX support and optimized working with nominated parameters. Metadata can now be accessed in user encoding. 2009-02-16 New IBProvider allows comprehensive work in Unicode applications, enhanced work with NONE encoding, and supports charset markers. 2009-01-12 The brand new mechanism has been developed in IBProvider v3 for working with Firebird and Interbase text data charsets. 2008-11-06 New IBProvider - support of 49 code pages, ability to work without provider registering, prevention of memory leaks in Firebird client. 2008-10-03 In the new edition of IBProvider Professional 7 codepages support was implemented, bugs were fixed, BLOB-fields access and memory management was improved 2008-08-25 The 6 world-wide Firebird Conference in Bergamo, Italy 2008-07-30 IBProvider updates are available. Operation with NUMERIC-types and connection pooling were improved. External and temporary tables support in metadata schemes was added. Disabled metadata cache mode performance was increased in 2.5 times. 2008-07-08 New IBProvider Release Candidate 3 is available. Support of the integrated Windows authentication (SSPI) for Firebird 2.1, Support of long names and BOOLEAN type in Interbase 7.x and Interbase 2007, etc. 2008-06-17 IBProvider releases have appeared. OCTETS character set support, data type converter release, 64 bits values in metadata schematics. 2008-05-12 IBProvider releases have appeared. New implementation of the data types converter. 2008-04-07 New IBProvider v3 for 64 bits operational systems. 2008-03-11 New build No 3965 of IBProvider v 3.0 RC2 has appeared. 2008-02-08 Visual Studio 2008 support was improved, work with DTC was corrected, known bugs were fixed and Firebird/Interbase compatibility was enhanced. 2007-12-26 We have changed the IBProvider license agreements and now give discounts. 2007-11-08 The second Russian Firebird and Interbase conference will take place in Moscow, November 23, 2007 2007-10-30 IBProvider Free Edition (3.0.0.3313 Release Candidate 2 [RC2]) has appeared. 2007-10-29 IBProvider v3 Release Candidate 2 (RC2) has appeared. 2007-10-18 New release of the IBProvider Professional Edition appears. We have improved Integration with Microsoft office and fixed known bugs. 2007-09-13 New providers versions in the Professional Edition now can be used with Microsoft SQL Server 2005 Business Intelligence Development Studio 2007-07-20 The latest editions of IBProvider Professional and IBProvider Free now support new features of Firebird 2.1 2007-05-25 Download engine now working. All customers will receive personal releases more quikly. 2007-04-27 The latest editions of IBProvider Professional and IBProvider Free are available for download. 2006-12-13 C++ client library for OLEDB providers now support the Unicode project types (which based on unicode strings). 2006-12-04 New releases appear: IBProvider Professional Edition - is a professional developer kit for Interbase and Firebird. IBProvider Free Edition - is an absolutely free of charge and most powerful version based on the commercial core of IBProvider v3. 2006-10-07 IBProvider 3.0.0.2385 [RC1] and IBProvider 2.5.0.2088 [Release] now avaliable. New properties aliases: Charset, PSWD. Metadata reading algorithm and SQL parser was optimized. Supporting arrays in ADO .Net. 2006-08-28 IBProvider 3.0.0.2065 [Beta]. IBProvider 2.4.7.2034 [Release]. MSSQL 2000/2005 integration improvement. 2006-08-13 IBProvider 3.0.0.1959 [Beta]. IBProvider 2.4.6.1989 [Release]. C++ library for OLEDB providers now support VC8 (VS2005) 2006-05-25 IBProvider 3.0.0.1324 [Beta]. IBProvider 2.4.5.1953 [Release]. Client Library for C++. 2006-05-05 IBProvider price will be changed after 23 may 2006. New demo versions are avalible 2006-03-30 IBProvider release v.2.4.4 (v.1.7.26) build 1885. IBProvider v.3 [build 1107 beta] 2006-02-27 IBProvider v.1/v.2 [build 1877 Release Candidate 1]. IBProvider v.3 [build 1062. beta] 2005-11-30 IBProvider 2.4.3.1859. Release. 2005-11-01 Fix of problem with arithmetic errors in .NET applications. 2005-09-28 IBProvider v3 [build 913] [beta version]. 2005-09-22 IBProvider v3 [build 890] [beta version]. IBProvider v2/v1 [build 1811]. 2005-09-01 The InterBase and Firebird Developer Magazine. 2005-07-28 IBProvider v3 [build 789] [beta version]. IBProvider v2/v1 [build 1802]. 2005-06-15 IBProvider v3 [build 779] [beta version]. IBProvider v2/v1 [build 1795]. 2005-04-12 IBProvider User Forum is Open 2005-03-22 IBProvider 2.4.2.1772. Release. 2005-02-28 IBProvider 3.0.0.639 beta. Change of the corporate license. 2005-02-11 IBProvider 3.0.0.573 beta. 2004-12-24 IBProvider 3.0.0.449 beta. 2004-11-12 IBProvider 2.4.1.1720/1.7.23.1720. Release. 2004-05-31 IBProvider 2.4.0.1607/1.7.22.1607. Release. 2004-05-14 Release Candidate 2.4.0.1588/1.7.22.1588 2004-04-30 Version 2.3.3.1523 beta 2004-03-29 Version 2.3.3.1416 beta 2003-12-17 Version 2.3.3.1300 2003-10-18 Version 2.3.2.1233 2003-08-22 Version 2.3.1.1184 2003-06-25 Version 2.3.0.1134 - extended support of MS AS, MS SQL 2003-04-23 Version 2.2.0.969 - Data Links dialog support, localization 2003-03-31 Version 2.1.2. 2003-03-26 Version 2.1.1. 2003-03-04 Version 2.1. The error processing mechanism is completely reconstructed. 2003-02-26 Discounts on IBProvider. 2003-02-18 Changes in License Terms 2003-01-23 Version 2.0.1.735. Bug fix, optimization, HTML help 2002-12-10 The second generation IBProvider 2002-11-21 Version 1.7.11.584 and 1.8.0.584 beta 2002-11-06 Version 1.7.10.542 and 1.8.0.542 beta 2002-10-20 Version 1.7.9.481 and 1.8.0.481 beta 2002-08-12 Version 1.7.6.350 and 1.8.0.350 beta 2002-07-30 Version 1.7.5.311 - Bugs fixing 2002-07-10 Version 1.7.4.289 2002-06-20 Version 1.7.3.269 2002-05-30 Version 1.7.2.255 2002-05-08 Version 1.7.1 2002-04-22 Version 1.7.0.227. Support of UNICODE. New prices. 2002-03-29 Version 1.6.3.213 2002-02-28 Version 1.6.2.201 2002-02-08 Version 1.6.2.199 2002-01-19 Version 1.6.1.185 2001-12-24 Free Version 1.5.2 2001-12-13 Version 1.6 2001-11-14 1.5.1 - Change of Compiler. Optimization. IColumnsRowset. etc. 2001-08-30 IN-OUT Parameters. Arrays. .... 2001-07-16 Error with test of connection in Data Links 2001-05-21 Support of stored procedure 2001-05-16 New samples on Delphi for MTS from Andrei Semak 2001-05-14 The final touches to RowSet 2001-04-30 Commercial release 2001-04-20 Support of DTC and Resource pooling 2001-04-04 Support for null-containing character in strings 2001-03-16 Implementaion of IOpenRowset::OpenRowset 2001-03-15 Support of DECIMAL and NUMERIC 2001-03-12 Errors correction... 2001-03-01 Fix bug in command prepare 2001-01-03 The main cardinal change is in accordance with implementation of operation auto-commit support. 2000-12-01 IBProvider and client library Reconstruction. 2000-09-15 New version of IBProvider for IB6.

Tags: Firebird, Firebird Delphi, Interbase Delphi, Firebird Download, Firebird ODBC driver, Interbase ODBC, Integration Services (SSIS), Firebird, Interbase и SQL Linked Server (MS SQL), Firebird .Net Provider, Visual Studio .Net 2008, (c#), Firebird 2.1, Firebird 2.0, Firebird 2, Firebird 64 bit, Interbase 64 bit, Interbase oledb provider, Interbase driver, Firebird ole db provider, Firebird driver