SQL error code = -303

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
unisigns
Posts: 1
Joined: Wed 06 May 2020 11:33

SQL error code = -303

Post by unisigns » Wed 06 May 2020 14:21

Hello DevArt Team,

we purchased your „ODBC Driver for InterBase Desktop for Windows License“ to connect to a InterBase DB over PHP.

The driver worked very well off the start, and we were able to access the database and write into it. However, we found that we can’t write into any fields that have a BLOB data type, as we receive the following error:

Warning: odbc_execute(): SQL error: [Devart][ODBC][InterBase]Dynamic SQL Error
SQL error code = -303
feature is not supported
BLOB and array data types are not supported for move operation, SQL state S1000 in SQLExecute in C:\xampp\htdocs\action\updateBlob.php on line 12

Is this not supported by the driver, as it tells in the error message, or is there any other way to update a BLOB field in the database?

Kind regards,

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: SQL error code = -303

Post by oleg0k » Mon 18 May 2020 09:21

Hello,
Thank you for the information. We've reproduced the issue and are currently working to resolve it. We'll keep you updated on the progress.

wbr, Oleg
Devart Team

Post Reply