Here is my setup:
WI-V6.3.2.26539 Firebird 2.5
Firebird_ODBC_2.0.1.152_Win32
Alpha Five version 11 build 3353
FB Column Definition = BLOB SUB_TYPE 0
I can successfully see blob (JPG images) values that have been inserted into
the database.
However, if I attempt to insert a new image I get this Alpha Five error:
Server side error inserting row.
Internal Error - Invalid data index while putting long data.
Here are some of the details from the ODBC trace:
alpha5 201c-1f40 ENTER SQLPrepare
HSTMT 0x027738B8
UCHAR * 0x1E74B7C0 [ 81] "INSERT INTO EMPLOYEE_PICTURES
(EMP_PIC_ID, EMP_ID, EMP_PICTURE) VALUES (?, ?, ?)"
SDWORD 81
alpha5 201c-1f40 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
HSTMT 0x027738B8
UCHAR * 0x1E74B7C0 [ 81] "INSERT INTO EMPLOYEE_PICTURES
(EMP_PIC_ID, EMP_ID, EMP_PICTURE) VALUES (?, ?, ?)"
SDWORD 81
alpha5 201c-1f40 ENTER SQLBindParameter
HSTMT 0x027738B8
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 8 <SQL_C_DOUBLE>
SWORD 8 <SQL_DOUBLE>
SQLULEN 8
SWORD 0
PTR 0x1E753A20
SQLLEN 8
SQLLEN * 0x1E753A28
alpha5 201c-1f40 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x027738B8
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 8 <SQL_C_DOUBLE>
SWORD 8 <SQL_DOUBLE>
SQLULEN 8
SWORD 0
PTR 0x1E753A20
SQLLEN 8
SQLLEN * 0x1E753A28 (8)
alpha5 201c-1f40 ENTER SQLBindParameter
HSTMT 0x027738B8
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD 8 <SQL_C_DOUBLE>
SWORD 8 <SQL_DOUBLE>
SQLULEN 8
SWORD 0
PTR 0x1E753A2C
SQLLEN 8
SQLLEN * 0x1E753A34
alpha5 201c-1f40 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x027738B8
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD 8 <SQL_C_DOUBLE>
SWORD 8 <SQL_DOUBLE>
SQLULEN 8
SWORD 0
PTR 0x1E753A2C
SQLLEN 8
SQLLEN * 0x1E753A34 (8)
alpha5 201c-1f40 ENTER SQLBindParameter
HSTMT 0x027738B8
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -2 <SQL_C_BINARY>
SWORD -4 <SQL_LONGVARBINARY>
SQLULEN 23588
SWORD 0
PTR 0x1E753A38
SQLLEN 47178
SQLLEN * 0x1E753A40
alpha5 201c-1f40 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x027738B8
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -2 <SQL_C_BINARY>
SWORD -4 <SQL_LONGVARBINARY>
SQLULEN 23588
SWORD 0
PTR 0x1E753A38
SQLLEN 47178
SQLLEN * 0x1E753A40 (-100)
alpha5 201c-1f40 ENTER SQLExecute
HSTMT 0x027738B8
alpha5 201c-1f40 EXIT SQLExecute with return code 99
(SQL_NEED_DATA)
HSTMT 0x027738B8
alpha5 201c-1f40 ENTER SQLParamData
HSTMT 0x027738B8
PTR * 0x00CD62DC
alpha5 201c-1f40 EXIT SQLParamData with return code 99
(SQL_NEED_DATA)
HSTMT 0x027738B8
PTR * 0x00CD62DC
alpha5 201c-1f40 ENTER SQLPutData
HSTMT 0x027738B8
PTR 0x1E7D52D0
SQLLEN 23587
Is this a problem with the ODBC driver?
Thanks, Bob
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
