Invalid connection when connecting to MySQL.
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I wrote my code as official guide of database toolbox as follows:
myconn=database('xxx','yy','zzz','com.mysql.jdbc.Driver','jdbc:mysql://121.41.144.24:11106/xxx')
sqlquery = "SELECT * FROM dw_IndexQuote";
data = select(myconn,sqlquery);
However, it report an error that Invalid connection.
the attribute of the connection is:
AutoCommit: ''
ReadOnly: ''
LoginTimeout: 0
MaxDatabaseConnections: -1
I don't know why. The information of connection is correct and I can use python to connect. I think there may be a mistake in configuration but I cannot figure it out.
0 commentaires
Réponses (1)
Shanmuganathan
le 22 Nov 2022
Hi Chen,
I understand that you are facing an issue when trying to connect to MySQL database.
Please follow the below documentation to setup the data source and connect to MySQL database:
Regards,
Shanmuganathan
0 commentaires
Voir également
Catégories
En savoir plus sur Database Toolbox dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!