QSqlQuery::prepare: database not open
-
@SGaist When I go to the "remote mysql" part of the site, it gives an access host... do i gotta use this as the hostname ?
@RekTek249 If that's what i do, it gives that error:
QSqlError("1045", "QMYSQL: Unable to connect", "Access denied for user 'rektek_write'@'*ip here*.' (using password: YES)")If it's a permission problem, what do I need to do ? I have the insert one because that's the only thing I need to do...
-
Is this user authorised to access the database from outside that machine ?
-
That I don't know, you should ask them.
-
Then implement a REST service to expose what you need for your application.
What exactly are you trying to implement ? Because currently it seems you are trying to do server-side stuff from your application.
-
Then implement a REST service to expose what you need for your application.
What exactly are you trying to implement ? Because currently it seems you are trying to do server-side stuff from your application.
-
-
@RekTek249 Yes, you should implement a REST interface - exposing a SQL database to the public internet isn't a good idea.
-
To add to @the_, the tutorial explains thing nicely but there are more lightweight options than a full Java + eclipse + tomcat setup to get started.
Python wise there's the Django REST framework or Flask RESTful
PHP wise there's PHP Slim
There are also other options but you'd have to first share what you have available on your server.
