Firebird 1.5 ODBC - Cannot obtain the schema rowset "DBSCHEMA_TABLES"

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
ribena
Posts: 1
Joined: Wed 20 Jan 2021 17:56

Firebird 1.5 ODBC - Cannot obtain the schema rowset "DBSCHEMA_TABLES"

Post by ribena » Wed 20 Jan 2021 18:23

I'm using the DEVART Firebird ODBC driver with a System DSN called 'FIREBIRDDEVART' for a Firebird v1.5 database. In SQL Server Express 12.0 I have a linked db connection to the odbc connection called 'FIREBIRDDEVART'.

If I perform this, it works

Code: Select all

SELECT * FROM OPENQUERY(FIREBIRDDEVART, 'SELECT * FROM ROHSTOFF')
However if I perform this, I get an error

Code: Select all

select * from [FIREBIRDDEVART]...[ROHSTOFF]

OLE DB provider "MSDASQL" for linked server "FIREBIRDDEVART" returned message "Unspecified error".
OLE DB provider "MSDASQL" for linked server "FIREBIRDDEVART" returned message "[Devart][ODBC][Firebird]Dynamic SQL Error
SQL error code = -804
Function unknown
TRIM".
Msg 7311, Level 16, State 2, Line 25
Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDASQL" for linked server "FIREBIRDDEVART". The provider supports the interface, but returns a failure code when it is used.
I need to get this to work for a legacy application. I'm using the trial at the moment, but if I can get this to work, then the customer will need to buy multiple licences.

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: Firebird 1.5 ODBC - Cannot obtain the schema rowset "DBSCHEMA_TABLES"

Post by oleg0k » Thu 21 Jan 2021 20:57

Hello,
Thank you for the information. The issue investigation is in progress. We will inform you when we have any results.

wbr, Oleg
Devart Team

Post Reply