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

2 New Member

I am developing an application 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.

Jul 26 '13 #1

Subscribe Reply

7822

vijay6

158

New Member

Hey doctorj97, for your second question,

how to make the vb.net application work over LAN.

1) Install SQL Server Express edition in a machine which you want to act as server machine.

2) Allow TCP/IP connection in server machine. Open SQL Server Configuration Manager -> in left panel expand SQL Server [version] Network Configuration -> double click Protocols for SQLEXPRESS -> in right panel right click TCP/IP and select Enable.

3) Set exception for the port number which you're using for SQL Server in server machine.

I) Default port number is 1433. To find/set your port number, open SQL Server Configuration Manager -> in left panel expand SQL Server [version] Network Configuration -> double click Protocols for SQLEXPRESS, right click TCP/IP and select Properties -> Select IP Addresses tab -> scroll down to IP4 -> TCP Port (your port number).

II) Control Panel > Windows Firewall > Advanced settings -> Inbound Rules (in left panel) -> Select New Rule... (in Actions) -> Select Port -> Click Next -> Select TCP and Enter your SQL Server's port number (1433 default port number) -> Click Next -> Select Allow the connection -> Click Next -> Select the network types in which you want to allow set an exception -> Click Next -> Enter any name -> Click Finish.

4) Connect other computers to this server machine via your lan cable.

5) Assign unique IP address to all machines over this lan network including the server machine.

6) In your application's connection string line use Data Source as Server machine's IP Address (lan's IP address), Port Number.

Eg: Data Source=190.190. 190.1,1433;

For your first question,

how to have one database for both.

1) Host your website in any server like IIS in your server machine.

2) Assign your internet's IP address (If you're using this website only in your lan network means use your server machine's lan connection's IP address. Else if you want to use apart from lan network means then assign your internet's IP address) to your website in IIS.

3) In your website's connection string line use Data Server as Server machine's IP Address , Port Number. Eg:

Data Server=190.190. 190.1,1433;

4) You can browse your website using your server's IP address (internet's IP address not lan's IP address).

Jul 28 '13 #2

doctorj97

New Member

@vijay6
thank you very much.I will try in this way.I hope it works for me.

Jul 28 '13 #3

Similar topics

7497

Single database transaction across a multiple HTTP requests?

by: noah | last post by:

Does PHP have a feature to associate Cookie sessions with a persistent database connection that will allow a single transaction across multiple HTTP requests? Here is how I imagine my process: I have an series of interactive HTML forms. The user begins a Cookie session. A database connection is opened and a transaction is begun. After the user goes through any number of pages where they update the database they finish on a page where...

PHP

2561

web applications is client-server application?

by: Matt | last post by:

I think this is the basic concept in ASP server-side development. My boss told me web application is NOT client-server application. I argued with him because browser is the client, and the server code put in server. Then web application should be a client-server application. My understanding is that a web application is an application that runs on a browser. But client-server application is not necessary a web application. Please...

ASP / Active Server Pages

5710

SQL Server Application Roles

by: Jonathan Allen | last post by:

Is this the correct way to use application roles? Public Function GetDBConnection() As SqlConnection Dim oCon As New SqlConnection(myConnectionString) oCon.Open() Using oCmd As SqlCommand = oCon.CreateCommand oCmd.CommandText = "IF NOT User_NAME() = 'app_name' Exec sp_setapprole 'app_name' ,'password" oCmd.ExecuteNonQuery() End Using

C# / C Sharp

3230

need to restore old database (database server 4.01 AIX)

by: HSP | last post by:

hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup purposes). Now, the drive is defective and can't read the tapes anymore. Server is AIX 4.3.2 and database is IBM DB2 Server (DB2 for AIX Version 2.1.2)

DB2 Database

1491

Server Application need to handle HTTP(s) Requests...

by: apoc69 | last post by:

Hi people, i have a own server application (written in .net) which proceess different message types, like XML, EDI, SPEC2000, SAP IDOCs. and so on... this application is doing a lot of different work. Now a customer want to send its data over HTTP/HTTPS.. The most customers are sending theire data over FTP/ASCII into a local folder. The server app verifies and insert/updates the data into a SQL

C# / C Sharp

1913

Queueing in Client Server Application

by: asadikhan | last post by:

Hi, I have a client server application where the client sends a request to the server with a filename. The server needs to read the file contents, massage the data, and then add it to the database. However, if two requests show up at the same time, I need to create some sort of a waiting mechanism or queue. I was thinking about using a Singleton Server Activation object for this reason, but I am not sure how I can implement the...

C# / C Sharp

4876

Creating a multi-tier client/server application

by: Jeff | last post by:

Hello everyone. I've searched through the archives here, and it seems that questions similar to this one have come up in the past, but I was hoping that I could pick your Pythonic brains a bit. Here's a broad overview of what I need to do: cross-platform, client- side GUI apps that interact with a server backed by a database. I'd also like the possibility of having a web interface for small portions of the app. It will be a fairly...

Python

1820

Is it possible to have a public server application on a network without port forwardn

by: ethangk | last post by:

Hey This is a little hard to explain but I will try my best. Is it possible to have a application running on a specific computer on a network, and to have all requests sent from the internet sent to that specific machine, without setting up port forwarding, and if so, is this something which would need to be hard coded into the application, but im inclined to think that it isnt. An example: multiple users on a network can browse the web at the...

Software Development

1625

problem on the server application oracle 10.1.2.0 .2

by: tajabadi | last post by:

Hello I have installs the server application 10.1.2.0 .2 in Windows 2003 server. I have forms 6i that j' converted into forms 10g. The language that j' use is Persan. With posting in browser IE, the words are to throw into disorder. I use ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256 in NLS-LANG. You, me can PLEASE; help has to solve this prbleme. I thank you d' advances.

Web Applications

1709

.NET Client - Server application gets frozen, need ideas to fix!

by: Emek Taydas | last post by:

You cannot vote on your own post 0 Helloes good people of Bytes.com, I have a .NET client-server application running with a few hundred of clients. The project was migrated from VB6 to .NET about a year ago and it's a platform for card/board games. Although I'll be trying to give as much detail as I can below, the problem is getting a channel frozen when there are 40-70 players inside. Architecture 1. Server (.NET 4.0) * Divided...

.NET Framework

8468

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8386

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8901

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8660

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6213

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4209

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4390

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2799

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1792

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General