Tag: OLEDB

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.

IBProvider News

Leave a comment

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.

Release of EFCore Provider for IBProvider

Leave a comment

Hello All!

We have a great New Year’s gift for everyone who uses IBProvider to work with Firebird.

This is the provider for Entity Framework Core v6.0 — Lcpi.EFCore.LcpiOleDb!

We tried to make it as good as possible.

And most importantly — we opened its source code!

So you can make it even better 🙂

Target platform

  • NET6 (Windows)
  • Entity Framework Core v6.0
  • Firebird v3.0.8
  • LCPI ADO.NET Provider for OLE DB
  • LCPI.IBProvider v5

Key Features

  • Supporting of databases with 1 and 3 dialects.
  • Supporting of all FB3 datatypes, except arrays.
  • Providing a local evaluation by server’s rules.
  • Supporting mapping wide set of C# functions to SQL.
  • Providing extensions for nullable value types.

Acknowledgments

Thanks to our users and special thanks to Jeff Hampton who initiated this development process.

Thanks to the EFCore developers and special thanks to Andriy Svyryd.

Thanks to the developers npgsql/efcore.pg and FirebirdSQL/NETProvider.

Links

This news on our website: https://www.ibprovider.com/eng/news/n_211220-lcpi_efcore_lcpioledb.html

KR, IBProvider Team.

IBProvider News. Visual Studio 2022 support

Leave a comment

Hello Everyone!

64-bit Visual Studio 2022 is out today!

We couldn’t stay away from this epic release of Visual Studio and happy to provide support for this IDE from our components.

LCPI ADO.NET Provider for OLE DB v1.25.1

This release contains new DDEX providers for Visual Studio 2022.

We ported all DDEX providers, which were created for VS2019 and FW4.5.0/4.6.2/4.7.2/4.8.0, .NET Standard 2.0.

Moreover, we added DDEX provider for FW3.5.

All DDEX providers packaged into VSIX installers and automatically registering in VS2022.

Just remind, previous releases added the ADO.NET provider for NET6, which supports new system data types: DateOnly and TimeOnly.

IBProvider v5.24 and «LCPI OLE DB Services» v1.20

These releases added vc17 assemblies, compiled by a new studio C++ compiler.

—

Read more: https://www.ibprovider.com/eng/news/n_211108-vs2022.html

KR, IBProvider Team.

Load testing of IBProvider v5.21.1 and Firebird v3.0.7

Leave a comment

Hello All.

We have good news for everyone who uses IBProvider in critical and complex systems.

A «large», multithreaded, load testing of the latest release of IBProvider v5.21.1 and Firebird v3.0.7 (SS, Win, x64) has been carried out.

This is more than 7 million tests that were performed on a 10-core processor.

The main point of this testing was that the global cache of the SQL query parser was used (sql_cache__scope=db).

As usual, the built-in client for Firebird (dbclient_type=fb.direct) was used.

Testing completed with no visible problems.

See additional info at our web site: https://www.ibprovider.com/eng/news/n_201225.html

Best regards, IBProvider Team.

1 2 3 … 10