Whoa! Slow down. You just asked enough question for which libraries of
books have been written just to answer.
I suggest you start your search, one question/scenario at a time on
google or some other search engine of your choice. An example, I just
typed this into google as a search parameter:
vb.net asp.net sql vs access
and the top result:
http://www.informit.com/articles/art...p?p=26863&rl=1
As far as cost, well, that's very subjective. How many users will be
accessing the database? How many users will access it at any given time?
What kind of data is it? How much data? How secure does it need to be?
I'm sure there's a thousand more questions that can fit into this topic.
MS Access isn't incredibly expensive but SQL can be. There's the SQL
express version that's 'free' but it has its limitations. There's always
the option of going with some sort of open source database like MySQL.
But, to be able to actually tell you which one to use isn't really
possible without answering tons of questions and even then, you'd have
to make the decision on a few possible suggestions.
As far as how you'd connect, that depends on which kind of database
system you're using, which programming language you're using, and
several other variables. I suggest you use Google to find answers to
some of these questions and read read read.
If you develop a web application and run it on a web server (Internet
Information Server) on your local area network (LAN), then you'd use
your web browser to connect (
http://servername/webpage.aspx).
I don't really see why your internet provider is an issue to you when it
comes to your development goals (at this stage). It seem that everything
you want to do would be all LAN, in house stuff unless you were looking
for your staff to connect from other, roaming locations like home or on
the road.
MSK wrote:
Hi,
I am a newbie to .NET/Networking
if I develop a project in
1. VB.NET + SQL server database
2. ASP.NET + SQL server database
3. .NET ( vb or asp) + Access database
Which one is advisable, in terms of hardware, security, cost...?
one more thing, my user has just internet connection (NTL- internet
provider)
If I develop desktop application (vb.net) and install in one
location , keep the server at another location, how can we connect?
can I achive via CODE ? any settings ? should internet provider
change anything for me ?
If I develop WEB app (asp.net), I can develop and install in the
server, how we can map these clients with the server via the private
network.
Will .NET (vb or asp) work with Access database (any performance or
functionality issues?)
Thanks
MSK.