Error connecting to remote mysql server using host name
Unsolved
General and Desktop
-
wrote on 25 Mar 2020, 09:50 last edited by Zetsil
I try to connect to a remote MySQL server :
db = QSqlDatabase::addDatabase("QMYSQL"); db.setHostName("BUCS276b\\I0001 ");//name of a remote desktop from my internal network db.setDatabaseName("Test_DB"); db.setUserName("usr"); db.setPassword("test");
But i get :
QSqlError("2005", "QMYSQL: Unable to connect", "Unknown MySQL server host 'BUCS276b\\I0001' (2)")Connexion FAILED. //Aditional info : Disponible Drivers ("QSQLITE", "QMYSQL", "QMYSQL3", "QODBC", "QODBC3", "QPSQL", "QPSQL7") Functional drivers(QMYSQL): true number of error: 2005 database error: "Unknown MySQL server host 'BUCS276b\\I0001' (2)" driver error: "QMYSQL: Unable to connect" type erreur: 1
The server is ok , it works if i connect from microsoft sql server manager with same host name .
-
@Zetsil said in Error connecting to remote mysql server using host name:
"BUCS276b\I0001 "
This is for sure no hostname...
-
wrote on 25 Mar 2020, 10:01 last edited by Zetsil
Is not, is the name of a remote desktop(host) from my internal network
-
@Zetsil said in Error connecting to remote mysql server using host name:
of a remote desktop(host)
So please specify the hostname or ip address.
1/4