Clent server application question
1.I want to build a client server application in C# i.e, if for example three desktop applications are running on different pc's updating tables of a database deployed on a server pc such that each client pc store their data on the sql server database tables stored on the server pc.
Can any one help me regarding this or provide me an appropriate link.
Jignesh TrivediPosted Mar 28, 2013, 12:01 AM
hi,
For server client application, that you required it work just like traditional desktop application.
to achieve this you have to do following thing.
1) your SQL Server must enble for remote call and it with in network with application PC.
2) your connection string must contain network path and also user id and password.
Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;
hope this will help you.