I have created a local test database for the iPhone with B4i. This works as it should.
Now I have created a test database at
https://db4free.net, but am struggling to create a correct connection string.
When I start the app, I get the error "Database file not found....".
Info from dn4free:
«The host name to access the server is db4free.net and the port is 3306.»
- Remote-Host: https://db4free.net (MySQL-database)
- Database: dbTest
- Table: tblTest
- Username: nameTest
- Password: passwordTest
For the local test database, I have used this connection string:
SQL.Initialize(xui.DefaultFolder, "dbTest.db", True) - and that works as it should.
BUT...
How should the connection string look for a connection to the MySQL-database at
https://db4free.net ??
Do I have to use a completely different method than with a local test database?
PS! https://db4free.net is only a test database.
Do you have any experiences with other providers of SQL databases that I can use for B4i apps?