No, even with DBD::ODBC you need an Oracle client, not for DBD::ODBC
itself, but the ODBC manager needs one. Windows comes out of the box
with a prehistoric Oracle client that causes more trouble than it is
worth, so even there, you want to install a RECENT Oracle client.
The only way to avoid installing an Oracle client on a specific machine
is to use another machine with an installed Oracle client as a proxy,
using DBD::Proxy or DBD::Gofer, or some other proxying code.
Alexander
John Scoles wrote:
I guess you could use DBD::ODBC that does net require an oracle client.
cheers
John Scoles
On Fri, Jul 16, 2010 at 4:50 AM, Martin J. Evans
<martin.ev...@easysoft.com>wrote:
Vinod Guleria wrote:
Dears,
Could you pls let me know that Is there a way to connect to oracle DB(on
remote system) without having oracle client on my system.
Thanks & Regards,
Vinod Guleria.
If you are absolutely sure you cannot install any Oracle software on
your machine you need to search for Oracle Wire Protocol drivers.
However, none of these are made by Oracle and if Oracle change the
network protocol they will probably stop working until you can get an
update from the manufacturer. Also, these WP drivers don't tend to
support encryption, XA, failover etc and many other features you get
with the Oracle client.
A better bet in my opinion is to install Oracle Instant Client. It is a
relatively small download and can be installed anywhere - you do not
need root permission.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
--
New! Learn why & how to love your data with Pythian's new webinar series.
Topics, details & register: http://www.pythian.com/webinars
