I used sp_addlinkedserver to create a query, and used OPENQUERY to try and access it. When I run openquery I get an error that usually looks like this:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'Select * from Reports.V_Emp_all '. The OLE DB provider 'MSDASQL' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='MSDASQL', Query=Select * from Reports.V_Emp_all '].