Click here to Skip to main content
13,250,453 members (48,986 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Hello Friends,

I have developed 1 software that can access only one database(i.e: All clients software access the admin database).

Software are created into two phase:
1 For admin PC
2 for Client PC

Software are installed into:
1. Admin-PC (have a database: Sql server 2008)
2. Clients-PC (in 3 computer's without database)

This software installed into 3 different computers connected with LAN to access database.

My problem is that How clients software access the database from the Admin-PC ?

My Idea:
Create run-time database connection to (Admin & Clients) software.
So that anytime that can be configure.

Configuration on:
2.DataSet (for Crystal report)

Can anyone suggest me to solve this problem
Posted 30-Nov-12 4:04am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

1. I would do it with WCF

2. I would make my program n-tier UI, business logic and DAL

3. I'd make sure that my business logic interacts with the DAL using a consistent data type like datasets or array to minimize the endpoints exposed by my web service

My endpoints with pass a list, dataset, JSON , XML or some data structure that can be easily used by my DAL as long as its consistent to avoid changing the structure of the program too much.

In the client machines you can use a delegate or a small function to call the webservice and translate the data so that you only have to install the UI and the business logic layer on the client machine.[^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 2


Your idea is correct.
At first enable the remote connection of SQL Server after that create app.config file which contains the connection string to connect your Admin PC.
At finally, assign the dataset value to crystal report


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.171114.1 | Last Updated 30 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100