IBProvider v5.35 and BIG testing with FB4

Hello Everyone!

We are pleased to present a new release of our OLE DB provider for Firebird and InterBase, which has undergone not only standard load testing, but also BIG testing with Firebird v4, which lasted more than a month. This is more than 7 million tests executed in parallel on a ten-core processor.

IBProvider v5.35

In this new version of the provider, the internal infrastructure has been improved — now the cancellation of query execution also applies to operations with BLOBs.

BIG testing with FB4

The last time BIG testing was done was 3 years ago with FB 3.0.8.33401…

Read more: https://www.ibprovider.com/eng/news/n_240212-fb4_big_testing.html

With Kind Regards, IBProvider Team.

Final release of «Native OLE DB Provider for Firebird v4»

Hello Everyone!

We are very pleased to announce the release of final IBProvider v5.32 with support for Firebird v4.

Some of our users have already appreciated our work and started using IBProvider with FB4, including as a linked MSSQL server.

We are grateful to everyone who helped us.

Special thanks to Marek D., who initiated this process.

General overview of FB4 support in IBProvider

  • The direct connection and connection through fbclient.dll are supported
  • The 63-symbols object names are supported
  • Provider supports the following new datatypes (including arrays):
    • INT128
    • NUMERIC on INT128 base
    • DECFLOAT(16)
    • DECFLOAT(34)
    • TIMESTAMP WITH TIME ZONE
    • TIME WITH TIME ZONE
  • Provider supports two mode for processing time zones:
    • Through own algorithms
    • Through external library (ICU)
  • The support of the following queries was implemented:
    • SET DECFLOAT ROUND
    • SET DECFLOAT TRAPS
    • SET BIND
  • Provider executes ALTER SESSION RESET before reusing of the connection. Example
  • The new connection initialization properties were added.

In addition to the above, we have significantly improved the existing functionality.

Therefore, it makes sense to upgrade even if you are not yet planning to move to FB4 or are working with InterBase.

https://www.ibprovider.com/eng/news/n_230919__native_oledb_provider_for_fb4.html

With Best Regards, IBProvider Team.

Release of IBProvider v5.31

Hello Everyone!

We have completed the third step in the process of implementing FB4 support in our OLE DB provider.

This release adds support for TIMESTAMP WITH TIME ZONE, improves support for INT128 and improves support for NUMERIC data types.

Please review the changes carefully.

At the end of the news we have prepared a special offer for you.

https://www.ibprovider.com/eng/news/n_230817__fb4_step3.html

Kind Regards, IBProvider Team.

IBProvider v5.30. DECFLOAT and improved connection pool [FB4]

Hello Everyone.

In the current release, we have continued expanding the support of Firebird v4.

https://www.ibprovider.com/eng/news/n_230620__fb4_step2.html

New features

  • The full support of DECFLOAT(16) and DECFLOAT(34) has been implemented
  • The new version of IBProvider supports the ICU v63 from FB4 kit
  • Using «ALTER SESSION RESET» for resetting a connection before reusing (see this new example)

Kind Regards and Good Luck! IBProvider Team.

IBProvider v5.29. The initial support of FB4

Hello All 🙂

The implementation of FB4 support requires time. That is why we decided to split this process into parts and make intermediate releases. It will allow you to begin using IBProvider with FB4 right now.

https://www.ibprovider.com/eng/news/n_230522__fb4_step1.html

The current support of FB4

  • You can work with FB4 through fbclient.dll
  • You can work with FB4 through a built-in client (dbclient_type=fb.direct). The 13th protocol will be used
  • The long name of database objects are supported
  • All the FB4 datatypes (including new datatypes: INT128, DECFLOAT, time/date with a time zone) are supported at the metadata layer
  • The full support of INT128 and NUMERIC on base INT128 was implemented
  • New initialization properties were added — int128_rulesnumeric_i16_rules

Lots of functional and load tests were made with using FB v4.0.3.2937.

For mission-critical, multi-threaded and 24/7 applications, we highly recommend using the built-in client.

IBProvider Free does not support FB4.

Additional changes

  • The support of DBTYPE_TIMESTAMPOFFSET was added
  • The transformation between {DBTIME, DBTIME2} and {DATE, DBDATE, DBTIMESTAMP, FILETIME} was deleted
  • The transformation of NUMERIC into VARIANT was improved
  • The procession of charset names was corrected

With best regards, IBProvider Team.

The release of IBProvider v5.28

Hello Everyone!

We are pleased to present this new release of our flagship product. During its development, a number of old problems were identified and solved. Also the internal structure was improved for the next stage of development.

https://www.ibprovider.com/eng/news/n_230424.html

List of changes

  • The keyword list of FB v2.5.9 was corrected.
  • The keyword list of FB v3.0.4+ was corrected.
  • The definition of TIMESTAMP, TIME and DATE in PROVIDER_TYPES was corrected.
  • [DirectFB] The support of protocols v10-v12 was corrected. It solves problems with FB3.
  • [DirectFB] The support of protocol v13 was improved.
  • [ISC API] The protection from negative length of CHAR/VARCHAR datatypes was added.
  • The new initialization property «force_nulls» was added for conducting low-level tests.
  • Lots of internal changes and improvements were made.

Testing

  • Our primary test server for load tests is FB v3.11.

The current plans

  • The primary direction of our work is the implementation of FB4 support.

With best regards, IBProvider Team.

IBProvider News

Hello Everyone.

We have a couple of news for you.

1. We have just released the new set of our components where is provided a new solution to using IBProvider without registration in Windows:

  • IBProvider v5.27
  • LCPI OLE DB Services v1.22
  • LCPI ADO.NET Data provider for OLE DB v1.26

2. We released Free IBProvider x64.

You can get more information about these things at our web site.

https://www.ibprovider.com/eng/news/n_230125.html

With Best Regards, IBProvider Team.

IBProvider News

Hello Everyone!

We came back with new releases 🙂

We have just finished the large revision of our components and we are really glad to announce the following new versions:

  • LCPI EF Core Provider for OLE DB v6.0.8
  • LCPI IBProvider v5.26
  • LCPI OLE DB Services v1.21

You can read about changes in these components at our website – https://www.ibprovider.com/eng/news/n_221110.html

Only for visitors of this resource. We restored our store at PayProGlobal and we would like to test it 🙂

Everyone who will buy or renew a license for IBProvider 32/64bit till the end of this month will get two years of free updates.

With Best Regards, IBProvider Team.

Source Code Of IBProvider Client For Firebird

Hello Everyone.

Recently we published the source code of IBProvider built-in client for work with Firebird without fbclient.dll.

https://github.com/ibprovider/TechDemo-IBProvider.FirebirdClient-v01

It supports Firebird from v0.9.4 till v3.0.

It’s a stable and completely tested thing which has worked since 2017.

If you are interested in such things – you are welcome.

Source code of the test system is available, too.

License: MIT.

Regards, IBProvider team.

1 2 3 11