Data type not supported issue.

EXEC master.dbo.sp_addlinkedserver @.server = N'DM', @.srvproduct=N'DM Association', @.provider=N'MSDMine', @.datasrc=N'ray620', @.catalog=N'DM Association'

select * from openquery (DM,'SELECT * FROM [Model Association TB].Content where NODE_TYPE = 8;')

Msg 7354, Level 16, State 1, Line 2

The OLE DB provider "MSDMine" for linked server "DM" supplied invalid metadata for column "NODE_DISTRIBUTION". The data type is not supported.

I'm getting an error with the metadata. Appreciate any assistance. Thank you in advance.

This is because the datatype for the NODE_DISTRIBUTION column is a Data Reader and not a simple data type. Try the following query:

select * from openquery (DM,'SELECT FLATTENED * FROM [Model Association TB].Content where NODE_TYPE = 8;')