Unanswered: SQL Server/Postgresql linked server issue
I am trying to access a postgresql procedure from a sql server 2000 server via a MSSQL linked server connection and I am getting the following error:
" OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a].
Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction."
I installed the latest Postgresql ODBC drivers on the server and also verified that I can access the Postgresql system from ODBC.
Is there a way to resolve this issue or is there a better way to connect to Postgresql from SQL Server.