Re: DBD Oracle connectivity
[email protected] (Alexander Foken)
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
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 > <[email protected]>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 > > >