[Qt-interest] could not able to open mysqlsql database

[Yuvaraj R]

Mikhail

I got the reason

it showing unknown database..  I corrected my self..

If i use my application Mysql not installed systems means what shall i have
to ?


Thanks

Yuvaraj R

On Thu, Oct 1, 2009 at 12:44 AM, Yuvaraj R <yuvaraj at ongobiz.com> wrote:

> Ok
>
> I agree with you.
>
> Even i can able to see the QMYSQL3,QMYSQL in drivers list.. but still i
> could not able to connect with database ..
>
> whats wrong with me ?
>
> Thanks
>
> Yuvaraj R
>
>
> On Thu, Oct 1, 2009 at 12:40 AM, Mikhail Veygman <mveygman at gmail.com>wrote:
>
>> Not sure you need it in your .pro file.
>>
>> What linker is telling you is that it can't find library libqmysql to
>> link against, which makes sense since the plugin is dynamically loaded.
>>
>> But then again Windows is a strange beast to me.
>> -
>> Regards,
>>
>> Mikhail Veygman
>>
>>
>> -----Original Message-----
>> From: Yuvaraj R <yuvaraj at ongobiz.com>
>> To: Mikhail Veygman <mveygman at gmail.com>
>> Cc: qt-interest <qt-interest at trolltech.com>
>> Subject: Re: [Qt-interest] could not able to open mysqlsql database
>> Date: Thu, 1 Oct 2009 00:31:33 +0530
>>
>> Sorry
>>
>> English is  not my first language.. I didn't get u properly...
>>
>> But database is valid only..
>> qDebug() << db.isValid();  //result true;
>>
>> Some has replied posted like this
>>
>> Q_IMPORT_PLUGIN(qsqlmysql)
>>
>> and in your .pro file:
>>
>> QTPLUGIN += qmysql .. is it correct.. i tried with one also
>>
>> But i am getting error:c:\Qt\2009.01\mingw\bin\..\lib\gcc\mingw32\3.4.5
>> \..\..\..\..\mingw32\bin\ld.exe: cannot find -lqmysql
>>
>>
>> Please help me
>>
>> Thanks
>>
>> Yuvaraj R
>>
>> On Thu, Oct 1, 2009 at 12:17 AM, Mikhail Veygman <mveygman at gmail.com>
>> wrote:
>>        Ok.
>>
>>        Can you provide:
>>
>>        db.isValid().  Also
>>
>>        output of mysql -h localhost -u root -proot
>>        -
>>        Regards,
>>
>>        Mikhail Veygman
>>
>>
>>        -----Original Message-----
>>        From: Yuvaraj R <yuvaraj at ongobiz.com>
>>
>>
>>        To: Mikhail Veygman <mveygman at gmail.com>
>>        Cc: qt-interest <qt-interest at trolltech.com>
>>        Subject: Re: [Qt-interest] could not able to open mysqlsql
>>        database
>>        Date: Thu, 1 Oct 2009 00:04:38 +0530
>>
>>        Thanks for your reply
>>
>>        Nothing i got from.
>>
>>        qDebug() << db.lastError.text();
>>
>>
>>        Thanks
>>
>>        Yuvaraj R
>>
>>
>>
>>
>>
>>        On Wed, Sep 30, 2009 at 11:58 PM, Mikhail Veygman
>>        <mveygman at gmail.com>
>>        wrote:
>>               Instead of the default SQLITE message.
>>
>>               Get:
>>               db.lastError().text()
>>
>>               That may clear up some things.
>>
>>               -
>>               Regards,
>>
>>               Mikhail Veygman
>>
>>
>>
>>               -----Original Message-----
>>               From: Yuvaraj R <yuvaraj at ongobiz.com>
>>               To: qt-interest <qt-interest at trolltech.com>
>>               Subject: [Qt-interest] could not able to open mysqlsql
>>        database
>>               Date: Wed, 30 Sep 2009 23:34:14 +0530
>>
>>               Hi All
>>
>>               I could not able to open  mysql  database..
>>
>>               please help me
>>
>>               my connection code is :
>>
>>               QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
>>
>>               db.setDatabaseName("Addu");
>>
>>               db.setHostName("localhost");
>>
>>               db.setUserName("root");
>>
>>               db.setPassword("root");
>>
>>               db.setPort(3306);
>>
>>               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 since last two days ..
>>
>>
>>               Thanks
>>
>>
>>               Yuvaraj R
>>
>>
>>
>>
>>               _______________________________________________
>>               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/20091001/5e8cc546/attachment.html