Connect to Server via Internet

Question

0.00/5 (No votes)

See more:

:rose:
Hi I have a Windows Application program and there is a SQLServer data base in another city. And we both have high speed Internet how can i connect my application to that Server?
"My application is working well at local network with 100 computers" .
Thank you.
:rose:

Posted 20-Sep-10 6:44am

Said Ali Jalali

Add a Solution

4 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)

TheyCallMeMrJames · Answer 1 · 2010-09-20T06:48:00

So we can guess you're working in Visual Studio 2008?

This is the same as connecting to a local database: use a connection string.

If you know the IP address (or have DNS resolution) and have credentials on the remote DB server to access the database, this is all you need.

You can establish a connection to the database server from the Server Explorer in VS.

For details on connection strings (to any type of database) visit ConnectionStrings.com[^].

Cheers.

Said Ali Jalali · Answer 2 · 2010-09-20T07:01:00

Solution 2

:rose:
Hi,Thank you for your help.Yes I'm working with VS2008.
But can you explain more and give me an example?
Because I'm new in this kind of project,And its too kind of you.
Thank you.
:rose:

Posted 20-Sep-10 7:01am

Said Ali Jalali

Himanshu Thawait · Answer 3 · 2010-09-20T07:02:00

Solution 3

Hi,

You need static Ip for this.

Thanks,
Himanshu

Posted 20-Sep-10 7:02am

Himanshu Thawait

Comments

Tbhavesh 14-Aug-12 15:06pm

Hi Himanshu,

I found your post on code project and need your suggestion in below situation:

I have SL 5 solution having two projects - Client code and Server side code.

I need to call third party API which can provide response in JSON/XML. I need to perform GET/DELETE/PUT and POST operations.

Now from where I should call this third party API? Client side or Server side. Due to security reasons, I guess I need to call from the server side. What should I use to call third party API - WCF or any other thing?

Any suggestion will be a great help.

Regards,
Bhavesh
thakkarbhav@hotmail.com

Abhishek Sur · Answer 4 · 2010-09-20T10:17:00

Hi,

First of all you need an external IP for your Remote Server. Generally, most of the servers have an external static IP. Say its XXX.XXX.XXX.XXX

So when you connect to the server you just use

Data Source=XXX.XXX.XXX.XXX;Initial catalog....

So if you can connect to the server by calling only using External IP, you can just exempt SQL Browser from firewall and access directly using its IP address.

I hope you got the point clearly.

Connect to Server via Internet

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0