#34 TSQLConnection returns False for TransactionsSupported

open
nobody
None
5
2009-08-10
2009-08-10
kurisu810
No

I am connecting to a PostgreSQL 8.3 server using PostgreSQL ANSI Odbc driver.
My SQLConnection Params are something like the following:

database=DRIVER=PostgreSQL ANSI;PORT=5432;SERVER=xxx;DATABASE=xxx;
User_name=xxx
Password=xxx
Custom String=coEnableBCD=0;

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;

INTO:

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.

Discussion