Qt5 C++ Connecting Qt Application To Mysql Database #28 

If anyone is using the code below in their mainwindow.cpp file: if (db.open()){ QMessageBox::information(this, "Connection", "Database connected"); } else{ // QMessageBox::information(this, "Not Connected", "Connection failed"); QSqlError err=db.lastError(); } Please also remember to add the last line of code below to your mainwindow.h file #include #include #include #include #include

Jnsc0

Hey Chris, did u solve your problem ? I am getting the same issue.

@@birambawo1976 Did you find a way to solve this problem ?

@@juliocesarcamargoamaro2307 you guys found a solution for that. I'ts also not working for me!

For anyone stuck with this issue, all you need to do is copying those dll to your build folder (which is relative to your projects folder) so let's say your project folder is located in .../Documents/My project/ then your build folder will be located in .../Documents/ Most of the time this build folder will have a name similar to the compiler your using so you can easily locate it. Just paste those dll in that build folder and it will work

yea but if you are using mysql u need to add the required dll and if you are using sqlite there is no need of dlls

Yes. I work with Delphi and MySql. I want to migrate to c++. In my machine I already have the MySql instaled. Maybe this is why it worked easily. Thanks.

Try to turn off the shadow build in project window.

you need to add the dll driver in the specific folder that is mentioned in the video

sudo apt-get install libqt5sql5-mysql

@@shibadityachakraborty4369 I just did that but unfortunately didn't work☹️

this is for qt5 C++, but for python you can use pyqt5 i have complete video on pyqt5

SAME ISSUE!

i have said this in the video you can check the video

@@ParwizForogh Thank you for replying. What I actually wanted to know is that in your video at 6:54, when you run your program, you receive an error that Database not connected due to 'QSqlDatabase: QMYSQL driver not loaded' and 'QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7'. then you copy the two dll files to fix it. But in my case I receive 'QSqlDatabase: QMYSQL driver not loaded' and 'QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7' and 'QSqlError("", "Driver not loaded", "Driver not loaded")'. I tried coping the two dll files, but it doesn't fix my error.

@@sadabwasi9874 me too,

QMYSQL isn't in this list of available drivers because "qsqlmysql.dll" isn't in this folder: C:\Qt\5.15.2\mingw81_32\plugins\sqldrivers

Try to turn off the shadow build in project window.

yea just change the localhost information

Change the localhost with what ? The ip server ?

@@ParwizForogh I did it and still not work

Nvm it worked, just install it in bin that has your compiler name, i followed the steps of a fella below in the comments

can you tell me that where you face to problem

@@ParwizForogh I copy those files and it still doesn't find drivers

@@ParwizForogh same problem occurred... how can i fix this?

u need to download the dlls and add me in the place that i have mentioned in the video, because that is required dlls

@@ParwizForogh well as I said, I did it but it still doesn't work...

Still not. Qt is nonsense.

welcome nice