1C:Enterprise does not natively support accessing to Firebird database with External data source function, thus using “Other” category for this task.
But there is one problem – when using dynamic lists, 1C:Enterprise uses constructions like:
SELECT TOP 10 … FROM …
Firebird has another syntax:
SELECT FIRST 10 … FROM …
And as a result such queries does not work.
Attached ODBC driver is patched to replace “SELECT TOP” to “SELECT FIRST” to make 1C:Enterprise work correctly.
There are some other issues left through.
Download from here