classic ASP questions...

[Jimmy]

hi everyone. building a website for a client and have a few questions
related to best practices, what i should use etc...

the site will use a database to store info entered by users. each visit will
allow the user to input no more than 2 fields: email address, and a comment
field. the site has the potential to become pretty busy so my first question
is, what should i use on the backend? a dedicated SQL server isnt an option
so im looking at either an Access database, or the desktop edition of SQL
installed on the web server.

second question (and this might help decide which DB to use) is: what are
the proper ways to open the databse so that multiple writes can be done at
the same time in the case where more than 1 user are entering info at the
same time? im referring to LockType, CursorType etc... (im not entirely sure
of the workings of these things so if someone could give me a quick opinion,
and point me in the right direction i can take it from there)

thank you in advance

[Mark Rae]

"Jimmy" <[e-mail] in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

thank you in advance

This newsgroup is for ASP.NET.

For ASP Classic please use microsoft.public.inetserver.asp.general or
microsoft.public.inetserver.asp.db

[clintonG]

ASP.NET 2.0 is the current best choice for your application development.
Your requirements -- as stated -- demand the use of SQL Server whether you
want to hear it or not. There's affordable hosting from WebHost4Life.com and
others that support SQL Server accounts. There are also ASP.NET hosting
providers that support MySQL. Yes, you can also use SQL Express as you
surmised.

The framework supports them all or 3rd parties have made it possible to use
the framework with MySQL. The choice is yours but it doesn't sound as if you
really have a clue yet.

--
<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/
MAP 43°2'17"N 88°2'37"W : 43°2'17"N 88°2'37"W
"Jimmy" <[e-mail] in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

hi everyone. building a website for a client and have a few questions
related to best practices, what i should use etc...

the site will use a database to store info entered by users. each visit
will allow the user to input no more than 2 fields: email address, and a
comment field. the site has the potential to become pretty busy so my
first question is, what should i use on the backend? a dedicated SQL
server isnt an option so im looking at either an Access database, or the
desktop edition of SQL installed on the web server.

second question (and this might help decide which DB to use) is: what are
the proper ways to open the databse so that multiple writes can be done at
the same time in the case where more than 1 user are entering info at the
same time? im referring to LockType, CursorType etc... (im not entirely
sure of the workings of these things so if someone could give me a quick
opinion, and point me in the right direction i can take it from there)

thank you in advance