| Trolltech Home | Qt-interest Home | Recent Threads | All Threads | Author | Date | |
| All threads index page 5 | |
<html><div style='background-color:'><DIV class=RTE>Hello all,</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>Whenever i try to write data to my database i get the following error:</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>Database:<BR>Using unsupported buffer type: -842150451 (parameter: 2)<BR></DIV> <DIV class=RTE>Driver:<BR>QMYSQL3: Unable to bind value</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>If anyone has any suggestions on how to deal with this i would be most willing to listen.</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>The connection is fine and i am seeing the data in my table view. I am just not able to edit the database from the view.</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>I have attached the code that generated the error.</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>Thanks in advance for your attention.</DIV> <DIV class=RTE> </DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMBENUS/2755??PS=47575"; target="_top">Check out all that glitters with the MSN Entertainment Guide to the Academy Awards® </a> </html>
Attachment:
Attachment:
code.zip
Description: Zip compressed data
Message 2 in thread
"keith burke" <jrkeith95@xxxxxxxxxxx> wrote in message
news:BAY124-F3849AC8DD1ECDA7BAD99ADA0A20@xxxxxxxxxx
> Database:
> Using unsupported buffer type: -842150451 (parameter: 2)
>
> Driver:
> QMYSQL3: Unable to bind value
Which version of MySql are you using?
I had this problem when I had a newer version
of MySql server than the one that the plugin
was built with. I just had to rebuild my
plugin with the newer version of MySql/bin
in the path.
--
[ signature omitted ]
Message 3 in thread
<html><div style='background-color:'><P><FONT size=3>First, thanks a lot for the response.</FONT></P>
<DIV>
<DIV>
<P class=RTE><FONT size=3>I am a little bit new at this, so please put up with me for a little while;</FONT></P>
<UL>
<LI>
<DIV class=RTE><FONT size=3>i am using mysql server 5.0 and MS visual studio .NET 2003 with the QT integration, where qt designer is basically a part of the IDE</FONT></DIV></LI></UL>
<P class=RTE><FONT size=3></FONT> </P>
<UL>
<LI class=RTE><FONT size=3>i looked in MS VS .NET ->tools -> options -> projects ->C++ directories and saw that D:\MySQL\bin was there. I also ensured the the include path and library path were present</FONT></LI></UL>
<P class=RTE><FONT size=3></FONT> </P>
<UL>
<LI class=RTE><FONT size=3>so when you say "the plug in", could you educate me as exactly what you mean, and just give me a brief heads up on how to include the path. </FONT></LI></UL>
<P class=RTE><FONT size=3>once again, thanks very much for your attention.</FONT></P>
<P class=RTE><FONT size=4></FONT> </P>
<P class=RTE><BR><BR></P>
<DIV></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px"><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif">
<HR color=#a0c6e5 SIZE=1>
<DIV></DIV>From: <I>"Duane Hebert" <spoo@xxxxxxxxxx></I><BR>To: <I>qt-interest@xxxxxxxxxxxxx</I><BR>Subject: <I>Re: database and driver error (qt 4.2)</I><BR>Date: <I>Fri, 26 Jan 2007 07:10:10 -0500</I><BR>>"keith burke" <jrkeith95@xxxxxxxxxxx> wrote in message<BR>>news:BAY124-F3849AC8DD1ECDA7BAD99ADA0A20@xxxxxxxxxx<BR>> > Database:<BR>> > Using unsupported buffer type: -842150451 (parameter: 2)<BR>> ><BR>> > Driver:<BR>> > QMYSQL3: Unable to bind value<BR>><BR>>Which version of MySql are you using?<BR>>I had this problem when I had a newer version<BR>>of MySql server than the one that the plugin<BR>>was built with. I just had to rebuild my<BR>>plugin with the newer version of MySql/bin<BR>>in the path.<BR>><BR>><BR>>--<BR>>To unsubscribe -
send a mail to qt-interest-request@xxxxxxxxxxxxx with "unsubscribe" in the subject or the body.<BR>>List archive and information: http://lists.trolltech.com/qt-interest/<BR>><BR></FONT></BLOCKQUOTE></DIV></DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMBENUS/2728??PS=47575"; target="_top">Valentine?s Day -- Shop for gifts that spell L-O-V-E at MSN Shopping</a> </html>
--
[ signature omitted ]
Message 4 in thread
"keith burke" <jrkeith95@xxxxxxxxxxx> wrote in message
news:BAY124-F38197CFB03B7DD77B42EF4A0A20@xxxxxxxxxx
> First, thanks a lot for the response.
>
> I am a little bit new at this, so please put up with me for a little
> while;
>
> a.. i am using mysql server 5.0 and MS visual studio .NET 2003 with the
> QT integration, where qt designer is basically a part of the IDE
>
>
> a.. i looked in MS VS .NET ->tools -> options -> projects ->C++
> directories and saw that D:\MySQL\bin was there. I also ensured the the
> include path and library path were present
>
>
> a.. so when you say "the plug in", could you educate me as exactly what
> you mean, and just give me a brief heads up on how to include the path.
> once again, thanks very much for your attention.
I guess that I should ask how you're using the SQL driver. One way is
to build them as plugins and distribute them with your app. To do this,
you need to compile the plugins for MySql. Is this what you're trying
to do or are you trying to load the libraries directly in some way?
--
[ signature omitted ]
Message 5 in thread
<html><div style='background-color:'><DIV class=RTE>
<P><FONT size=2>Hello Duane,</FONT></P>
<P><FONT size=2>I solved the problem from the first mail you sent me. From what you said, i googled until i found a site from trolltech:</FONT></P>
<P><A href="http://doc.trolltech.com/3.3/sql-driver.html";><FONT size=2>http://doc.trolltech.com/3.3/sql-driver.html</FONT></A></P>
<P><FONT size=2>I followed the instructions to build the mysql driver plugin using my mysql installation include and library files</FONT></P>
<P><FONT size=2>so at the command promt i had:</FONT></P>
<P><FONT size=2>cd %QTDIR%\plugins\src\sqldrivers\mysql<BR>qmake -o Makefile "INCLUDEPATH+=C:\MYSQL\INCLUDE" "LIBS+=C:\MYSQL\LIB\OPT\LIBMYSQL.LIB" mysql.pro</FONT></P>
<P><FONT size=2>then i ran</FONT></P>
<P><BR><FONT size=2>nmake</FONT></P>
<P><FONT size=2>i got an error saying: "could not open qsqlmysqld.dll" </FONT></P>
<P><FONT size=2>so i just added its directory to visual studio under Tools > Options > Projects > VC++ Directories > Executable Files</FONT></P>
<P><FONT size=2>and now i am writing to my database like crazy.</FONT></P>
<P><FONT size=2>Thanks again for the help man <IMG height=19 src="http://graphics.hotmail.com/i.p.emsmile.gif"; width=19>, and your time, it was invaluable.</FONT></P>
<P><FONT size=2><BR> </P></FONT></DIV>
<DIV></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px"><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif">
<HR color=#a0c6e5 SIZE=1>
<DIV></DIV>From: <I>"Duane Hebert" <spoo@xxxxxxxxxx></I><BR>To: <I>qt-interest@xxxxxxxxxxxxx</I><BR>Subject: <I>Re: database and driver error (qt 4.2)</I><BR>Date: <I>Fri, 26 Jan 2007 18:58:47 -0500</I><BR>>"keith burke" <jrkeith95@xxxxxxxxxxx> wrote in message<BR>>news:BAY124-F38197CFB03B7DD77B42EF4A0A20@xxxxxxxxxx<BR>> > First, thanks a lot for the response.<BR>> ><BR>> > I am a little bit new at this, so please put up with me for a little<BR>> > while;<BR>> ><BR>> > a.. i am using mysql server 5.0 and MS visual studio .NET 2003 with the<BR>> > QT integration, where qt designer is basically a part of the IDE<BR>> ><BR>> ><BR>> > a.. i looked in MS VS .NET ->tools -> options -> projects ->C++<BR>> > directories and saw that
D:\MySQL\bin was there. I also ensured the the<BR>> > include path and library path were present<BR>> ><BR>> ><BR>> > a.. so when you say "the plug in", could you educate me as exactly what<BR>> > you mean, and just give me a brief heads up on how to include the path.<BR>> > once again, thanks very much for your attention.<BR>><BR>>I guess that I should ask how you're using the SQL driver. One way is<BR>>to build them as plugins and distribute them with your app. To do this,<BR>>you need to compile the plugins for MySql. Is this what you're trying<BR>>to do or are you trying to load the libraries directly in some way?<BR>><BR>><BR>>--<BR>>To unsubscribe - send a mail to qt-interest-request@xxxxxxxxxxxxx with "unsubscribe" in the subject or the body.<BR>>List archive and
information: http://lists.trolltech.com/qt-interest/<BR>><BR></FONT></BLOCKQUOTE></div><br clear=all><hr> <a href="http://g.msn.com/8HMBENUS/2731??PS=47575"; target="_top">Turn searches into helpful donations. Make your search count.</a> </html>
--
[ signature omitted ]
Message 6 in thread
"keith burke" <jrkeith95@xxxxxxxxxxx> wrote in message news:BAY124-
> I solved the problem from the first mail you sent me. From what you said,
> i googled until i found a site from trolltech:
>
> http://doc.trolltech.com/3.3/sql-driver.html
>
> I followed the instructions to build the mysql driver plugin using my
> mysql installation include and library files
If you have Qt installed, you also have QtAssistant.
You can get to this link from there or just go to the docs menu and open
it. No need to google. Qt's help is pretty well done.
> i got an error saying: "could not open qsqlmysqld.dll"
> so i just added its directory to visual studio under Tools > Options >
> Projects > VC++ Directories > Executable Files
You can just add the path to this dll (probably c:/mysql/bin) to
your path. This way, the registry gets the right info for the
plugin as well.
> and now i am writing to my database like crazy.
>
> Thanks again for the help man , and your time, it was invaluable.
Glad to help.
--
[ signature omitted ]
![http://graphics.hotmail.com/i.p.emsmile.gif"](http://graphics.hotmail.com/i.p.emsmile.gif"){kind=link}