🚀 go-pugleaf

I need to make a database residing on MySQL available to custom
developed software which would be able to access the database directly.
The most elegant solution would be to simply add a System DSN in ODBC
sources with MySQL driver, and access the database through DSN. The
problem is the proveider would not let a user to connect from host
other then localhost (security reasons). So I need to improvise.

I am thinking of delivering a DB through HTTP. I though a perl script
would be able to read the MySQL tables, and output them to for example
access file. The file would be then send via http protocol, and the
software at the client side would then process the access db, make the
changes, modify the access file and send back. Or I could even do some
streaming (both Client & Server side). I thought of using Perl & Delphi
to accomplish that, but would be very gratefull if U could help me with
some modules & units I could search for.



P.S. does anyone know how to drive a ODBC connection through secure
channel? I did manage to use a portmapper (or something like that) to
reroute the connection through previously established secure line (with
TTerm & TTsh), but I found no way to automatise the process.


Sent via Deja.com http://www.deja.com/
Before you buy.