Heterogeneous queries error with a View
As I said in the question a lot of resources dealt with this issue but not when it pertained to a view. The solution I found was to 

1- create a 2nd DB on my source server. 
2- create a view on the 2nd db using the linked server to the remote DB
3- alter the view on the 1st DB to use the view on the 2nd DB
4- alter the 2nd DB to use ANSI WARNINGS ON at a DB level