Insert Long String into BLOB does not work [ODBC194]
firebird-automations opened this issue · 2 comments
Submitted by: ohenri (ohenri)
Some Centura Programs (Version 1.5.1 but also V4.2) did insert rows into a firebird database.
The table do have 6 BLOB fields of subtype 0.
By using ODBC driver version V2.00.149, that works fine.
Because of a server change, we decided to use the newest ODBC driver V203.154.
On this new driver (V203.154) the insert fails.
Failure related to ODBC versions
V200_148: works OK
V200_150: failure
V200_151: failure
V201_152: failure
V202_153: failure
V203_154: failure
It shows us (on clients side) following error
"116 Programming Error: Missing long bind before write long"
The SQL statemend is as follows (on a special table for this diagnostics)
insert into BUC_UPLDCNTRL
(UC_AB_NR, UC_UPLNUM, UC_UPLDTM, UC_PAKSEQ, MEMOB, MEMOT)
values
(:A_KOPF.AK_AB_NR, :mf_Uplnum, :UPLD._PkDtmDt, :mf_PkSeq, :mf_MEMOB, :mf_MEMOT)
where MEMB, MEMOT are BLOBS of subtype 0 and 1.
I also have some ODBC log files but cannot attache them here ....
Modified by: @alexpotapchenko
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Won't Fix [ 2 ]
Fix Version: 2.0.4 [ 10662 ]
Modified by: @alexpotapchenko
status: Resolved [ 5 ] => Closed [ 6 ]