please let me add a few things to what Franz wrote (I use a similar
approach to access databases that have no public access):
- you don't need any ODBC driver in that case
- please beware that you have a public access to the database then.
First, use a SSL connection, and second, protect the access with a
- since you don't need any ODBC driver, you don't have to configure
anything on the client machines
Every time when it comes to connections over the internet, security has
to be the most important issue!
Sometimes it may be better to build a webservice to interact with your
internet application, maybe up- and downloading CSV, XML or JSON files
(but always use password protection and SSL).