Hello all,
I am developing an application using SOCI ODBC. I have images stored as
BLOB on a MySql database and I keep getting the same error:
Error: Into element used with non-supported type.
As I have read in the documentation (after developing for more than a week
¬¬) "Not all ODBC drivers support bulk operations". In the table of tested
backends it indicates that bulk read and bulk insert are not supported on
MySql 4.1, I am using MySQL ODBC 5.1 Driver, so I can guess that's the
problem.
Does anyone know any patch I can apply or any other way to do it with SOCI
ODBC?? I am using now MySQL but I would like it to be used by any database
using an ODBC driver.
============CODE=============
soci::blob img= soci::blob(this->sql);
int dataSize = -1;
sql << "Select img, size from MyDB.ImageGallery where ID = :id" ,into(img),
into(dataSize), use(id);
==========END CODE===========
Thank you very much in advance.
Regards,
PS: Congratulations to all SOCI ODBC!! The library and the manual is
awesome!! :)
--
Álvaro Queipo de Llano Escribano
(+34) 687 447 494
http://www.molinodezuacorta.es
------------------------------------------------------------------------------
Systems Optimization Self Assessment
Improve efficiency and utilization of IT resources. Drive out cost and
improve service delivery. Take 5 minutes to use this Systems Optimization
Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
