A few days ago I have been experimenting with DBD::ProxyServer and I would try to say something about it. Much more dense information is found at the documentation of DBD::Proxy, DBD::ProxyServer, dbiproxy, and related.
To access a RDBMS via DBD::Proxy driver, you need a machine running
a DBD::ProxyServer (or simply the script dbiproxy which creates and
invoke a DBD::ProxyServer). The machine where ProxyServer runs
provides all the DBI drivers to talk to the RDBMS you are interested.
This way when the client passes its SQL statements via DBD::Proxy,
they reach the ProxyServer to be sent via the appropriate DBD to the database servers and the results make the same way back
to the original requester. Performance can suffer, but it is
wonderful for the kind of situation you are: need to reach a RDBMS
from a machine which has no client for this. ProxyServer provides
the bridge.
Read the documentation of DBD::ProxyServer and dbiproxy, choose a machine where this will run, test locally, test from other Windows machines, test from Linux boxes, and that's it. I think you will find this process very fast and easy.
Good luck, Adriano.
On Wed, 9 Jul 2003 17:19:16 +0530 (IST), Anil Menon <[EMAIL PROTECTED]> wrote:
Hi,
How does DBD:ProxyServer talk to a DBDMS (on windows platform) ? Does it talk
straight with the DSN specified for the DBMS or is there a intermediate
layer/Driver which do the communication. We have proprietary DB which has
drivers for Windows, but not for linux and these (drivers) are not maintained
anymore. My req is communicate to this DB thru the Perl(from linux box). I did
RTFM, but was really confused about this (communication) part. I have no exp
working on perl/windows env. Where can i find some more info regarding this ?
