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 ADO.NET Data Provider for OLE DB
The Firebird 2.1 Language Reference Update is now online at
The PDF failed to build with tons of errors. I’ve got no time
to investigate the problem now; leaving for France tomorrow
morning. If somebody else wants to have a shot at it, please
do. The CVS sources are up-to-date.
The initial version of kinterbasdb v3.3 was committed to subversion
(trunk). It’s basically v3.3 by David Rushby + fixes to v3.2 line we
made to make it work with FB 2.1. Source tarball and windows binaries
for fb 2.x & python 2.5/2.6 for testing should be available soon. Now
I’m working on documentation as this version introduces some important
new functionality (above all support for multiple transactions per
connection). I’ll also check the transliteration issue. If everything
would go smoothly, you can expect the final release before Christmas 😉
We are releasing Jaws 0.8.6 and here are the list of changes .Also here is the installation guide for ubuntu intrepid ibex and firebird 2.1
On Firebird Python mailing list there is an interesting thread about rewriting Firebird Python Driver
Here is Pavel response
Mario H. Cornejo wrote in his blog about creating domains in Firebird 2.1
- Support of the integrated Windows authentification (SSPI) for
- Support of the system auth using environment variables: ISC_USER and ISC_PASSWORD.
- Feature of enable/disable database triggers for separate connection is available.
- Support of long names and BOOLEAN type in Interbase 7.x and Interbase 2007 was added.
- Support of arrays was improved. Access to arrays via IBProvider now becomes more robust in comparison with other Firebird database access components.
Read details on the IBProvider site.
By philippe on Thursday 29 May 2008
Since I helped Mandriva to do their packages for Firebird, I jumped and with Michal, we made things happen
Users of Opensuse 10.0,10.1,10.3 and future 11.0 but also SLE 10 can now just use the server:database repository and get Firebird 2.0.4
As soon as the Firebird Project will publish Firebird 2.1.1, packages will be there too.
Here is the new guide for installing firebird 2.1 and flamerobin on the ubuntu hardy heron and can be used for other releases (gutsy/feisty/dapper/intrepid ibex)
Just a quick sample of integrated windows auth in Firebird 2.1