I added Oracle database to my SQL using ODBC provider. I am able to see all Oracle tables available. When I try to SELECT any of the tables I get
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "PVD" reported an error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 1
Invalid use of schema or catalog for OLE DB provider "MSDASQL" for linked server "PVD". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.
However when I use MS Access (same ODBC) I have access to the tables.
What's wrong with my SQL Linked Server settings?