Questions about database.

[Genbox]

Hi. Im in the progress of selecting the right database for my new project. I only have PHP/Mysql and ASP.net 2.0/MSsql experience. So here comes some questions: 1. Can i use MySQL in my ASP.net 2.0 project as datasource for gridviews? just like mssql. 2. Can i use MS access instead of mssql/mysql? i've heard that it only takes a few dataconnections at a time, what is up with that? I ask because i also want to choose my webprovider (web hotel) now. But most of them is expensive if i want mssql + asp.net 2.0 There is a lot of cheap solutions if i use asp.net 2.0 + access or myssql.

[Guffa]

1. Yes. 2. Yes. The database driver for Access limits the number of connections for each user to 64. For web development it means that each web application can only have 64 connections open at the same time. This is normaly not a problem, as a web site that can be served by an Access database usually only uses a few connections at a time. It makes Access more sensetive to badly written code, though. If your web site will have much traffic (like thousands of visitors per day), you might want to go for a more powerful database than Access. --- b { font-weight: normal; }