I tried to set up a linked server via ODBC connection in SQLServer. It seem to connect but showed all the caches as empty names in SSMS. Also I couldnt get a select query to work.
Has anybody had any luck with doing this? If so.. How did you write the select statement?