The OLE DB provider "MSDASQL" for linked server "(null)" reported an error
I had same issue once, You may need to recreate the linked server with this set to false (or just change it in the linked server properties->server options): 

EXEC master.dbo.sp_serveroption @server=N'servername', 
    @optname=N'remote proc transaction promotion', @optvalue=N'false'


Additionally, try using OPENQUERY to run this against the link

syntax: 

OPENQUERY ( linked_server ,'query' )  


and example SQL: 

SELECT * FROM OPENQUERY(server_name,'SELECT * FROM table_name');