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.