I am connecting to a PostgreSQL 8.3 server using PostgreSQL ANSI Odbc driver.
My SQLConnection Params are something like the following:
After setting connected to true, TransactionsSupported returns False even if we know that PostgreSQL supports transactions.
I had to modify DbxOpenOdbc.pas. I replaced the following line:
Boolean(PropValue^) := fSupportsTransactionMetadata and fSupportsTransaction;
Boolean(PropValue^) := fSupportsTransactionMetadata or fSupportsTransaction;
I don't know if this is right but it worked for me. Now my transaction management and handling works fine.