How I can make online software in vb.net IF CLINT IS ONE CITY AND SERVER OTHER CITY ?

Question

3.00/5 (1 vote)

See more:

I am student of bachelor of computer science. I am working on a software .I am using a computer language vb.net. I am working on software that is Accounts Software there a database and some forms.
There is a database which is made in sql server 2000 and there are many tables.
My question is that I make that software for a Client and database will be attached in my computer.
Both are using DSL internet me and Client too.
I want to that when my Client open that software and then he work in the software then he save record so it saved in my computer database.
Please tell me complete way of that.
I saw software same as there is a bat format file I have to run first it then it successful then I can open software.
There is bellow my connection which is I am using in my software please tell me about it please.

VB

Public Function connection() As SqlConnection

con = New SqlConnection("server=(local);database=shaan;integrated security=true")

        Return con
    End Function

This is just use when software is running in my own computer but what will be connection when my Client will use software and he is also using DSL internet connection so how can create connection between server and Client

Client send request to server

Posted 11-Nov-10 19:07pm

irfanansari

Updated 11-Nov-10 23:52pm

thatraja

v2

Add a Solution

2 solutions

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)

Rod Kemp · Answer 1 · 2010-11-11T19:28:00

First you need to set-up Port Forwarding in your DSL modem and any routers you have to forward any requests from the internet on port 1433 to your computer, also open port 1433 in any firewalls, then you need to give Clint your public IP address (assigned by your ISP, which may change if your modem resets, if your ISP doesn't assign static addresses).

Connection string becomes;

Data Source=Your Public IP Address,1433;Network Library=DBMSSOCN;Initial Catalog=YouDataBase;User ID=myUsername;Password=myPassword;

Dave Kreskowiak · Answer 2 · 2010-11-12T10:29:00

Solution 2

How many times are you going to ask the same question and completely ignore the answers you're given??

Don't repost this question again. You REALLY need to learn how TCP/IP networking works before you tackle something like this.

Posted 12-Nov-10 10:29am

Dave Kreskowiak