[Qt-interest] loading sql plug in
Yuvaraj R
yuvaraj at ongobiz.com
Wed Sep 30 14:08:01 CEST 2009
Thanks
I got it ..
if with out installing mysql, can't we use the mysql sql database in another
systems ?.
How do i open my Sql database..
I traced available databases .. there sql database is available..but i could
not able to open it..
Even i tried with sql browser project .. there also i could not able to open
it
Please help me
Thanks
Yuvaraj R
On Wed, Sep 30, 2009 at 5:00 PM, John McClurkin <jwm at nei.nih.gov> wrote:
> Yuvaraj R wrote:
> > Thanks for your reply
> >
> > Already i have downloaded the Mysql and MIngw
> >
> > and i created the libmysql.a with help mingw..
> >
> > I added libmysql.dll in Qt bin folder...
> > If you wish to deploy your program to another computer where these
> > libraries are not installed, you need to place them in the following
> paths:
> > /<APPDIR>\libmysql.dll/
> > /<APPDIR>\sqldrivers\qsqlmysql.dll
> >
> >
> > I want to use my program another computer..That's why i added.. What is
> > the problem here.. Even i could not able to open mysql ..
>
> <APPDIR> is the directory into which you install your application, both
> on your machine and on other machines, not the Qt directory. Also, you
> will need to install MySQL on any machines on which you want to run your
> application.
>
> >
> >
> > Please Help me
> >
> >
> > Thanks
> >
> > Yuvaraj R
> > /
> >
> >
> > On Wed, Sep 30, 2009 at 11:44 AM, Robert Escott
> > <robert at binarylogic.co.za <mailto:robert at binarylogic.co.za>> wrote:
> >
> > Hi Yuvaraj
> >
> > You didn't read the instructions properly.
> >
> > Firstly, the library path for MySQL is not part of Qt, it's the
> > location where you put the SDK that you downloaded from MySQL
> > itself. It will probably be something like
> >
> > c:\MySQL\MySQL Server 5.0.1\lib\opt
> >
> > Secondly, nowhere did I say you must add the MySQL dll OR the plugin
> > dll to the project file. You must not. They get loaded automatically
> > when you run your program.
> >
> > Robert
> >
> > ----- Original Message -----
> > *From:* Yuvaraj R <mailto:yuvaraj at ongobiz.com>
> > *To:* Robert Escott <mailto:robert at binarylogic.co.za>
> > *Cc:* qt-interest at trolltech.com <mailto:
> qt-interest at trolltech.com>
> > *Sent:* Wednesday, September 30, 2009 7:30 AM
> > *Subject:* Re: [Qt-interest] loading sql plug in
> >
> > Thanks Robert
> >
> > I have done as per you..
> >
> > My .pro file
> >
> > LIBS += -L../pjproject-1.0.2/pjlib/lib \
> >
> > -L.../pjproject-1.0.2/pjlib-util/lib \
> >
> > -L.../pjproject-1.0.2/pjnath/lib \
> >
> > -L.../pjproject-1.0.2/pjmedia/lib \
> >
> > -L.../pjproject-1.0.2/pjsip/lib \
> >
> > -L.../pjproject-1.0.2/third_party/lib \
> >
> > -L.../database
> >
> > LIBS+=C:/Qt/2009.01/bin/lib/opt -llibmysql
> >
> > LIBS+=C:/Qt/2009.01/qt/plugins/sqldrivers -llqsqlmysql
> >
> >
> > But i am getting
> >
> > :/Qt/2009.01/bin/lib/opt: No such file: Permission denied
> >
> > collect2: ld returned 1 exit status
> >
> >
> > and i could not able to open my sql database
> >
> >
> > main.cpp
> > #include <QSqlDatabase>
> >
> > #include <QVector>
> >
> > #include <QStringList>
> >
> > #include <QSqlDatabase>
> >
> > int main(int argc, char *argv[])
> >
> > {
> >
> > QApplication a(argc, argv);
> >
> > QStringList list = QSqlDatabase::drivers();
> >
> > for(int i=0;i<list.size();i++)
> >
> > {
> >
> > qDebug() << list.at <http://list.at>(i);
> >
> > }
> >
> > if(!createConnection())
> >
> > {
> >
> > return 1;
> >
> > }
> >
> > login w;
> >
> > w.show();
> >
> > return a.exec();
> >
> > }
> >
> > connection.h
> >
> > #include <QSqlDatabase>
> >
> > #include <QSqlError>
> >
> > #include <QSqlQuery>
> >
> > static bool createConnection()
> >
> > {
> >
> > QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
> >
> > db.setDatabaseName("Addu");
> >
> > db.setHostName("localhost");
> >
> > db.setUserName("root");
> >
> > db.setPassword("root");
> >
> > if (!db.open()) {
> >
> > QMessageBox::critical(0, qApp->tr("Cannot open database"),
> >
> > qApp->tr("Unable to establish a database connection.\n"
> >
> > "This example needs SQLite support. Please read "
> >
> > "the Qt SQL driver documentation for information how "
> >
> > "to build it.\n\n"
> >
> > "Click Cancel to exit."), QMessageBox::Cancel);
> >
> > return false;
> >
> > }
> >
> > return true;
> >
> > }
> >
> >
> >
> > Please help me
> >
> > I am struggling with 2 days .. I want to use database in other
> > systems also
> >
> >
> > Thanks
> >
> > Yuvaraj R
> >
> > On Tue, Sep 29, 2009 at 11:48 PM, Robert Escott
> > <robert at binarylogic.co.za <mailto:robert at binarylogic.co.za>>
> wrote:
> >
> > I don't understand why you're creating macros inside your
> > project.
> >
> > I had problems initially when I wanted to use MySQL as well.
> > There are a few things you should do before you can
> > successfully connect to the database:
> >
> > 1) Qt doesn't come with the plugin already made, it only has
> > the wrapper code needed to create the plugin. The project
> > for this is found in </QTDIR>\src\plugins\sqldrivers\mysql./
> > The instructions for creating the plugin can be read
> > at
> http://doc.trolltech.com/4.5/sql-driver.html#how-to-build-the-qmysql-plugin-on-windows
> > and will result in a file called /qsqlmysql.dll/ being
> > created and placed in </QTDIR>\plugins\sqldrivers/.
> >
> > 2) The plugin itself is only an adapter between the QtSql
> > module and the actual MySQL library. To use the plugin, you
> > need to copy the MySQL library to your /<QTDIR>\bin/
> > directory. The file you're looking for is /libmysql.dll/ and
> > can be found in your </MYSQL>\lib\opt/ directory.
> >
> > 3) If you wish to deploy your program to another computer
> > where these libraries are not installed, you need to place
> > them in the following paths:
> > /<APPDIR>\libmysql.dll/
> > /<APPDIR>\sqldrivers\qsqlmysql.dll/
> >
> > Once you've done the above, you don't even have to think
> > about loading and unloading the plugin from your code, you
> > just go right ahead.
> >
> > /#include <QSqlDatabase>/
> > //
> > /int main(int argc, char **argv){/
> > //
> > / QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");/
> > / db.setDatabaseName("Addu");/
> > / db.setHoseName("localhost");/
> > / db.setPort(-1);/
> > / db.setUserName("root");/
> > / db.setPassword("");/
> > / if (!db.open())/
> > / return -1;/
> > //
> > / return 0;/
> > /}/
> >
> > That's all. You don't even have to think about the plugin in
> > your code.
> >
> > I hope this solves your problem.
> >
> > Robert
> >
> > ----- Original Message -----
> > *From:* Yuvaraj R <mailto:yuvaraj at ongobiz.com>
> > *To:* qt-interest at trolltech.com
> > <mailto:qt-interest at trolltech.com>
> > *Cc:* Thiago Macieira <mailto:thiago.macieira at trolltech.com>
> > *Sent:* Tuesday, September 29, 2009 1:27 PM
> > *Subject:* Re: [Qt-interest] loading sql plug in
> >
> > I resolved the my previous error...
> >
> > Now i am facing new error,
> >
> > error is
> >
> >
> >
> >
> > qt_plugin_instance_qsqlmysql()
> >
> > what's is there previous mentioned code
> >
> > please help me
> >
> >
> > Thanks
> >
> > Yuvaraj R
> > On Tue, Sep 29, 2009 at 1:22 PM, Yuvaraj R
> > <yuvaraj at ongobiz.com <mailto:yuvaraj at ongobiz.com>> wrote:
> >
> > Hi All place the Sql folder outside of project..It
> > contains following files
> >
> > 1) qsqlmysql
> >
> > 2)libqsqlmysql4.a
> >
> > My .pro file is
> >
> > TARGET = MaxxTel
> >
> > TEMPLATE = app
> >
> > QT += core \
> >
> > gui \
> >
> > xml \
> >
> > network
> >
> > QT += sql
> >
> > QTPLUGIN += qsqlmysql
> >
> > SOURCES += main.cpp \
> >
> > mainwindow.cpp \
> >
> > widget1.cpp \
> >
> > pjcallback.cpp \
> >
> > buddy.cpp \
> >
> > form.cpp \
> >
> > setting_form.cpp \
> >
> > treewidget_override.cpp \
> >
> > registration_form.cpp \
> >
> > conference.cpp \
> >
> > tab_widget.cpp \
> >
> > window_alert.cpp \
> >
> > text_edit1.cpp \
> >
> > style_sheet.cpp \
> >
> > line_edit.cpp \
> >
> > string_new.cpp \
> >
> > login.cpp \
> >
> > create_database.cpp \
> >
> > history_call.cpp
> >
> > HEADERS += mainwindow.h \
> >
> > widget1.h \
> >
> > pjcallback.h \
> >
> > buddy.h \
> >
> > form.h \
> >
> > setting_form.h \
> >
> > treewidget_override.h \
> >
> > registration_form.h \
> >
> > conference.h \
> >
> > tab_widget.h \
> >
> > window_alert.h \
> >
> > text_edit1.h \
> >
> > style_sheet.h \
> >
> > line_edit.h \
> >
> > string_new.h \
> >
> > login.h \
> >
> > create_database.h \
> >
> > ../connection.h \
> >
> > history_call.h
> >
> > FORMS += mainwindow.ui \
> >
> > widget1.ui \
> >
> > form.ui \
> >
> > setting_form.ui \
> >
> > registration_form.ui \
> >
> > window_alert.ui \
> >
> > login.ui \
> >
> > conference.ui
> >
> > INCLUDEPATH += ../pjproject-1.0.2/pjlib/include \
> >
> > ../pjproject-1.0.2/pjlib-util/include \
> >
> > ../pjproject-1.0.2/pjnath/include \
> >
> > ../pjproject-1.0.2/pjmedia/include \
> >
> > ../pjproject-1.0.2/pjsip/include
> >
> > LIBS += -L../pjproject-1.0.2/pjlib/lib \
> >
> > -L.../pjproject-1.0.2/pjlib-util/lib \
> >
> > -L.../pjproject-1.0.2/pjnath/lib \
> >
> > -L.../pjproject-1.0.2/pjmedia/lib \
> >
> > -L.../pjproject-1.0.2/pjsip/lib \
> >
> > -L.../pjproject-1.0.2/third_party/lib \
> >
> > -L.../Sql
> >
> > RESOURCES += image.qrc
> >
> > win32-g++:LIBS += -L../openssl-0.9.8g
> >
> > win32-g++:LIBS += -lpjsua-i686-pc-mingw32 \
> >
> > -lpjsip-ua-i686-pc-mingw32 \
> >
> > -lpjsip-simple-i686-pc-mingw32 \
> >
> > -lpjsip-i686-pc-mingw32 \
> >
> > -lpjmedia-codec-i686-pc-mingw32 \
> >
> > -lpjmedia-i686-pc-mingw32 \
> >
> > -lpjnath-i686-pc-mingw32 \
> >
> > -lpjlib-util-i686-pc-mingw32 \
> >
> > -lpj-i686-pc-mingw32 \
> >
> > -lportaudio-i686-pc-mingw32 \
> >
> > -lgsmcodec-i686-pc-mingw32 \
> >
> > -lilbccodec-i686-pc-mingw32 \
> >
> > -lspeex-i686-pc-mingw32 \
> >
> > -lresample-i686-pc-mingw32 \
> >
> > -lmilenage-i686-pc-mingw32 \
> >
> > -lsrtp-i686-pc-mingw32 \
> >
> > -lm \
> >
> > -lwinmm \
> >
> > -lole32 \
> >
> > -lws2_32 \
> >
> > -lwsock32 \
> >
> > -lqsqlmysql
> >
> >
> > when i am trying to build ,i am getting following error
> >
> >
> > cannot find -lqsqlmysql
> >
> >
> >
> > Please help me to load the mysql plug in to my project
> >
> >
> >
> > Thanks
> >
> >
> > Yuvaraj R
> >
> >
> >
> >
> >
> > On Tue, Sep 29, 2009 at 11:17 AM, Yuvaraj R
> > <yuvaraj at ongobiz.com <mailto:yuvaraj at ongobiz.com>>
> wrote:
> >
> > Thanks for your reply
> >
> > I realized my mistake..
> >
> > still i didn't load the plug in
> >
> > i place sql folder in my project and inserted the
> > created qsqlmysql.dll in folder..
> >
> > in pro file
> >
> > LIBS += -L../sql
> >
> > In my main function i used following macro
> >
> > Q_IMPORT_PLUGIN(qsqlmysql)
> >
> > but i am getting following error.
> >
> >
> >
> >
> >
> > error: undefined reference to
> `qt_plugin_instance_qsqlmysql()'
> >
> >
> > Thanks
> >
> > Yuvaraj R
> >
> >
> > Then i added in my pro file ..
> >
> > On Tue, Sep 29, 2009 at 11:07 AM, Christopher
> > Rasch-Olsen Raa <christopher at technophile.info
> > <mailto:christopher at technophile.info>> wrote:
> >
> > Hi,
> >
> > What does the plugin-system say? Does your
> > plugin get loaded? If so, what does
> > the errors you get when loading a database say?
> > Without this information is
> > _really_ hard for us to help.
> >
> > --
> > Christopher
> >
> > On Tuesday 29 September 2009 07:31:14 Yuvaraj R
> > wrote:
> > > Hi All
> > >
> > > I created the sql plug in .
> > >
> > > I tried with
> > >
> > >
> > > QSqlDatabase db =
> > QSqlDatabase::addDatabase("Mysql");
> > >
> > > db.setDatabaseName("Addu");
> > >
> > > but i am getting error..
> > >
> > > how do i use the plugin in my project and
> > upload to project.
> > >
> > > please help me
> > >
> > > can anybody provide me a useful links
> > >
> > > Thanks
> > >
> > > Yuvaraj R
> > >
> > _______________________________________________
> > Qt-interest mailing list
> > Qt-interest at trolltech.com
> > <mailto:Qt-interest at trolltech.com>
> >
> http://lists.trolltech.com/mailman/listinfo/qt-interest
> >
> >
> >
> >
> >
> > _______________________________________________
> > Qt-interest mailing list
> > Qt-interest at trolltech.com <mailto:Qt-interest at trolltech.com>
> > http://lists.trolltech.com/mailman/listinfo/qt-interest
> >
> >
> >
> > _______________________________________________
> > Qt-interest mailing list
> > Qt-interest at trolltech.com <mailto:Qt-interest at trolltech.com>
> > http://lists.trolltech.com/mailman/listinfo/qt-interest
> >
> >
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20090930/a6b874aa/attachment.html
More information about the Qt-interest-old
mailing list