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. <img src="https://i.stack.imgur.com/tCqEZ.png" alt="enter image description here"> This is my configuration and it tells me <code>Unknown configuration host</code>. I need to connect to my sql database online. Is FireDAC the real solution? <hr> I have this kind of connection string server-side: <pre class="prettyprint"><code>$pdo = new PDO('mysql:host=mysql.netsons.com;dbname=caorobwq_worldcup', 'username', 'password'); </code></pre>

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. <img src="https://i.stack.imgur.com/xO3J5.png" alt="enter image description here">

Delphi connect to online sql database

Tags:

mysql

delphi

firemonkey

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');

544

asked Sep 20 '16 23:09

Raffaele Rossi

1 Answers

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

125

answered Oct 15 '22 05:10

Victoria

Related questions
                            
                                Optimizing MySQL query on large table
                            
                                "Laravel 5.1" add user and project with userId
                            
                                Need help calculating wins and losses from points scored
                            
                                PHP interafce mysql() not working, but mysqli() is working; why?
                            
                                Connecting tables when querying in MySQL
                            
                                Codeigniter SET variable on query
                            
                                Foreign Key to Same Table in sqlalchemy
                            
                                JQuery table in php
                            
                                Replicate Left join on multiple fields in solr
                            
                                PostgreSQL's SERIAL vs MySQL's AUTO_INCREMENT?
                            
                                Hibernate batch update using HQL Query
                            
                                Getting error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
                            
                                Laravel JSON where clause case insensitive
                            
                                How to select the entire tuple that has the MAX value from a subquery?
                            
                                Session is closed Object name: 'ISession'. at NHibernate.Impl.AbstractSessionImpl.ErrorIfClosed() - How to stop the session from closing prematurely
                            
                                How to fix "InnoDB: Failed to find tablespace for table X in the cache. Attempting to load the tablespace with space"
                            
                                Creating Laravel Eloquent Query with unknown number of parameters
                            
                                Cacti on pgsql in Laravel
                            
                                Convert WooCommerce Custom Product Attributes into Defined Product Attributes
                            
                                Why does Doctrine 2 migration silently fail in Symfony project?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With