Connect to IP address on web hosting

[daviz]

Hi, I have an application done with AMS 8.5.
It connects to a SQLite3 database stored in the server of my client, in other words it runs locally.

Now my client requests that the database should be accessed from any Pc, not just locally.

I will make a test, moving the database to a web hosting provided by a friend for testing purposes.
But I cannot find a script or Action that allows my application to connect via IP address. I have been told I should give parameters "username" and "password" .

Any idea or suggestion is appreciated.

Thanks!

[Ulrich]

Instead of using SQLite3, you could rewrite the project to connect to MySQL, anything else via ODBC, using LuaSQL or plugins.

Ulrich

[daviz]

Hi Ulrich, thanks for the info.
I just checked the plugin "MySQL" and indeed there is an option to connect to a database by using IP address, username and password which is fantastic.
Just wondering, is there really no way to do that with SQLite3?
That would be a real shame.

[Bret]

Hello Daviz

When I made an application similar to yours, I made the remote connection as well.
For this, the location of the database had to be written in the codium line of the created application, in the overall function of the project.
Thus all equipment that had the application installed accessed the database.

[daviz]

Hi Bret thanks for replying. Couple of questions:

Hello Daviz

When I made an application similar to yours, I made the remote connection as well.

How did you accomplish it?

For this, the location of the database had to be written in the codium line of the created application, in the overall function of the project.

That is what I want to do, but there is no option for setting "password" and "user" for IP connection.

David R.