MSSQL & PostgreSQL linked server integration

• liran

  SSC Rookie

  Points: 32

  More actions

  May 28, 2019 at 3:35 pm

  #3647899

  I'm stuck with somewhat of a strange integration issue between MSSQL & PostgreSQL.

  I have the latest versions of both SQL Server 2017 & PostgreSQL 10.8 - each running on their own machines.

  I was able install & configure ODBC between the servers, but I am able only to use Openquery with SELECT & INSERT  - but not UPDATE or DELETE.

  using the 4 name format (e.g. WORLD_SAMPLE.world.[public].city) also doesn't work ...

  Any suggestions would be most welcome 🙂 It's driving me nuts

• Site Owners

  SSC Guru

  Points: 80356

  More actions

  May 29, 2019 at 4:10 pm

  #3648309

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.