🚀 go-pugleaf

My guess is that your first plan would be slow... very slow... What about a
3-tier solution here?

Build a server application that connects to the database from localhost and
build a client app that connects to the server app...

Martijn Tonies

--

For Delphi Components and InterBase tools:
http://www.upscene.com


<ammar_aganovic@my-deja.com> wrote in message
news:8epqus$i1p$1@nnrp1.deja.com...
> 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.