Android – how to connect to SQL Server database from Delphi firemonkey
I want to connect to MS SQL server to use firemonkey to insert or update some data for my Android application. I am using Delphi xe8. Is there any way to use the default component to perform this operation? Don't use other components. I'm using a remote server with an ID address
resolvent:
I suggest you use XML / JSON service to connect to SQL Server database. It will save you time, data security, application security and application development time
Indy component is very suitable for HTTP Rio. You can also create soap connection objects directly from code. It depends on your choice
You can also use the firedac component to connect to the database directly from firemonkey. It may be useful for SQLite database, but I have never used firedac for SQL Server connection