Can I run a database application installed in one machine from another machine in the same network?

Question

I have an application in C# 2.0 installed in machine A. Now i want to run the exe from Macine B in the same network with out installing locally in B.
I triwed but getting DB errors, i want to know is it possible or not?

Yes am storing the connection correctly and its in the config file.. I am sure connection is not the real prob..
Thank you for the replys,, I just wanted to know whether running an installed application from another machine is possible or not.

Thanks again
Anz

Answer 1

As long as your program knows which machine to use for the database information the application can run anywhere. Generally database connectors allow you to specify an IP or "computer name". Most depends on what type of DBase is being used. All depends on your Code and type of database and how it connects.

Answer 2

Yes you can. The connection string to the database should be placed in a configuration file rather than be hard-coded. Hard-coding it is an extremely bad practice which requires you to change the querystring in code and compile your application each time you change the DB server.

Answer 3

In principle, yes. In practice, care is needed; a system of locks is necessary so that two machines do not attempt to update the data base at exactly the same time. The application software needs to take this into account.