Does Quest Code Tester work with Oracle Instant Clients? (4310377)

Does Quest Code Tester work with Oracle Instant Clients?

Quest Code Tester for Oracle does not support Oracle Instant Clients, however it is possible to get it to work with some restrictions. It must be the only client installed on the machine. If you have more clients, they will not display in the client drop down menu when connecting to QCTO.

1. Unzip your Oracle Instant Client 10g or 11g into a directory, for example C:\instantclient.
2. Add the Instant Client directory to the environment PATH variable:
    a) Right mouse click the my computer icon  |  Properties | Environment Variables.
    b) Under System variables, find PATH, click Edit, and add C:\instantclient;
    c) This should be enough to allow Code Tester via Instant Client using Direct mode.
3. If you want to connect using TNSNAMES, then you must add TNS_ADMIN variable to the  System variable.
    a) Right mouse click the my computer icon  |  Properties | Environment Variables.
    b) Under System variables, click on New
    c) For the variable name, enter "TNS_ADMIN" and for value enter the path to the TNSNAMES.ORA file.
4. Another good idea is to add  "NLS_LANG" in the Environment Variables to match the database, such as AMERICAN_AMERICA.WE8MSWIN1252