You have no Oracle client installed

I am getting this message “You have no Oracle client installed”

on machine:
Windows 7 Professional 64bit
Oracle 11g R2 (11.2.0) is installed I don’t want to install oracle client.
tnsnames.ora is working fine because Oracle SQL Developer and SQL Plus are working fine.
System variables PATH and ORACLE_HOME are set correctly

Please help me fixing this problem.
Thanks

which binary is producing this error…sqlplus.exe…toad.exe …something else?

Martin Gainty


Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n’êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l’expéditeur. N’importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l’information seulement et n’aura pas n’importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

Toad is a 32 bit application, you need to install 11.2.0 32 bit Oracle client.

You don’t have a choice, if you want to use Toad, you need an Oracle client. SQL Developer is using JDBC…that’s probably why you are seeing a difference.


Hey Martin,

it’s a 64-32 bit problem. Jeff is on the case.

Toad is 32 bit until Delphi becomes able to create 64 bit applications,
we will always have to run Toad against a 32 bit Oracle client. The OP
mentioned that they had installed Oracle 64 bit and didn’t want to
install a separate version of Oracle Client.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk