When launching MyGIFTS in an Oracle 10g database environment, users may receive an error similar to the following:
Error occurred while opening database.
Technical Support Info: [DatabaseOpen] Error #-2147467259 [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Technical Support Info: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectATTR failed
GIFTS Connections, which handles MyGIFTS and ReviewerCONNECT, communicates with the Oracle database using Microsoft Internet Information Services, or 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, otherwise known as 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 so, proceed with step 5. 4a. If this is not the case, click Add and grant full control to the anonymous IIS user. 5. With the user account from step 4 highlighted, click the Advanced button at the bottom of the window, then click Change Permissions. 6. Select the option to Replace permission entries on all child objects with entries shown here that apply to child objects, then click OK . 7. Windows® prompts you to confirm that you want to change the permissions on for child directories, please click Yes.
Once the process is complete, permissions for the directory are propagated. MyGIFTS should now be able to connect to the Oracle database. Please note that the process may take some time to finish.
As always, if these recommended steps do not resolve the issue, please contact MicroEdge Help Desk at 877-704-3343 or at HELPDESK@microedge.com