How to connect into remote server

[MSK]

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.

 

[Cowboy \(Gregory A. Beamer\)]

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)

SQL Server Standard or Enterprise costs more, is more secure and more
available. But, there is SQL Express, which is free, and will work fine for
a small number of users. Used with a web app, the small number of users
allowed at any one millisecond can still translate to hundreds or thousands
of users, if designed correctly. Access will not scale as well as full SQL
Server or SQL Express.

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 ?

Create the code and deploy using the no touch deployment options. The person
hits a website and downloads the smart client. You can even have it so the
client updates if newer bits are placed out on the server. Look up on the
MSDN site for more information. IF you do smart client, some of the app will
sit on the user's desktop.

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.

If you are at least WIndows 2000 on your servers, you can get sample code on
mapping to LDAP for users. That would prevent them having passwords out of
sync with the network.

Will .NET (vb or asp) work with Access database (any performance or
functionality issues?)

Yes, you can use Access as a data store with .NET. Yes, it will not perform
at the same rate at SQL Server.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*********************************************
Think outside the box!
*********************************************

 

[Jim in Arizona]

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]

Thanks to everyone...I will go thru one by one

MSK