LabLynx KB:Setting up Oracle 9i for ASP

From LIMSWiki
Jump to navigationJump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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_SERVICES = (none)
            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