Archive for 'Firebird Server'

Field news


FB4 and Visual Studio

I am verifying the new release of our ADO.NET provider for OLE DB and thinking that this picture will be useful for anyone, who is planning to start using the combination of FB4, .NET and IBProvider 🙂

Field news

The load tests of IBP v5.31.1 with FB4 has finished today. No real problems were detected. A few little issues with first dialect have been already fixed in version 5.31.5. During these tests Firebird ate the 116 days of my CPU time 🙂 It’s time to start testing IBP v5.31.5 and begin implementing the support […]

Alternative Text Literals

New IBProvider has added the support of UTF16 symbols for alternative text literals. It means that provider will be correctly processing the following query: select _win1251 q’?мама, мама, что я буду делать??’ from rdb$database; I hope that Firebird will be able to process this query in the near future. Note that, you should use […]

Getting NUMERIC and DECIMAL as text

The new build ( of IBProvider adds the new feature — getting the NUMERIC/DECIMAL values as text. It will help resolve the problems with reading these datatypes through linked server. For example, Firebird (and InterBase) allows to save value 1 into column with datatype NUMERIC(4,4). Yes, it is really possible: When you try to read […]


The following example demonstrates the support of DBTIMESTAMPOFFSET datatype for non-FB4 servers. This simple code connects to FB3 and asks IBProvider to translate ‘2023-08-09 21:53 Europe/Moscow’ string into binary presentation of TIMESTAMP WITH TIME ZONE datatype — DBTIMESTAMPOFFSET. Provider will do it with help ICU library.


Hello All. I think, the development of FB4 TIMESTAMP WITH TIME ZONE support has been arrived a final stage. Provider can process time zone regions itself and through ICU (v63.1). By default, this datatype will be mapped on the text (WSTR) but you can map it on MSSQL datatype DBTIMESTAMPOFFSET, too. For configuring a behavior […]


Hello one more time. As I have said early, MSSQL processes TIMESTAMP WITH TIME ZONE datatype using DBTIMESTAMPOFFSET structure OLE DB. Today I have checked it again. It is so really. By default IBProvider publishes TIMESTAMP WITH TIME ZONE as text but you can change this behavior using dbtimestamp_with_tz_rules property. That I did in this […]

Friday news

The load test of IBProvider v5.30 with FB4 lasted more than two weeks and ended today. No problems were detected. Firebird v4.0.3.2950 state. Ok. Let’s start the next tests.

FB4 and Connection Pool

Hello All. The new example was added at IBProvider website — «Resetting the session settings before reusing a connection (C#, FB4)». This examples demonstrates an implicit usage of the new magic FB4 feature — «ALTER SESSION RESET». It allows to implement the true connection pool at last. Both installers (IBProvider Trial and ADO.NET provider) were […]

« Older Entries