Using delphi7 + sql2005 writing system, now require more use at the same time, have what good plan?

CodePudding user response:

The simplest method is sql2005 open the network port,
The other way is to have changed my code

CodePudding user response:

Make public database sql2005, opening to the outside network, Delphi written to the client

CodePudding user response:

Datasnap server, the IP operators needed to buy a fixed IP, apply for a domain name, set up a server, the client can access after verified

CodePudding user response:

The socket fixed IP or peanut shells,

CodePudding user response:

Database open public port, it is A way, but the data security can't guarantee, the original poster can be Delphi applications deployed on A single server (citrix or vmware, A machine), let the client around the VPN access to A machine, for your reference

CodePudding user response:

Database port is not a good idea to open the network,
With multilayer plan or your database with a springboard, not directly exposed ports to the outside network

CodePudding user response:

With three layers architecture, DATASnap to complete, simple and efficient, online many examples,

CodePudding user response:

https://blog.csdn.net/pcwe2002/article/details/52527782
The remote access database exist the problems of slow speed and easy to drop, replace the connection string can solve this way

CodePudding user response:

With three layers architecture, not exposed out port network, cannot easily be attacked

CodePudding user response:

If don't want to change the VPN setup, if the original design is not a multi-user architecture, the software structure must change

CodePudding user response:

A year ago, if not yet solved, estimates, or you are fired by the boss (you fry the boss), or it's changed my plan, and it is implemented,
Basic problem itself, directly open the network service mode is not desirable, must consider the security problem is system, database, do not open the network
VPN is a kind of simple solution, under the condition of not changing system, a relatively safer way,
Three layer or multilayer way best, of course, only variable costs,

CodePudding user response:

Or stand-alone mode, but using remote desktop MSTSC echo results, realize the user

CodePudding user response:

Write a middle layer, can be Delphi Webbroker web server, more can invoke the same service