When I use Openquery, I get a similar but different error:

Msg 7357, Level 16, State 2, Line 1

Cannot process the object "SELECT TERM

FROM [OraStud]..[StudOwner].[STUDENT_DIRECTORY_INFO]

WHERE studid = '9170'". The OLE DB provider "MSDASQL" for linked server "OraStud" indicates that either the object has no columns or the current user does not have permissions on that object.

The user specified in the ODBC DSN has connect privileges (obviously) as well as select privileges on the STUDENT_DIRECTORY_INFO view.