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

hskoglund · wrote on 5 May 2020, 20:45

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 · wrote on 5 May 2020, 21:07

Yes to both

hskoglund · 6 May 2020, 09:04

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

JSher · wrote on 6 May 2020, 01:08

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

--James

AndreaCT · wrote on 6 May 2020, 09:04

@hskoglund Yes

AndreaCT · wrote on 6 May 2020, 09:15

@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 · wrote on 6 May 2020, 10:03

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 · wrote on 6 May 2020, 11:49

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

JSher · wrote on 6 May 2020, 14:47

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 · wrote on 6 May 2020, 15:09

@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