mysqldelphifiremonkey
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.
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');
Solution
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.
- How do I set the default schema for a user in MySQL?
- How to output geoJSON file from mysql spatial table?
- PHPMyAdmin Configuration not working because of MySQL user password?
- The best way of storing many to many hierarchical data in sql
- JDBC connection without database definition
- Can Magento Connect to Another MySQL database?
- PHP isset() with multiple parameters
- bootstrap table doesnot display data
- CakePHP-2.0: Refactor my code editing faster sql query, need a faster sql query
- ERROR 2006 (HY000): MySQL server has gone away
- Problems selecting multiple column
- Order rows based on another table?
- MySQL Workbench edit data
- brew start and brew restart wont start service
- Sort MySQL query result by calculated average DESC
- PHP MYSQL Array and sort
- Use queryset result as a parameter to a raw SQL in Django
- Getting multiple values for a date for Google Charts
- is there any way to check with cumulative way to get month based on the amount fields
- How to compare using bcrypt in a db query using node.js and express
- SQL query to check if a name begins and ends with a vowel
- MySQL JSON_OBJECT() datetime format
- Why is MySQL Sorting by mp.id in This Query Execution Plan?
- PHPExcel download not working properly
- MySqlCommand().ExecuteReader().GetString() does not work
- how to sum rows together but also leave the original rows in the results?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- Java - Having a huge ArrayList (1 million +), how to create a String of it in a acceptable amount of time?
- SQL filter for same values in different columns
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it