title: Error connecting PostgreSQL 9.5 (odbc) as Linked Server to SQL Server 2012
body: <p>I'm getting an error by connecting a PostgreSQL Database as an Linkd Server on my SQL Server 2012.</p>
  
  <p>First I tried a local connection out of MS Access which worked fine. So I tried to do the same on my SQL Server 2012.</p>
  
  <p>I set up the ODBCx64 Driver from <a href="http://www.postgresql.org/ftp/odbc/versions/" rel="nofollow">PostgreSQL ODBC Driver Repo</a> and the connection test was succesfull <a href="http://imgur.com/6dXiwia" rel="nofollow">http://imgur.com/6dXiwia</a></p>
  
  <p>But if I want to add it as a linked server in my SQL Server Mgmt Studio it fails to connect <a href="http://imgur.com/13wihSh" rel="nofollow">http://imgur.com/13wihSh</a></p>
  
  <p>Any tips why it won't connect without errors?</p>
  
  <p>I'm using:</p>
  
  <ul>
  <li>PostgreSQL 9.5</li>
  <li>SQL Server 2012</li>
  <li>Windows Server 2012</li>
  <li>ODBC_X64_Unicode for Postgres</li>
  </ul>