QtService & QtSql

[RazZziel]

That's not exactly the problem here: our programs work flawlessly when executed as standalone applications. I use the default version of Qt, I've compiled the MySQL driver as that website says, and everything runs fine on a regular Qt4 application.

The problem is trying to run a QtService with the MySQL plugin, as the service won't find the plugin. A possible solution would be to recompile Qt4 with -qt-sql-driver, but that'd be really time consuming and I was looking for a quicker solution.

[bu7ch3r]

Do you deploy the service in Windows or in unix ?
If you manage to compile using -qt-sql-mysql please tell me how It seems that I cannot manage to compile using nmake...

[RazZziel]

I'm working on Windows right now, but with mingw, not with msvc. I once managed to compile with -qt-sql-mysql, but I was cross-compiling on Linux for QtEmbedded.

[RazZziel]

Hm, actually, it works like a charm in release, it only fails on debug, so there must be something fishy with my debug libraries...

[bu7ch3r]

Probably you already know that on debug it searches for qsqlmysql4.dll with d in the name: qsqlmysqld4.dll or something.

[RazZziel]

Indeed, but for some reason it won't find my sqldrivers/qsqlmysqld4.dll, go figure...

[AmiArt]

Try this, it works for me.


int main(int argc, char *argv[])
{
QString app_path = QFileInfo(QString::fromLocal8Bit(argv[0])).absolutePath();
QCoreApplication::addLibraryPath(app_path);

OpcService service(argc, argv);
return service.exec();
}


And copy qsqlmysql4.dll to "sqldrivers" subdirectory of your .exe file.