Click here to Skip to main content
13,251,398 members (55,270 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I'm working to VB.Net Desktop application
The same application will be installed on two or three PC ; and each version had different privileges and one of those had the administration privileges.
and they share the same database (any update will be appear to other users).
How I can Do that logically ? and what I need ?
Posted 25-Sep-12 3:29am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You need no more that being able connect remotely to the central database (since you may use the database as communication, sinchronization mean for the applications).
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

1. share your database on LAN/WAN
2. set new connection string in exe/text file [where sql connection string is written]

step 1: follow steps given in this link [For access sql database remotely(from different pcs)][^]

step 2: after step 1 complete then change connection string's parameters,
datasource = server-name OR IP-Address [which is in sharing now after step 1] ;
Initial catalog = your database name ;
UserId = sql server - user login Id ;
Password = sql server - user login password;

Happy Coding!

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 |
Web01 | 2.8.171114.1 | Last Updated 25 Sep 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