[SOLVED] need for help... "Driver not loaded Driver not loaded"

tertel

Hi, we have a project that requires our program to be run via networks.
When I run the program in this laptop, it runs fine without errors. But when another computer tried to run the program, the resources are not visible (I'm using images as the GUI background) and whenever it tries to connect to the database from the server (this laptop), it creates a "Driver not found Driver not found" error.

I'm using Qt 4.7.4 with Qt Creator 2.4.1. The database I'm using is MySQL

I tried to search on how to solve this problem but to no avail?
Any help?

Thanks in advance! :D

Edit: please don't flag your question as "Urgent". That's your problem, not ours; Andre

inspired

for the sql:
in the directory where you have the .exe file create a folder named "sqldrivers" and in there put the "qsqlite.dll" (you should find it somewhere in your qt sdk folder.. - /bin/blah blah)

maybe putting the Qt5Sql.dll in the same folder as the .exe is needed.

for the images:
make a folder "imageformats" and in there put "qgif.dll"

(some other dlls are maybe needed, you'll figure it out :) )

all these are not needed in your computer cause these dlls are found in your system, but on other computers with no Qt installed they are missing.

tertel

[quote author="inspired" date="1363319481"]for the sql:
in the directory where you have the .exe file create a folder named "sqldrivers" and in there put the "qsqlite.dll" (you should find it somewhere in your qt sdk folder.. - /bin/blah blah)[/quote]

Okay, the Driver not Loaded error is now gone, but is replaced by this error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect

ChrisW67

bq. I’m using Qt 4.7.4 with Qt Creator 2.4.1. The database I’m using is MySQL

Inspired suggested placing the QSqlite plugin in the correct location, which is obviously not much use for MySQL.

bq. [ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect

You seem to have installed the ODBC plugin. This is not much use if the program is expecting the MySQL plugin. You can use MySQL through an ODBC driver for MySQL if you wish (ODBC driver is a separate install) or you can use the MySQL plugin. Which do you want?

koahnig

one note to the title of post. This might reflect completely your feelings and need. However, it is completely useless for others with the same problem.
Please edit the title of your post in order to reflect the topic.

tertel

[quote author="koahnig" date="1363345902"]one note to the title of post. This might reflect completely your feelings and need. However, it is completely useless for others with the same problem.
Please edit the title of your post in order to reflect the topic. [/quote]

Sorry about that.. My title WAS a bit needy.. XD
Thanks for the edit! :D

[quote author="ChrisW67" date="1363326261"]You seem to have installed the ODBC plugin. This is not much use if the program is expecting the MySQL plugin. You can use MySQL through an ODBC driver for MySQL if you wish (ODBC driver is a separate install) or you can use the MySQL plugin. Which do you want?[/quote]

I don't quite get the question.. :(

BTW, inspired's solution did it! The only thing missing is that I need to install the ODBC MySQL connector to each of the computers..

Thanks guys! :D
I marked it as SOLVED :)

andre

I'd recommend against using ODBC if there is a native driver available. If only because of speed repercussions.

tertel

I'm actually new to Qt and not aware of those things... yet... :)

How come I shouldn't use ODBC?

andre

Nothing to do with Qt, but more of a general thing. ODBC is basically a generic driver layer for database access. Quite an old one at that. It is yet another conversion to do on your database commands and your data, and it may cause problems as soon as you want to start using database specific things. The native Qt driver for MySql access the MySql database server directly.