Re: How to connect into remote server

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/article.asp?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.

.

Relevant Pages

  • RE: Vulnerability analysis tools
    ... Definitely you want your Oracle database behind a firewall. ... tell you the database is not meant to be exposed to the internet directly. ... 1- A web server hosted at an IDC ...
    (Security-Basics)
  • Re: Problem accessing Sharepoint following Microsodft Update
    ... Check the database connection ... > information and make sure that the database server is ... >>>How are you accessing from the internet? ... >>>> one NIC with a router with inbuilt firewall. ...
    (microsoft.public.windows.server.sbs)
  • Re: How to error-proof Doug Steels "FixConnections"?
    ... rather than letting them type in the server and database name. ... you could also store the information in a table in the front-end. ... SQL Server database from the backup, how to get rid of the annoying ...
    (microsoft.public.access.externaldata)
  • web development advice needed
    ... We are a small company with experience in client-server apps with ... DOT.NET and making it accessible for Internet browsers. ... From what we know we need a Window Server ... , database server and DOT.NET. ...
    (microsoft.public.windows.server.general)
  • web development advice needed
    ... We are a small company with experience in client-server apps with ... DOT.NET and making it accessible for Internet browsers. ... From what we know we need a Window Server ... , database server and DOT.NET. ...
    (microsoft.public.dotnet.general)