Problem
A linked server with the Attunity Connect OLEDB provider under SQL Server 2005 produces the following error message:

Msg 7372, Level 16, State 4, Line 1
Cannot get properties from OLE DB provider "AttunityConnect" for linked server "ATT".
when trying the following query:

select * from ATT.NAVDEMO..nation;
Solution
  1. Enter the Microsoft SQL Server Management Studio
  2. Navigate to 'Server Objects' -> 'Linked Servers' -> 'Providers'
  3. On the 'Attunity Connect' provider, right-click and select 'Properties'
  4. Under the 'General' tab make sure that the 'Allow inprocess' checkbox is selected.