Mi Michael, we're using a 64-bit System DSN with a specific table listed, AP92AVMS. We're using the UNC path for the Data Directory rather than the drive letter.

Edit. we just updated the permissions on the entire network drive to give the account access to the whole thing, just in case there was a permissions issue. Still no change. For the Provider we're using "Microsoft OLE DB Provider for ODBC Drivers" - I'm assuming that's correct.

Edit. if I terminate SSMS and restart it I see the Adagio entry under the Linked Servers and it has a Catalogs folder underneath it but that's all I get. If I try to test the server or expand the Catalogs folder it hangs again. So it appears to getting part of the way through the process