Unable to insert into Blob from Alpha 5 v11

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Unable to insert into Blob from Alpha 5 v11

webmail2010
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel