My question is, would a CGI/Perl solution be the best route to go with a SQL backend (Microsoft) or should I go with ASP or other? The biggest concern is security as I deal with very sensitive information.
Thanks for any and all suggestions.
With that said there are things you can do with all of the aforementioned "scripting" languages to make them more "secure". Security of course is a multi-level process. You need to lock down and secure more than just the code; access points, and data transmission also need to be considered.
Scott Geiger
You really have to look at your whole setup from both the hardware and software perspective. If the information is that sensitive then there is not really any measure that would be considered too far. You have to be sure that you go far enough.
From the code standpoint, at least for php there is also the Zend encoder [zend.com] to encode php scripts. I think any of the languages mentioned are fine, more of a question of implimentation than anything else. The sql type is fine as long as it is a transactional database (again if the information is that important).
It is a very all encompassing question because everything in the picture is important.
"you are only as string as your weakest link"