Skip to content

{ Category Archives } InterBase

Embedded User Authentication Error in InterBase 2007

This tells me that ALTER DATABASE ADD ADMIN OPTION does not work unless the ODS is the latest version available for the current server version. I wish the error message was better, but at least the problem is easy to fix.

InterBase Procedure Dependency-Checking Bug

InterBase seems to have a bug in checking dependencies when you alter the arguments to a procedure which is referenced by a trigger. It’s easy to work around, though.

Embarcadero

The Embarcadero deal seems, from my outsider’s point of view, to be a great deal for CodeGear and for Embarcadero. There are so many different ways that the two companies’ products can work together that it just makes a great deal of sense to me. It’s less clear to me how it makes sense […]

ADO.NET 2.0 Driver for InterBase

An ADO.NET 2.0 driver for InterBase is available for free download from the IB registered users page. Delphi users already have this; you only need it if you want to connect to IB from a .NET language other than Delphi and you don’t already own Delphi/RAD Studio.
Share This | Email this page to a friend

InterBase for Mac Now Supports Tiger, Leopard

The developer edition of InterBase for Mac have been updated to support Tiger and Leopard.
Share This | Email this page to a friend

Versioning DB Metadata Changes and Performance

Here’s yet another guy with more good ideas on how to version database metadata changes. Unfortunately, the ideal method of database metadata versioning remains to be discovered. The ideas discussed in K. Scott Allen’s series are good from a version control point of view, but they will have serious, negative performance implications in […]

Writing InterBase UDFs in Delphi

I wrote an article on creating InterBase User-Defined Functions in Delphi eons ago, and in it I suggest using the IBX declarations of the IB API calls when you need them. Since then, IBX has undergone internal changes to allow it to use some new features of IB, so the suggested syntax requires some revision. […]

Comparing InterBase and BlackfishSQL

Someone asked in the newsgroups for a comparison between InterBase and Blackfish SQL. So off the top of my head:

Feature
Blackfish SQL
InterBase

Connectivity
ADO.NET 2.0, JDBC, dbExpress
ADO.NET 1.1 and 2.0, JDBC (type 4), dbExpress, ODBC, native API, embedded SQL, OLE-DB via third parties

Data recovery features
Incremental backup with failover on Java platform only. Crash recovery via transaction log on […]

Optimizing UPDATE Statements

Recently, I was asked to look at a bug in our software where editing a certain record with a certain customers database took far too long — an update which should have taken less than a second took two hours to complete.

InterBase Makes Mac Debut

CodeGear’s new Ruby IDE, 3rd Rail, includes a version of InterBase for the Mac. Right now that’s the only way to get it, but expect to see it available separately "in the near future."
Share This | Email this page to a friend

Close