LabLynx KB:Setting up Oracle 9i for ASP

From LIMSWiki
Revision as of 18:28, 30 September 2011 by Shawndouglas (talk | contribs) (Created article.)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

How to set up ASP for Oracle 8i or 9i

These are the steps to getting ASP working with a new install of Oracle 8i or 9i:

1. Reboot the server at least once after installing either IIS or Oracle.
2. Add the following entries to sqlnet.ora (typically c:\oracle\ora92\network\admin\sqlnet.ora) and save:
            SQLNET.AUTHENTICATION = (none)
3. Give the users IUSR_MachineName and IWAM_MachineName full security rights to the Oracle home folder (typically c:\oracle). Also, be sure to check the reset permissions on all child folders.
4. Reboot the machine.

Further reading

Microsoft Knowledge Base: How To Troubleshoot an ASP-to-Oracle Connectivity Problem

Related questions