Click here to Skip to main content
15,881,872 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
Hi
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

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)]
http://support.microsoft.com/kb/914277[^]

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!
:)
 
Share this answer
 
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).
 
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