473,507 Members | 5,257 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Distributing application to customers?

I have created an application which creates a financial plan for our
customers. Now my financial planner wants to distribute a copy of application
to our customer with their respective plans and limited functionality. How
can I can I do this? I am using SQL Server at the back end with several
stored procedures. I’ll have to distribute a copy of .NET Framework and MDAC
as well. Moreover I’ll have to distribute the application on a CD as it’s not
possible to fit everything on floppies. Someone please put me in right
direction to achieve these tasks, as I am doing it for first time.

Thanks

Jul 21 '05 #1
2 1424
I assume your application is a Windows Forms app.

If your "customers" are within your corporation, then this is sticky but
possible. If your customers expect to connect to you over the open
internet, I'd advise against connecting to SQL Server over the internet. It
is a little too easy to slam SQL Server with a DoS attack, and we all
remember the SQL virus about a year ago that slammed every SQL Server that
wasn't protected behind an iron-clad firewall. (SQL Slammer, I think it was
called).

No, I'd recommend against allowing your customers to connect across the
internet.

If your customers can connect to your corporate network, or a small secure
portion of it, using RAS, then you can have them dial in. They can either
run the app from their machine or use Terminal Services to run the app from
your machine. The latter is easier for you to deploy but requires users
that won't mind being trained on the intricacies of Terminal Services (e.g.
this usually works for the sales force, not the end customer).

At this point, I'd say your app isn't designed for the use that your
financial planner wants to use it for. I'd suggest adding some web services
on a server that can provide the data to a validated user and can check the
incoming data. Then jigger the app a little to call the data from the web
service instead of the database. This will allow your client-server app to
be run across the Internet, and you can put in a modicum of security by
using HTTPS for the transmission protocol.

That's probably the simplest without rewriting the app to a web app.

HTH,
--- Nick

"Job Lot" <Jo****@discussions.microsoft.com> wrote in message
news:4E**********************************@microsof t.com...
I have created an application which creates a financial plan for our
customers. Now my financial planner wants to distribute a copy of application to our customer with their respective plans and limited functionality. How
can I can I do this? I am using SQL Server at the back end with several
stored procedures. I'll have to distribute a copy of .NET Framework and MDAC as well. Moreover I'll have to distribute the application on a CD as it's not possible to fit everything on floppies. Someone please put me in right
direction to achieve these tasks, as I am doing it for first time.

Thanks

Jul 21 '05 #2
thanks for the reply

The client version will be a subset of main application with limited
functionalities. It will be a windows application, not web application. I
don't want user to update changes they have made to our server. I want users
to save changes locally in a database which will be distributed with client
version. Will MS Access be a good choice?

This is what I want to achieve:-

As soon as financial analyst finished a plan for a customer and decides to
create a distributable version for it:-

-Records for that particular customer along with plan details get copied
from SQL Server to a database (ms access) which will be used with client
version.

-The configuration file, setup file for the application, database (ms
access), related dll's, .net framework and mdac gets copied on a CD for
client to deploy.

Thanks
Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2151
by: Rick | last post by:
Hi all, I am writing a small PHP accounting and office management application and would like to learn how to "package" it for distribution. It requires the use of a small MySQL database which is...
2
1937
by: Ian Davies | last post by:
Hello Recently changed from using Access to MySQL. Looked at the online docs but could not find anything about the process of distributing a database to customers. Can anyone give me a general...
10
7367
by: John Phelan | last post by:
I read an article by, by Mike Groh, in Access-VB-SQL Advisor Magazine, Week 37 that concerns me quite a bit on distributing Access Applications commercially. First I need to describe a "commercial...
2
2417
by: Scott | last post by:
Any help would be grateful :-) Problem: When I test my installation of Access 2000 MDE, I get the following error: "Unrecognised Format".. This means that Access 97 cannot read Access 2000. ...
3
2630
by: PeterH | last post by:
I have an application written in VB.Net that opens an Access database (ie a Microsoft Jet 4 database mdb file). It does not use Access forms or reports, so there is no need for users to have...
5
1739
by: summerwind | last post by:
I wonder if someone can help me please. I have developed apps for small business on a bespoke basis for a long time. I have usually gone along to the client to install the apps. My client base...
2
318
by: Job Lot | last post by:
I have created an application which creates a financial plan for our customers. Now my financial planner wants to distribute a copy of application to our customer with their respective plans and...
0
1810
by: BallCOMET | last post by:
I have an application that I built with Visual Studio 2005 and for which I enabled OpenMP. If I open the compiled binary in Visual Studio, this is the manifest that is embedded in the executable...
5
2690
by: xkenneth | last post by:
Hi All, I'll shortly be distributing a number of python applications that use proprietary. The software is part of a much larger system and it will need to be distributed securely. How can i...
0
7221
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7109
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7372
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7481
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5039
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3190
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
411
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.