Access to DB from internet in a windows form application

Question

0.00/5 (No votes)

See more:

hello

in a

windows form application

i put my db on a local server.

1- is it possible put db in my host in internet, and access to it by my

windows form application

?

2- is it possible to set an IP for local server then install my

windows form application

in a client in internet (no local net) and access to same db from internet? (db on same local server)

thanks

What I have tried:

i don't test them. i don't know is it possible or not.

Posted 28-Oct-18 2:12am

Member 13522501

Updated 2-May-21 1:08am

Add a Solution

2 solutions

Solution 2

You can access internet DB from winforms apps, yes - but it's dangerous because it exposes your DB to anyone who can find it, and you have to be careful about security. Personally, I'd add a service to the internet domain and interface to that instead of direct to the DB. The cloud is another possibility, but similar security problems exist.

Having said that, many companies do access their DB's via the internet, so you will find a lot of info if you google.

Accessing your local DB from the internet is possible, but strongly not recommended - security becomes even more of a nightmare, and if you have a dynamic IP address then it is going to fail at some point. I'd advice against it.

Posted 28-Oct-18 2:57am

OriginalGriff

Comments

Member 13522501 28-Oct-18 10:48am

how security of db in internet web sites is provided?

OriginalGriff 28-Oct-18 10:58am

Depends: mostly by keeping the DB on the server side, and accessing it via Server code, not client. That way, the user has no direct access to the DB system at all.

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)

Mehdi Gholam · Accepted Answer · 2018-10-28T02:22:00

Solution 1

Yes it is possible.

But you should never put your database on the internet (without protection, which is an advanced topic that you can easily get wrong so you should not do it anyway).

Posted 28-Oct-18 2:22am

Mehdi Gholam

Comments

Member 13522501 28-Oct-18 8:56am

is there necessary protection provided for db in my host (by host service)?

Mehdi Gholam 28-Oct-18 9:30am

It depends on your host service provider, but probably the protection they provide is not putting the database on the internet in the first place.