Middle-Tier access

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Sid
Posts: 6
Joined: Mon 30 Jan 2012 21:54

Middle-Tier access

Post by Sid » Thu 14 Apr 2022 15:27

We have a large application developed in Delphi 2007. We use SDAC components heavily to connect to MS SQL Server in a 2-Tier Client-Server environment.

Now, we want to change our apps to a 3-Tier Architecture access to avoid exposing SQL Server to the Internet ( so it is only exposed to the middle-tier access behind the firewall ). The question is, is there an easy way to convert these to 3-Tier approach, where TMSConnection on the client app can point to some proxy remote Server in the middle-tier and all the DB requests are transacted through the middle-tier with the MSSQL Server?

Any existing solution that requires bare minimum of changes for the SDAC components?

Can you suggest any other approaches/ frameworks?
I know some out there like RemObjects Data Abstract or Delphi DataSnap or TMS Software, but these need complete restructuring of the apps.
Top
Post Reply

Return to “SQL Server Data Access Components”