At 07:35 AM 3/12/2008, Gabriel Centenari wrote:

>Hi,
>
>I'm new in firebird. I trying to migrate from MsSql.
>I'm promgraming in Clarion 6.3 and connecting to firebird via ODBC.
>
>In Mssql I open and Transaction sending: BEGIN TRAN
>
>Now I'm trying to open using: SET TRANSACTION
>But de server response:
>
>invalid transaction handle (expecting explicit transaction start)
>
>What amm I doing wrong?

Each different data interface layer or driver has its own way of starting a transaction. Some drivers have more than one way, according to the kind of transaction you want to start. I think SET TRANSACTION is a valid call for ODBC. In this case you seem to be trying to start a transaction that has not been properly initialised...but I am no expert on ODBC and its ways!

You need to take your question to the firebird-odbc-devel list and ask how it is to be done using the ODBC driver. Provide proper information about the ODBC driver version you are trying to use, the Firebird version (including client) and model (Classic/Superserver) and your connection setup.

The link for subscribing to the list is here:

http://firebirdsql.org/index.php?op=lists#fb-odbc-devel

^ heLen