Hi all ,
I am running a c/s app on the client pc ( pb 2017r3 win10/11 ) .
The app connecting directly to a MSSql db located on a remote server over the Internet.
I am using SNC SQL Native Client(OLE DB) / MSOLEDBSQL in my SQLCA.DBParm .
My questions :
1. What is the best way to secure the connection ?
2. What is the best way for a good performance assuming the code ( dw ) are not the problem ?
3. Deploying as a PowerClinet can get a better results fro speed / security or its not relevant ?
I know the best answer for all this is using PowerServer , but beside that ...
I will be glad to hear any ideas from people who work the same way maybe .
thanks