Building QT with "windeployqt": not connect to database (ODBC)

SGaist

This is for your application executable, you should check the database plugin.

AndreaCT

Mmh so I don't have to open my exe in dependency walker?
Sorry and thank you for your patience...

AndreaCT

C:\Qt\5.14.2\mingw73_32\plugins\sqldrivers\qsqlodbc.dll
I have to run dependency walker on it, right?

AndreaCT

Eventually, this is the output:

These are already present:

LIBGCC_S_DW2-1.DLL
LIBSTDC++-6.DLL
QT5CORE.DLL
QT5SQL.DLL

I downloaded the other 3 [https://www.dll-files.com/search.dll.html], and added these in the same folder.

SGaist

And the ODBC dll ?

AndreaCT

ODBC32.dll, no?

SGaist

Yes, did you check the dependencies of that one ?

AndreaCT

Download and put inside all the missing dll?

AndreaCT

Unfortunately the problem persists

hskoglund

Hi, just guessing, are you using 127.0.0.1 (or localhost) to connect to the database also on the new PC? Also, have you checked that you can reach the database with MySQL workbench?

AndreaCT

Yes to both

hskoglund

Ok. Is it same version of Windows 10 on both computers?

JSher

Is the ODCB connection created on 2nd computer? Also with mysql connector you need Visual C++2015 distro.

--James

AndreaCT

@hskoglund Yes

AndreaCT

@JSher No, I just tried to print the error on a label with db.lastError() and the output is: "[Microsoft][Driver Manager ODBC] Nome origine dati non trovato e driver predefinito non specificato. QODBC3: Unable to connect"

JSher

Sorry what I meant was did you configure the ODBC data source on the 2nd computer.

Like this:

https://stackoverflow.com/questions/25165525/how-to-connect-to-a-mysql-database-through-odbc-from-qt-application

--James

AndreaCT

No, this procedure is necessary for each device that must use the application?

JSher

Its connecting to an OBDC entry in windows by the looks of it. I do not use ODBC much but the way I understand it is you have to make the entry on each machine....Thats why I use the standard mysql connector, then you do not. I could be off:)

--James

AndreaCT

@JSher said in Building QT with "windeployqt": not connect to database (ODBC):

Its connecting to an OBDC entry in windows by the looks of it. I do not use ODBC much but the way I understand it is you have to make the entry on each machine....Thats why I use the standard mysql connector, then you do not. I could be off:)

Ok thank you very much!!! I evaluate the transition to the mysql connector