All,

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.

Thanks in advance for the help.