submitAll() : database error

[locus]

thanks for the response

i did use that though, that is where i got the errors from.

what i am looking for is a way to get rid of it and write to my database.

thanks again

[locus]

Well ladies and gentleman, this is for all those who may come across this error in the future.

Just a recap:

eorror:
Database:
Using unsupported buffer type: -842150451 (parameter: 2)

Driver:
QMYSQL3: Unable to bind value

note the 3 in the driver name, yeeeessss , QMYSQL'3'.

The thing is the SQL Module in QT uses driver plugins in order to communicate with different database
APIs.

QT comes with some of those drivers already installed (QT4 came with QMYSQL3), and i was using MySQL 5.0, so basically I had a newer version
of MySQL server than the one that the driver plugin
was built with.

Solution:

Rebuild the plugin with the newer version MySQL library and include files in the path

How:

follow the qt instructions to build the mysql driver plugin using you mysql installation include files

cd %QTDIR%\plugins\src\sqldrivers\mysql
qmake -o Makefile "INCLUDEPATH+=C:\MYSQL\INCLUDE" "LIBS+=C:\MYSQL\LIB\OPT\LIBMYSQL.LIB" mysql.pro
nmake

If you get an error about could not open qsqlmysqld.dll, just add its directory/path to visual studio under Tools > Options > Projects > VC++ Directories > Executable Files

For linux folks, and for everyone actually

the instructions are found at:
http://doc.trolltech.com/3.3/sql-driver.html

well, chow for now.