I am evaluating web building tools and I have a question concerning connecting to MS SQL Server. Primarily can this be done securely and easily enough? Thanks in advance.
That depends on the application server you are using. PHP can do it,
Ruby on Rails can as well. Naturally ASP and DotNet can, since that’s
about all they can do. Most application servers are fairly agnostic
about what sort of SQL server they connect to, but there are quirks
about the SQL language that MS SQL “speaks” which will mean that any
queries you write for that server will remain locked to it, forcing a
rewrite when and if you decide to migrate to a different (more
standard) database server.
Walter
On Jan 5, 2009, at 10:31 PM, Mike wrote:
I am evaluating web building tools and I have a question concerning
connecting to MS SQL Server. Primarily can this be done securely
and easily enough? Thanks in advance.