New version of RedExpert 2022.02 is available

Added:

  1. Edit object button
  2. Password request dialog if password is empty
  3. Ability to work with cursors in a procedure
  4. Downloading updates in the background

Fixed:

  1. Request for saving data when closing a dialog box
  2. Displaying tables on Firebird with version less than 2.5
  3. Generating a function creation request with EXTERNAL NAME
  4. Inability to set the order of the index fields
  5. Incorrect display of dependencies
  6. Wrong generated column edit query when using a domain
  7. Syntax highlighting in views
  8. Recognition of object names in queries if they are at the beginning of a string
  9. Error adding a record with IDENTITY field
  10. Autocomplete errors in queries with aliases
  11. Tab-indexing order on connection page
  12. Wrong error “TABLE is in use” on attempt to remove table
  13. Error opening browser in Linux
  14. Index is active by default when created
  15. Modified the update dialogs
  16. High CPU load after connect
  17. DDL command generation error due to case-sensitive identifiers
  18. Connecting to a database immediately after it is created
  19. Commit transactions after they have been used
  20. Re-executing an SQL script without mandatory commit/rollback after a previous run
  21. Option to set null for string parameters in the parameter dialogue

Download and install the new version.

dbMigration .NET v15.0 released

dbMigration .NET 15.0 is a simple, easy and intuitive multiple database migration and data synchronization tool,
With it you can easily migrate and synchronize data to Firebird and vice versa without complicated procedures.
(Free for non-commercial and a single executable file without installation)
Major New features and improvements from 14.4 to 15.0:

  • Added support for the timeonly data type
  • Added support for the Srp256 authentication of Firebird
  • Fixed support for Firebird 1.5
  • Improved Bulk Insert mode
  • Improved Filtering source data and Showing target data
  • Improved user experience and user interface
  • GetSchemaTable performance improvements
  • Updated FirebirdSql.Data.FirebirdClient to 8.5.4.0
  • Updated the target .NET Framework to 4.7.2
  • and more

https://fishcodelib.com/DBMigration.htm

Upscene releases Database Workbench 6

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 6.0″

This new version is faster on meta data loading, brings a more consistent user interface, new features and introduces the Enterprise Edition.

Database Workbench 6 comes in 3 different editions with different pricing models, there’s always a version that suits you!

Jaybird 4.0.5 and 3.0.12 released

Jaybird 4.0.5 and 3.0.12 have been released. Jaybird 3.0.12 is the final release of Jaybird 3.

The following has been changed or fixed since Jaybird 4.0.4 and 3.0.11:

  • Fixed: JnaService implementation call to isc_service_query incorrectly includes type (jaybird#678)

Jaybird 4.0.5
Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11, and 17 (support for Java 17 using the Java 11 version of the driver). See also:

Jaybird 3.0.12
Jaybird 3 supports Firebird 2.0 and higher, on Java 7, 8, 11, and 17. Basic Java 9 and higher compatibility is provided through the Java 8 version of the driver.

With the release of 3.0.12, Jaybird 3 is now end-of-life, and we recommend upgrading to Jaybird 4.

See also:

Release of EFCore Provider for IBProvider

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

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.

Released: Migration Guide to Firebird 4 (English version)

Migration Guide to Firebird 4

The English version of the Migration Guide to Firebird 4 eBook is now available to everyone who wants to save time and have a smoother migration from an older Firebird version to Firebird 4.

The Guide has 206 pages, and cover several topics including features introduced in Firebird 4, like Time zones, Read Committed Read Consistency isolation, Replication, Decfloat, etc. The eBook is now available in PDF format. A printed version will be made available in Amazon in the near future.

Initially available only in Portuguese, it is the result of a successfull crowdfunding campaign in Brazil, with the participation of +300 people.

Jaybird 4.0.4 released

Jaybird 4.0.4 has been released.

The following has been changed or fixed since Jaybird 4.0.3:

  • Fixed: ResultSet.updateRow() sets fields to null in result set only (jaybird#37)
  • New feature: Support for NBackup GUID-based backup and in-place restore (jaybird#672)
  • Fixed: Logic error could lead to incorrect logging of “Specified statement was not created by this connection” (jaybird#674)
  • Changed: Updated Firebird 4.0 reserved words based on 4.0.0.2496 (jaybird#597)
  • Fixed: Protocol 15 and 16 had same priority, so Firebird 4.0 might select protocol 15, leading to timeout support not available. (jaybird#676)

Jaybird 4.0.4

Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11 and 17 (support for Java 17 using the Java 11 version of the driver).

See also:

1 4 5 6 7 8 146