Delphi 12, MSSQL Server, FireDAC on android application

[dlucic 1]

Can I connect to MSSQL Server with FireDAC on android application? When I try it there is a problem 

 

 

Is there any eay for direct connection from my android application to MSSQL Server

[Lars Fosdal 1797]

Connecting directly to an SQL db from a mobile device is a bad idea.

There should be a service in between that offers a REST API to serve the mobile app.

[dlucic 1]

11 minutes ago, Lars Fosdal said:

Connecting directly to an SQL db from a mobile device is a bad idea.

There should be a service in between that offers a REST API to serve the mobile app.

OK. I know that about REST API, but I would like to try a direct connection if possible. Why is that a bad idea?

 

Thank you

[Lars Fosdal 1797]

You are exposing the db endpoint on the network.

 

[Die Holländer 54]

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-configure?view=azuresql&tabs=azure-portal

 

>>You are exposing the db endpoint on the network.

The problem is that developers might have applications working over a database developed over

many, many  years with a lot of queries, easy edit possibilities and business objects using Delphi FireDAC or

other direct data access. It´s almost impossible, time sense, to convert such data access application

with a REST API instead using the data objects already created.

 

Nowadays, with systems like Azure with a database in the cloud I wonder if it is possible to create applications

on the internet with a direct database connection in a save way using Delphi VCL or FMX.

Thats why I investigate if there is a possibility and posted the link above..

That it is easy possible to use the azure database directly from a Delphi application I know because

I wrote an VCL application just doing this and the users are very happy with it.

 

 

 

Edited August 21, 2024 by Die Holländer

[Brian Evans 111]

FireDac requires client libraries of some form provided by Microsoft to access Microsoft SQL Server. These are not available for Android. 

 

Another set of data access components is SDAC from Devart which has an additional direct access mode that uses TCP/IP directly to access Microsoft SQL Server. Applications using this direct mode can run on platforms for which Microsoft has not provided client libraries.

 

 

[ThomasRiedelDk 0]

Winsoft has made a driver for this.

I have had the same issue, security is OK on a cloud server, with SSH - port forwarding.

Do you know about other drivers?