Delphi connects to sql online database

Question

This question may be very simple, but I really cannot find a real answer on the Internet. I already know that I can connect to the sqlite database stored on my computer with FireDac, but now I want to go to the sql online server.

I have a domain with an internal sql server.

This is my configuration and it tells me the Unknown configuration host . I need to connect to a SQL database. Is FireDAC a real solution?

---

I have a server side connection string like this:

 $pdo = new PDO('mysql:host=mysql.netsons.com;dbname=caorobwq_worldcup', 'username', 'password'); 

Answer 1

You can connect to such a server, but you should not open it in this way. Create another application layer that will use your database server as local storage. It is called three-tier architecture .