What common database is used with ASP?

I 开发者_JAVA百科know PHP and how to use MySQL with it but now I am moving onto ASP but which common database is used with ASP (ie. the equivalent to MySQL)?

Microsoft SQL Server.

This is commonly known as WISA (Windows, IIS, SQL Server, ASP) stack.

It is Sql Server (Express editions are free) but you shouldn't let this be your only deciding factor. Besides, it doesn't really matter. The db is the back end, unseen by your clients, and you can connect to many, many types of DBs from ASP just as well as to Sql Server.

Your main consideration should be features, scalability etc. For the sake of picking up this dev stack quickly I would suggest sticking with MySql for you. That would be one less rather large piece of technology to learn!

Also: Are you moving onto ASP (classic) or ASP.NET? If it is ASP I would recommend that you reconsider and choose a more modern web development methodology such as ASP.NET MVC or Silverlight. I think that you will find ASP.NET MVC to your liking. In some ways it feels like ASP or PHP of old but with much more flexibility.

Usually it's Microsoft SQL Server.

If you want a free alternative you could try with Microsoft SQL Server Express, which is a scaled down version.

Here you can find more informations about the different versions.

MS SQL server is commonly used with ASP (Classic and .NET). There are many different versions of SQL (SQL Express, Standard Edition, Enterprise etc)