how to have a single database for a LAN and server application in vb.net

Question

0.00/5 (No votes)

See more:

I am developing an application in VB.NET and SQL server express as backend for a hospital management system. The application will have two parts - the vb.net application will work in LAN and there will be a website which will be asp.net with VB. People will be able to book appointments directly in hospital or from website. Now, my question is how to have one database for both. And the second question is how to make the vb.net application work over LAN.

Posted 26-Jul-13 0:30am

DoctorJ97

Add a Solution

Comments

[no name] 26-Jul-13 6:41am

"how to have one database for both", create a database and have both connect to it.
"work over LAN", greatly depends on what you mean by "work over LAN"

DoctorJ97 26-Jul-13 15:12pm

I know that one PC will work as the server. Now to use the application in all the connected computers, will I have to install the vb.net application. If so then how will they access the database. How will the webserver connect to this database available on a local machine.

RedDk 29-Jul-13 15:52pm

How are you developing this VB.NET app? That is, with what are you developing this "app"?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

David Mujica · Answer 1 · 2013-07-26T05:21:00

1) You should have one computer dedicated as the SQL database.
2) Your vb.net applicaiton will connect to that machine as defined in the Connection String
3) Your web server will also connect to that SQL machine as defined in a Connection string.

Good luck.

For each computer that will run your application, YourApp.exe, you can install that executable on each computer. (There are other ways of doing things, but let's use this deployment method). When you develop YourApp.exe, you will need to connect to a database; typically you would connect to the database by referencing a connection string stored in a configuration file.

The connection string would look something like this:
""Data Source=YourSQLserverName;Initial Catalog=YourDBname; User ID=YourUser;Password=dummy"

The web server would connect to the database using a similar connection string.