Connection to MySQL

[giriuvce]

Hi, I am using Qt 4.7.2 in Simulator whic ll run in my W Vista. I ve been trying to connect to MySQL Server 5.1. Since i was getting "Driver not loaded" error i tried the steps in trolltech. I am getting both make and nmake command not found.
I am new to this programming. Please help me to connect to the database. Guide me from the first step. Any database if i am able to connect easily that is very helpful to me. Thank u.

[cincirin]

1. download mysql-connector-c-noinstall-6.0.2-win32 binary package from mysql downloads.
2. open %QTDIR%\src\plugins\sqldrivers\mysql\mysql.pro in QtCreator
3. add LIBS and INCLUDEPATH in mysql.pro to match with your mysql-connector-c-noinstall-6.0.2-win32 path
4. after mysql.pro is succesfully build, copy the qsqlmysqld4.dll in %QTDIR%\Desktop\...etc...\plugins\sqldrivers (there should already be qsqlite4.dll)
5. copy libmysql.dll in %QTDIR%\Desktop\...etc...\bin

that's all

[giriuvce]

Sorry to ask this sir. Where can i get qsqlmysqld4.dll. Other steps i did successfully. Thank u

[Lykurg]

You'll find qsqlmysqld4.dll where you run make at the 4th step. Look at the debug/release folder.

[SIFE]

%QTDIR%\src\plugins\sqldrivers\mysql\release

Production version, smaller then debug version.

%QTDIR%\src\plugins\sqldrivers\mysql\debug

Debug version.

[giriuvce]

[tmp/moc/release_shared/qsql_mysql.moc] error 1
I'm getting this error when i build. Really, I lost my hope to connect to mysql server. I tried many suggestions in different links. 1ce again i want to make u clear that i'm running Qt 4.7.2 Simulator. Thank u for reply.

[giriuvce]

The above error comes when i build using qtcreator.
I found the same error when i run in the command prompt in this link.
http://www.siteduzero.com/forum-83-6...bdd-mysql.html
I think they have solved this problem. But i didnt understand their language.

[falconium]

The above error comes when i build using qtcreator.
I found the same error when i run in the command prompt in this link.
http://www.siteduzero.com/forum-83-6...bdd-mysql.html
I think they have solved this problem. But i didnt understand their language.

He had problem with INCLUDEPATH parameter due to missing backslash after C:.
If you post your printout of error and the command you try to give, then we might know more to give you some solution.

[Gokulnathvc]

I am getting this error...error: 'my_ulonglong' does not name a type. While following the above steps.

[ChrisW67]

Then you almost certainly skipped step 3 or got the values wrong.

[Greeshma]

i'm getting an error when i build the .pro.
It says qsqlmysqld4.dll not found. What shud i do?

---

Added after 17 minutes:

i had given a wrong path. Now it says -llibmysql not found
I've been tryin a lot of stuff but cant build d plugin properly, wat do i have to do?

[deepal_de]

hi,

well this steps worked fine.

1. download mysql-connector-c-noinstall-6.0.2-win32 binary package from mysql downloads.
2. open %QTDIR%\src\plugins\sqldrivers\mysql\mysql.pro in QtCreator
3. add LIBS and INCLUDEPATH in mysql.pro to match with your mysql-connector-c-noinstall-6.0.2-win32 path
4. after mysql.pro is succesfully build, copy the qsqlmysqld4.dll in %QTDIR%\Desktop\...etc...\plugins\sqldrivers (there should already be qsqlite4.dll)
5. copy libmysql.dll in %QTDIR%\Desktop\...etc...\bin

but when i run my app its says "QSqlDatabase: QMYSQL driver not loaded"

[KillGabio]

i had to erase every wrong step i made to actually generate all the files...i had the same problem with the nmake...i m using minGW so instead of nmake i have to run mingw32-make and voila everything went ok...

http://www.qtcentre.org/threads/4696...ht=#post212132

maybe this helps...