Subject Re: Database Metadata error with JayBird
Author Roman Rokytskyy
Hi,

> I tried to access an existing database delivered with Interbase 6
> and got the following error when introspecting the columns:
> Dynamic SQL Error
> SQL error code = -206
> Column unknown
> F.RDB$FIELD_PRECISION
>
> Is that related to the Interbase database? Does Firebird handle the
> metadata tables differently?

This can happen. Check if there is column rdb$field_precision in table
rdb$fields. If no, you will need to build yourself a custom version of
JayBird where this field is not used.

> That's annoying as we have existing IB databases and want to move to
> FireBird.

Is there anything that prevents you from upgrading to Firebird? As far
as I know, IB 6.0 was never considered as stable, at least Firebird
1.0.2 has a lot of fixes after IB 6.0 was released.

Best regards,
Roman Rokytskyy