Sql Server 2008 x64 ODBC Linked Server to Oracle Not Working
If I try to right click on a view name and select Script -> SELECT To.... I get a message


The GUI is probably trying to access an Oracle Data Dictionary View (in order to read the column names &amp; data types) that it does not have permission to select from, hence the error message.

Ask the Vendors Oracle DBA to trace the ODBC session so that you can track down the exact cause.