CODEWITHSUNDEEP
mysqldelphifiremonkey
Raffaele Rossi
Raffaele Rossi

Reputation: 3127

Delphi connect to online sql database

This question may be very easy but I really cannot find a real answer online. I already know that I can connect to a sqlite database stored in my computer with FireDac but now I want to move on an online sql server.

I own a domain with a sql server inside.

enter image description here

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

I have this kind of connection string server-side:

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

Upvotes: 6

Views: 2408

Answers (1)

Victoria
Victoria

Reputation: 7912

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

enter image description here

Upvotes: 2

Related Questions