Archive for March, 2009

Upgrading Firebird from 1.5.x to 2.0.x on Linux

Monday, March 30th, 2009

I recently upgraded Firebird from 1.5.x to 2.0.5 on my Linux server.  Suddenly my UDF library stopped working.  Every time I tried to execute one of the UDFs I got the following error:

invalid request BLR at offset 90
function GRCIRCLE is not defined
module name or entrypoint could not be found

I had the shared library in the UDF directory, the UDFAccess parameter was set to Restrict UDF, the file permissions were correct.  It was driving me crazy.  I finally found out that my shared library has references to libfbembed.so.1 in it.  In Firebird 2.0.x that file is renamed to libfbembed.so.2.  Simply symbollically linking libfbembed.so.2 to libfbembed.so.1 solved the problem.

Populating a DataGridView From a Database Query

Wednesday, March 18th, 2009

Over the years I have made sporadic attempts the wrap my head around programming using the .Net class library.  I have used Delphi for over 10 years so maybe I am biased, but it seems as though many of the things that can be done with a couple of mouse clicks in Delphi require a lot more work to accomplish using .Net.  Populating a grid with data from an SQL query is a case in point.  In Delphi, you drop query, data source and grid components on your form, link the components together, set the query’s SQL property to return the data you want and the grid gets populated with the query’s data as if by magic. If only it were that easy using Visual Studio.

(more…)