Return with error on lock conflict (Interbase) using IBPhoenix ODBC
Connection string
This IBPhoenix Open Source ODBC Driver (aka Firebird ODBC driver) connection string can be used for connections to Interbase.
DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.gdb;NOWAIT=YES;
Normally the transaction will wait if it encounters a lock conflict. This connection string will cause an error instead.