On 28.11.2010 5:34, webmail2010@... wrote:
> I am trying to use ODBC Driver 2.00.00.150 with Alpha Five v10 to
> access a Firebird 2.5 database.
> I get the following error when trying to save data to the server...
> Server side error updating row.
> Database API specific error
> Your database has returned the following error code and description to
> Alpha Five.
> Consult your database documentation for further information.
> -4 - '[ODBC Firebird Driver]Sqlda variable has zero length
> SQL State is: HY000'
> Refresh the data to see the current server values.
> Note that this same ODBC driver works perfectly with Access 2003.
> Is this a problem with the ODBC driver or Alpha Five?
> Thanks, Bob
Alpha Five generates SQL queryies such as:
"UPDATE COUNTRY SET CURRENCY = ? WHERE (COUNTRY = ?) AND (CURRENCY = ?
OR CURRENCY IS NULL AND *? IS NULL*)"
Firebird ODBC driver does not support such query now.
For resolving the problem you can change the following parameter in the
Active-Link table settings:
Base update statement on: *Primary key only*
You can use Custom update query too.
LASP technology, http://www.lasptech.ru
Get latest updates about Open Source Projects, Conferences and News.