feeljas.blogg.se - Toad for oracle no valid oracle clients found

Running the ODBC driver from the command prompt will allow you to see if it installs successfully. All files (Client and Drivers) needed to be in the same folder (nothing in sub-folders). Note: The "un-documented" things that were hanging me up where.

Use command prompt to run "odbc_install.exe" (should say it was successful).

Copy all files into same folder as client "C:\instantclient".

reboot or use Task Manager to kill "explorer.exe" and restart it to refresh the PATH environment variables.

I had to create a "tnsnames.ora" file because it doesn't come with one.

Add new Variable called "TNS_ADMIN" point to same folder as Instant Client.

Edit PATH evironment variable, add path to Instant Client folder to the Variable Value.

Put contents in folder like "C:\instantclient".(I think there's another step or two if your using 64-bit) Setting up Oracle Instant Client-Basic 11g2 (Win7 32-bit) You can Google examples and copy/paste into a text file, change the parameters for your environment. Note: you'll need a 'tnsnames.ora' file because it doesn't come with one. I was able to setup Oracle Instant Client (Basic) 11g2 and Oracle ODBC (32bit) drivers on my 32bit Windows 7 PC. The registry keys are now displayed for selecting the oracle client: ORACLE_HOME_NAME = MY_INSTANTCLIENT (choose any name)įor those who use Quest SQL Navigator or Quest Toad for Oracle will see that it works.ORACLE_HOME = c:\oracle\instantclient (the same folder in PATH).NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252 (complete list here: ).Windows 64bit: ĥ) In the above registry key, create a sub-key starts with "KEY_" followed by the name of the installation you want:Ħ) Now create at least three string values in the above key:.How?Ģ) Unzip the ZIP file (eg c:\oracle\instantclient). But you can "install" manually to create some keys in the Windows registry. The instantclient works only by defining the folder in the windows PATH environment variable.