LabLynx KB:Setting up Oracle 9i for ASP

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.

This is an article specific to the Category:LabLynx knowledge base. Its context outside of LabLynx, Inc may not be apparent, thus why it appears inside the LabLynx KB namespace.

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.