Firebird 1.5 ODBC - Cannot obtain the schema rowset "DBSCHEMA_TABLES"
Posted: 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
However if I perform this, I get an error
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.
If I perform this, it works
Code: Select all
SELECT * FROM OPENQUERY(FIREBIRDDEVART, 'SELECT * FROM ROHSTOFF')
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.