Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
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 25-Sep-12 3:29am
Lotus90317
Rate this: bad
good
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).
  Permalink  
Rate this: bad
good
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)]
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!
Smile | :)
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.1411022.1 | Last Updated 25 Sep 2012
Copyright © CodeProject, 1999-2014
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