I wrote:
> KJ wrote:
>> Hi all,
>>
>> it seems as if ODBC provider doesn't work correctly in conjunction with MSDTC.
>> Transaction are handled correctly using pgadmin or an ODBC based client (e.g. WinSQL).
>>
>> When running statements from MS SQL Server then in case of a rollback transaction a COMMIT is being forwarded to postgres (see log file below).
>>
>> Any help is welcome.
>
> Could you send me the Mylog output ?
Could you try first
begin distributed transaction
instead of
begin transaction
?
regards,
Hiroshi Inoue