Re: [Firebird-odbc-devel] Transaction

[Helen B. <he...@ii...>]

>Gabriel Centenari wrote:
>> Hi,
>>
>> I'm new in firebird (Firebird-2.1.1.17910-0_Win32).
>> I'm trying to migrate from MsSql.
>> I'm promgraming in Clarion 6.3 and connecting to firebird via ODBC 
>> (Firebird_ODBC_1.2.0.69-Win32).
>>
>> In Mssql I open a Transaction sending: BEGIN TRAN
>>
>> Now I'm trying to open using: SET TRANSACTION
>> But the server response:
>>
>> invalid transaction handle (expecting explicit transaction start)
>>
>> What am I doing wrong?

At 02:09 AM 5/12/2008, Alexander Potapchenko wrote:

>   
>Please use Firebird support list.
>http://tech.groups.yahoo.com/group/firebird-support/
>Subscribe: fir...@ya...

No Alexander, I sent Gabriel here because this is an ODBC-specific question:  someone needs to tell him how the ODBC driver implements SET TRANSACTION (gets handle, initialises handle) so that he can use it in his program. The docs refer to "declaring" a transaction (which is not in SQL) but they don't say what you have to do.

>For Firebird 2.1 you need ODBC  Driver V2.0 
>(http://firebirdsql.org/index.php?op=files&id=odbc 
><http://firebirdsql.org/index.php?op=files&id=odbc>)

Thanks,
Helen