We duplicated the SQL 2017 problem with the DSN, no immediate fix but try this workaround.

Rather that use a DSN use a fully formatted Provider String when defining the Linked Server

Provider is
Microsoft OLEDB Provider for ODBC Drivers

Product Name is selected from list
AdagioDataSourceDriver

Data Source is not used

Provider string as follow adapted for your situation

DRIVER=AdagioDataSourceDriver;
USERID=SYS;
TABLESALL=FALSE;
RAWPASSWORD=1;
PASSWORD=SYS;
OPTIMIZE=LIVE;
NAMES=LONG;
DBSELELECTOR=SAM;
DBQ=D:\DataFolder SAM;
DBFILTER={AL92APIN};
DBDIRECTORY=D:\DataFolder;
COLUMNS=COMMON

The column names do not expand for the linked server.

Script Table as | Select To | New Query Editor Window will create a script but will need to be edited into the form

Select * from [LinkedServerName]...[TableName]

Using information that is correct for your Server & Table names