Dozens of new options for Firebird and .NET Framework


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

IBProvider Team

Firebird driver

Tips : create/alter/drop user in firebird 2.5 , or howto get rid of gsec

On .net provider list Rick Roen is writing a utility to change user password , the best way to change it is from sql :).
Read the user create/delete/update notes.
Now a regular user can change it’s own password without the need for sysdba intervention:

The new DDL command ALTER USER enables an “ordinary” user (a regular Firebird user, a non-root user on POSIX or a trusted user on a Windows system where trusted authentication is enabled) the ability to change his or her password and/or personal name elements, while logged in to any database.

firebird #ruby driver is building cleanly and passing all tests under Ruby 1.8.7, 1.9.1 and 1.9.2

Brent Rowland wrote on twitter

Got fb building cleanly and passing all tests under Ruby 1.9.1. Now for 1.9.2.!/brentrowland/status/27211068760

Got fb building with Ruby 1.8.7, 1.9.1 and 1.9.2. At least on Mac. Under 10.6. Testing Linux and Windows will have to wait for another day.!/brentrowland/status/27220817754

Here is the git repository for Firebird Ruby driver , also you can check the
commits log

ps: he is working on Firebird 2.5 support if you wonder what is new in the driver 🙂

1 2 3