[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

How can ALLaccess my MSSQL Windows Application from different Points including Internet

Hi Experts,

I just completed a windows application with VB and MS-SQL backend.

My client has requested the following in addition:

1. All marketers must be able to use the application within the LAN and also offline/otside the LAN provided
2. The branches with an intranet connectivity must be able to use the application without copying datafiles on disk if you know what i mean.
3. that the company's customers must be able to access some defined information via the internet.

What can i do that would allow all this many and different people to access same Database real-time online?

I would appreciate any form of design, concepts, ideas, procedures and information to guide...

Please be advised that i dont even know where to start.

Any thoughts, ideas are greatly appreciated.
Thanks.
0
ukconcepts
Asked:
ukconcepts
1 Solution
 
assystCommented:
1. All marketers must be able to use the application within the LAN and also offline/otside the LAN provided
 >> Since it's a windows application you need to install the application for those who require it connecting to only one database. If people want to get connected from outside the LAN then they should do a Remote desktop connection to access the application.

2. The branches with an intranet connectivity must be able to use the application without copying datafiles on disk if you know what i mean
>> So that means that you will have a single database connectivity which you might have already set the connectionstring in your app.config.

3. that the company's customers must be able to access some defined information via the internet.
>> For this you may have to develop a web application to show the required information connecting to the same databse.

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now