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
