I have a secure SQL DB that contains user data that is needed for login authentication by a web app. The web app is being developed by a third party, and we do not want to allow their app to authenticate login data with our secure DB directly.
What is the best approach to provide the authentication (verify the user is in our DB) without allowing a direct connection to our server and DB? The only thing I can think of is to develop a Windows 'service' that would run all the time and look for inbound login request packets. Then the 'service' would query the DB and return a 'pass/fail' packet for subsequent pickup by the web app.
I am sure there are a number of approaches, but I can think of only the one.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.