Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sudhakar_msccs@yahoo.com
Starting Member
2 Posts |
 Posted - 2005-12-12 : 01:44:08
|
| I am developing a project using asp.net with vb.net as frontend.which backend is best sqlserver/msaccess? if ms access then which driver is to be used? |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-15 : 07:39:12
|
Access is a file database, which means every request to it, would mean you have to (1) open and (2)close the filewhen you have a heavily hit site, access woudl crash.MS SQL is a relational database management system (RDBMS) For the enterprise, built to scale, millions of records, which is built to handle such records, ACID compliant, stored proceedures which allow you to partition your application into tiers, etcThe choice is up to you  driver to use ?see www.connectionstrings.com Afrika |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-15 : 07:56:19
|
| It depends on the number of data you are dealing with MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
which backend is best