Click here to Skip to main content
15,891,375 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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:
1.App.conf
2.DataSet (for Crystal report)

Can anyone suggest me to solve this problem
Posted

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.

http://msdn.microsoft.com/en-us/library/bb386386.aspx[^]
 
Share this answer
 
v3
Hi,

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

--SJ
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900