[Firebird-odbc-devel] Alpha Five v10 and ODBC Driver 2.00.00.150

[w***@rwtaylor.us]

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

[Alexander Potapchenko]

Post by w***@rwtaylor.us
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.

Regards,
Alexander