I am trying to select through an linked server from SQL Server 2012 to SQL Server 2000.
The linked server has been setup and I can browser the target database through the linked server which indicates that permissions are not a problem.
However, when I try to run a query, I get the following error (not my actual sql):
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT * FROM BOB" against OLE DB provider "SQLNCLI10" for linked server
Anyone have any ideas of what the problem is and how to solve it?