Connect to a database through internet

[Bitaoo]

Hello guys,

I have a Visual Basic 6 program that uses a local
(on the same machine) database. I'd like to put
my database over the Internet and be able to connect
to that database over the 'Net (through a web server
if possible). I know that, I may have to switch
to some other database server for achieving my goal.
Some of my questions are:
- I have heard that DHTML is one of my options. Is
that right?
- What are my other options for doing this?
- What secutiry concerns are there that I should be
aware of?
- If it possible how can I connect to this database?

Thanks for your help,
--Bita

 

[IFRs]

One option would be to set up a VPN, map a drive and go get the file. You could get through the VPN to your data from anywhere.

 

[SemperFiDownUnda]

MySQL doesn't fully have the features I want a RDMS yet. Your options though are dictated by a few things.
1) What RDMS are you talking about?
2) What is the security issues you have?
3) What control do you have over the database server.

Depending on those 3 question would dictate what my solution would be.

For the most part I'd probably concider a web application to access and modify the data. This makes security A LOT easier. You can easily control access to your database and business components. It makes client updates easier as you don't have a client app that needs updating and no user side configuration needed.

Often exposing your a RDMS server direct to the internet is a BAD idea. All it would take is for someone to do a port scan and profile your server. Before you know it your server is comprimised. You might not think anything work hacking is on your server but that will not stop if from happening. So if you can limit your server to only web traffic then you reduce your risk segnificantly.