iOS Question Struggling to create a correct connection string for my

[OlavRossland]

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?

 

[Erel]

You cannot (and shouldn't) directly connect to remote databases. Use jRDC2 as a middleware.