Issue Details (XML | Word | Printable)

Key: ODBC-194
Type: Bug Bug
Status: Closed Closed
Resolution: Won't Fix
Priority: Major Major
Assignee: Alexander Potapchenko
Reporter: ohenri
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
ODBC Driver

Insert Long String into BLOB does not work

Created: 18/Nov/15 03:48 PM   Updated: 06/Mar/16 05:34 PM
Component/s: None
Affects Version/s: 2.0 RC2 , 2.0, 2.0.1, 2.0.2, 2.0.3
Fix Version/s: 2.0.4

Environment:
Client: Windows 7 X64 (but using 32Bit Program and 32Bit Driver)
Client: Windows 2008R2 X64 (but using 32Bit Program and 32Bit Driver)
Firebird Server 2.5.3.26780
Firebird Client 2.5.2.26539 (fbclient.dll)
ODBC Drivers V2.00.149 up to V203.154
Program: Centura V1.5.2 and also Centura V4.1


 Description  « Hide
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 ....

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.