Menu
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');
544
Start the SQL Server, in the dialog window for the Server name enters the name of the instance that you want to connect with. From the Authentication drop down box, select the SQL Server Authentication and for the field Login and the Password enter your credentials then click the Connect button.
InterBase is an embeddable SQL database that integrates natively to Delphi and C++Builder for client/server or embedded development.
In this article we will connect MS SQL Server database with Delphi using FireDAC. We will go through code to make database connection. Go to Delphi IDE and select File -> New -> VCL Form application - Delphi
We will go through code to make database connection. Go to Delphi IDE and select File -> New -> VCL Form application - Delphi
Bob Swart has published Delphi for Win32 VCL Database Development on Lulu, if you need any help. Show activity on this post. Don't forget that MySQL's client dll are GPL-ed, and if you are using it to connect to server, your app must be GPL-ed.
Local SQL works with any data source that can be loaded into a TDataSet (e.g. CSV files or queries from multiple databases) to produce a virtual database that can have SQL run against it. - Ideal for data migration and consolidation.
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.
125
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
