Hi,
Using VFP9sp2 and MSSQL2016.
What is the best practice in connecting a VFP app to a SQL backend while NOT exposing the SQL Server machine to the outside world? The goal is for the SQL server to be completely hidden from the wan. If using a web service on a different machine is acceptable, then what steps needs to be done to get this working from VFP? What special hoops do I need to jump thru to get "cursor adapters", remote views, or pass-thru to work? Are there better ways? Please explain, or white pages/articles.
In the past, we exposed sql server to the wan, but had all ips blocked except for a white list. Now, we are changing it so everyone is on the white list, until they get blacklisted. The public facing Server 2016 IIS machine is secured with a SSL Cert and can host the service, if this is best practice.
Assuming a web service is best, where do I learn how to make all the connections?
Thanks,
Stanley
Using VFP9sp2 and MSSQL2016.
What is the best practice in connecting a VFP app to a SQL backend while NOT exposing the SQL Server machine to the outside world? The goal is for the SQL server to be completely hidden from the wan. If using a web service on a different machine is acceptable, then what steps needs to be done to get this working from VFP? What special hoops do I need to jump thru to get "cursor adapters", remote views, or pass-thru to work? Are there better ways? Please explain, or white pages/articles.
In the past, we exposed sql server to the wan, but had all ips blocked except for a white list. Now, we are changing it so everyone is on the white list, until they get blacklisted. The public facing Server 2016 IIS machine is secured with a SSL Cert and can host the service, if this is best practice.
Assuming a web service is best, where do I learn how to make all the connections?
Thanks,
Stanley