GIFTS Connections communicates with the Oracle database using Microsoft Internet Information Services (IIS). This error occurs if the user account used by IIS for anonymous communication with the database does not have sufficient access rights to directories on the Oracle server. Most likely, the anonymous user has rights to the main Oracle directory but those rights need to be propagated to all of the directories within that directory (its “child” directories).

To resolve the error, use the following procedure to propagate the appropriate access rights to all of the Oracle subdirectories:

1.      Log in to computer that is being used as your Oracle server.
2.      Right click on the C:\Oracle directory and choose Properties from the menu.
3.      Go to the Security tab of the directory’s properties.
4.      Ensure that the user account used by IIS for anonymous access is listed as having Full Control. (If not, click Add and grant full control to the anonymous IIS user.)
5.      Click the Advanced button at the bottom of the window.
6.      Select the option to Replace permission entries on all child objects with entries shown here that apply to child objects.
7.      Click OK. Windows® prompts you to confirm that you want to change the permissions on for child directories.
8.      Click Yes. Permissions for the directory are propagated. Note that the process may take some time.
 

MyGIFTS should now be able to connect to the Oracle database.