I just installed PostgreSQL ver 8.1. I created an OLEDB connection and transaction. The Transaction BEGIN goes off fine. However when I try to commit it, I get the following error:
'PostgreSQL.1' failed with no error message available, result code: XACT_E_NOTSUPPORTED(0x8004D00F).
I tried all the possible Isolation Levels in the OLEDB.BeginTransaction.
Help will be appreciated.