Tag: OLEDB

Release of IBProvider v5.37

Leave a comment

We are glad to present a new release of IBProvider — v5.37. This update contains a lot of internal changes and improvements. All the changes have been tested more than one time, so this release is ready for use in your projects. Please update your copy of IBProvider with this version. If you work with Firebird, please use «fb.direct» mode. Thanks.

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

Build of error message in built-in Firebird client

  • The current release of IBProvider adds the new initialization property ctype_system that allows to point a codepage of operation system where a connected database server is working. This information will help IBProvider process the DBMS system errors
  • Provider uses a connection charset for translating server error messages into UNICODE

Work with ICU

  • ICU 63.1 (FB4). A suppression of translation error between code pages is disabled now (FB:CORE-8108)
  • A processing of ucnv_open function return code is corrected

Common changes

  • vc16 binaries are compiled with C++20
  • vc15 binaries use a built-in thread pool based on the source code of the external thread pool of vc16/vc17 assemblies (source code unification)
  • The information content of the error message “unsupported database server version” is improved
  • The internal instrumental C++ library was refactored

With Best Regards, IBProvider Team.

IBProvider News

Leave a comment

Hello Everyone.

We have updated all our components and recommend our user and customers to use them.

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

IBProvider 5.36.x

  • Sending short BLOB via VARCHAR datatype (Firebird v2.5.1+)
  • A support of Windows XP was restored

LCPI ADO.NET provider for OLE DB v1.29

  • Assemblies for .NET8 were added

Other updates

  • LCPI OLE DB Services was updated
  • LCPI EF Core Provider for OLE DB was updated

Kind Regards, IBProvider Team.

IBProvider v5.35 and BIG testing with FB4

Leave a comment

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»

Leave a comment

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

Leave a comment

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]

Leave a comment

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

Leave a comment

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_rules, numeric_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

Leave a comment

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

Leave a comment

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.

1 2 3 … 11