Click here to Skip to main content
15,900,906 members
Please Sign up or sign in to vote.
5.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.

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 sever
Posted
Updated 11-Nov-10 5:49am
v4
Comments
Slacker007 11-Nov-10 11:38am    
So what is it that you are asking here? It seems to me that you are asking for a lot of help here. You are not going to get anyone here who is going to do the work for you. We are here to help but not here to do all the work for you.
Simon_Whale 11-Nov-10 11:59am    
Have you tried to run a database function from the client to the server? does it error etc

hello ; you mean the he have to use your database installed on your computer .. is he is on the same lan that will simple , but if he is not on the same lan that you must need a fixed Ip to your pc or use a VPN.
so if he is on your lan you have to change the connection string by using your compturename/SQLserver...
I will tell you more about this configurations but first clear my first question ..
regards..
 
Share this answer
 
Comments
irfanansari 11-Nov-10 13:08pm    
it not vpn it is www internet
irfanansari 11-Nov-10 13:09pm    
mean my clint in other city and i am other city then how i can do this please tell me
so you need an fixed IP , or host your application in one of the hosting company ..you will just pay a little for the hosting better then buying a fixed Ip from ISP.. regads...
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900