Install the 64-bit ODBC drivers on the server, and use that to set up a DSN for your linked server. There are posts elsewhere in Sage City on the steps to get it set up.

Following is the connection string I used to setup a Linked Server using SQL 2014, and I was able to query the fields using SQL commands in SQL Server Management Studio. Of course, change the paths and company name info to your own setup. UID is a user that I setup in Library Master -> Users with the appropriate rights the user name, I setup the name "SilentConnection" - you can setup any name you want, PWD is the password you setup in User Maintenance in Library master. Notice that UID in the Connection String is all in uppercase (even though in Sage it isn't) GOOD LUCK!

Driver={MAS 90 4.0 ODBC Driver}; UID=SILENTCONNECTION; PWD=yourpasswordhere; Directory=\\SERVER2950\Program files\Sage\Sage 100 Advanced ERP\MAS90; Prefix=\\SERVER2950\Program files\Sage\Sage 100 Advanced ERP\MAS90\SY\, \\SERVER2950\Program files\Sage\Sage 100 Advanced ERP\MAS90\==\; ViewDLL=\\SERVER2950\Program files\Sage\Sage 100 Advanced ERP\MAS90\HOME; Company=FRE; LogFile=\PVXODBC.LOG; CacheSize=4; DirtyReads=1; BurstMode=1; StripTrailingSpaces=1; SERVER=NotTheServer