Why us?

Interbase – Firebird incompatibility

March 4, 2007

I just stumbled upon this issue and while the solution seems very simple, I almost pulled my hair before I could fix it.

The symptoms: I had Firebird (installed with Morfik) working perfectly, then installed a Borland/CodeGear app that set up Interbase (client), and after that Firebird stopped working (“XNET error (xnet:2323) XNET server initialization failed”). Any amount of un-installations and re-installations did not help. Googling around did not reveal any pointers either.

The resolution: I had to manually replace GDS32.DLL in Windows\System32 with a version form Firebird.

The reason: both DB servers use the same file (GDS32.DLL) for client connections, but of course, different versions. Although the Interbase version was much older (6.5?, dated 2004 something) than the Firebird version (2.0, dated end of 2006) the version number inside the version resource is higher (6.5.something v.s. 6.3.something), so Windows was keeping the Interbase version, and did not allow Firebird to replace it (typical DLL hell:-) — and of course Firebird could not cooperate with this DLL.

Suggestion: I would recommend to the parties (most probably this should fall on Firebird) to use different filenames (e.g. add “fb” to all file names) OR improve the error message printed OR have a FAQ item somewhere on the Net explaining what to do (like this one :-). Of course, interoperabilitiy issues may arise (running Interbase and Firebird on the same system, using the same ports, etc.)…

New Code Gear announcements: Delphi 2007 for Win32 and Delphi for PHP

February 22, 2007

Code Gear just announced two new products: Delphi 2007 for Win32 and Delphi for PHP.

A quick rundown on each:

  • Delphi 2007 for Win32 is the latest release of good old Delphi with improved Vista and AJAX support (in the form of VCL for AJAX).
  • Delphi for PHP is a RAD IDE and component set for PHP developers. This may be a BIG hit: it packs a powerful IDE with an architecture/component framework called VCL for PHP and adds on top of that professional debugging support and deployment wizardry. I will definitely have more first-hand news about this baby in the coming weeks.

It should be noted that Delphi for PHP is not strictly a CodeGear/Borland internal project, it is originated from qadram’s qstudio, but now it is developed together by the two companies. VCL for PHP used to be called WCL and as far as I see will remain open source.

You can read more here (a very good blog, BTW).

If you seem a little bewildered by all the Delphi for Xxxx (e.g. Delphi for PHP has nothing to do with Object Pascal) and VCL for Yyyy tags, don’t feel lost! It is just POBC (plain old brand capitalization) .

While I am at it PasWiki seems to be interesting, too: it is a simple Wiki engine written in “Modern Pascal”. The angle I am keen to learn more about is its performance claims, an important subject and an area where Morfik should shine.