Re: How to connect into remote server


"MSK" <mannaikarthik@xxxxxxxxx> wrote in message news:1176826204.683657.263440@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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!
*********************************************

.

Relevant Pages

  • RE: Offline Smart Client
    ... you want to create an offline smart client. ... If you want to synchronize database, the Sql Server Replication may help ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: General Network Error
    ... Thanks michel, if I use smart client design, Should I use asp.net to build ... Can you recommend any web sist talking about smart Client? ... > a connection ... >> to reduce cost and move the MS SQL server to china 's data centre. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Best Practices for Data Access
    ... This approach also means you would have N backup strategies, N management strategies, N sets of stored procedures that cannot leverage the features of the backend--assuming the backend even supported SPs. ... While Oracle and SQL Server both support SPs, ... I need to design an smart client application that can run on mulitple and plugable backend like MS SQL, Oracle or MySQL. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: General Network Error
    ... You can make a Windows forms app behave as a smart data client, ... term "smart client" is used for applications started over the web that check ... does data synchronization with a master server this aproach is often used ... >>> to reduce cost and move the MS SQL server to china 's data centre. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQL server question
    ... Microsoft is deprecating it even for new development, ... An Access project is an Access file that provides a direct, ... You can connect an Access project to a remote SQL Server ... a local SQL Server database, or a local installation of the SQL Server ...
    (comp.databases.ms-access)
Loading