Try this:

In the ODBC Data Source Administrator panel on the server, configure your linked server from System DSN.

Under the Performance tab, uncheck the box 'Enable pre-fetch of data for queries'. OK, OK.