RED SOFT has added support of Firebird 3 into the Django 2.2 framework.
RED SOFT developer Vasily Yashkov made a pull request which recently has been accepted. Find details and main changes here.
The new version of the driver was successfully tested with Django 2.2.10/2.2.11 and Firebird 3/RedDatabase 3.
If you use Django with Firebird 2.5 or less please try to migrate your database to Firebird 3.0 and test new version of the driver. Now you can install it manually as described in the instruction but follow the news and wait the next release soon.
Devart company continues to improve their connectivity solutions including ODBC driver for Firebird.
Recently company released new version of it’s driver which now has beta support of Linux and Mac OS. You can download new drivers now
Firebird ODBC driver for Linux beta
Firebird ODBC driver for Mac OS beta
Devart company updated its set of ODBC drivers for various databases including Firebird database.
New Firebird ODBC driver gained improved performance and:
- Compatibility with Microsoft Visual Studio is improved
- Compatibility with Microsoft Office is improved
- Compatibility with Microsoft SQL Server Management Studio is improved
- Compatibility with Crystal Reports is improved
- Compatibility with ClikView is improved
Check what our new ODBC drivers can offer to you.
Download Firebird ODBC driver 1.2
Following the updated release of IBDAC (Delphi data access components for Firebird) Devart released a huge update of it’s dbExpress drivers. Among them you can find updated dbExpress driver for Firebird/Interbase.
Among many improvements and bug fixes those drivers received RAD Studio 10 support and now the trial limitation by 6 columns is removed from the Trial version for Win64 and it becomes a fully-functional Professional Edition.
You can already download new updated dbExpress driver for Firebird now – https://www.devart.com/dbx/interbase/download.html
Devart team is proud to introduce new Firebird ODBC Drivers.
The most significant features in this version are:
– Drivers fully support standard ODBC API functions and data types, multiple server data types and features.
– Advanced connection string parameters provided to allow any desktop and web applications to access databases from various environments and platforms, that support ODBC.
– Full Unicode support provides capacity to interpret Unicode function calls without the intervention of the Driver Manager.
– Advanced data conversion from DBMS data types to native ODBC data types.
– Support for 32-bit and 64-bit Windows platforms provides capabilities to develop both 32-bit and 64-bit cross-platform database applications (Linux and Mac OS X platforms will be supported in the next version).
ODBC driver for Firebird supports Firebird server and client versions 2.x, 1.x.
More details Download Firebird ODBC driver
If you have ever worked with Firebird or Interbase using the standard .NET provider for OLE DB (System.Data.OleDb), you will have likely encountered issues like this:
- The necessity to add ALL parameters manually.
- Even though the OLE DB provider supports parameter generation for commands, the .NET provider doesn’t use it, so you as the programmer must do that work on your own.
- The lack of support for named parameters. Although they actually exist, using them in reality requires a whole set of complex manipulations (the steps needed to add a parameter to a collection, etc.).
- The impossibility of using multiple DataReader objects at the same time (Multiple Active Result Sets).
- No execution of SQL scripts which contain several SQL expressions per command. This list of difficulties a .NET developer has to deal with is far from complete. Now it’s all different in a fundamentally new .NET Data Provider for OLE DB
We are continuing to actively add new functionality of Firebird 3 DBMS to IBProvider.
Let us remind you that already 2 months ago we added support of BOOLEAN data type from Firebird 3. In the new version of IBProvider Professional, we added support of PACKAGE instruction.
Now you can put in order a bulk of database procedures and functions and group them by sense into individual modules (PACKAGE). This arrangement will substantially simplify understanding and maintenance of SQL code.
Ream more about Firebird 3 access improvements.
New version of IBProvider is now available. The new release:
- Use Unicode Windows API for national alphabet.
- Has an improved compatibility with SharePoint Designer.
- Errors in the type converter have been eliminated.
Be quick to get a free license for IBProvider Professional
Quite recently, Firebird 2.5 Release Candidate 2 appeared. During regular IBProvider testing with new FB2.5 SuperClassic (RC2), we revealed a problem in the server: page 14194, page type 5 lock conversion denied (215).
The first person who publishes the reproduced example at our forum will be awarded with a free license for IBProvider Professional 64 bits Single Developer!
New release candidate of IBProvider Professional Edition has appeared. Is the modern driver for access to 16 versions of the Firebrd and Interbase servers.
Improved support of DDEX (Data Designer Extensibility) when working with Firebird and Interbase
IBProvider RC4 has the new option of stored procedures calling in Visual Studio 2008 style via ODBC escape sequences. This innovation allows to create queries and TableAdapters based on stored procedures.
Optimized working with named parameters in SQL query text
- Fewer limitations for multiple use of same named parameter in SQL query text
- New algorithm for choosing named parameter data type.
- Some errors of named parameters procession detected via profound testing by exhaustive method have been eliminated.
Metadata schemes and column descriptions (IColumnsRowset) support user encoding
Metadata schemes and IColumnRowset interface now consider user charset . This allows working with metadata in set encoding.
What comes next?
We continuously improve IBProvider and present new options for users with each new release. IBProvider Release Candidate 4
is the last RC of the third version.
We are planning complete substitution of IBProvider v2 functionality in the next IBProvider v3 Release:
- ability to work with updatable rowsets;
- support of data recording via Microsoft SQL Server Linked Server;
Currently IBProvider v2 is the only provider that allows to update data in Firebird and Interbase linked server. Other drivers allow only data reading from source.
IBProvider v3 RC4 is the result of 4-year innovations in data processing. It has implemented a lot of solutions and technologies, which make it completely different from other access components:
- Controllable charsets processor;
- SQL-parser with ODBC Escape Sequences support;
- Support of 16 Firebird and Interbase versions, including Firebird 2.5 and Interbase 2009;
- Automatic configuring for database server;
- Ability to work on 64-bit platforms;
Combination of these two drivers will give our clients another competitive advantage for quick development of quality Firebird and Interbase applications.
Source: Firebird driver press release
« Hide it
New IBProvider v.126.96.36.19900 RC3
- All the detected problems that prevented comprehensive work with Firebird and Interbase from UNICODE applications have been eliminated.
- Supports charset markers in SQL queries.
- Supports exclusions processing when working with Interbase and Firebird via ADODB.
- Supports working with database object names containing national symbols for connections with NONE charset.
- Enhanced work with metadata schemes when working with database via NONE charset.
- Advanced testing allowed detection and elimination of errors.
- ISO8859_15 charset support.
Please read details on the Firebird driver homepage.