Geeks With Blogs


Locations of visitors to this page

View ► Sanjay Uttam []'s profile on LinkedIn

Add to Google Reader or Homepage

Sanjay Uttam Predominantly .NET

At first, I thought migrating a classic ASP app formally running on win2k/IIS5 would be a 5-10min no brainer.  Here I am approximately 2 hous later, and I just got it working. 

So after you do all the basic stuff like create your virtual directory, and install your db client software..this is the tricky part

I received the following error:

oracle ADODB.Connection error '800a0e7a'

This is what resolved it for me:

1. Log on to Windows as a user with Administration privileges.
2. Launch Windows Explorer from the Start Menu and navigate to the ORACLE_HOME folder. This is typically the "Ora92" folder under the "Oracle" folder (i.e. D:\Oracle\Ora92).
3. Right-click on the ORACLE_HOME folder and choose the "Properties" option from the drop down list. A "Properties" window should appear.
4. Click on the "Security" tab of the "Properties" window.
5. Click on the "Authenticated Users" item in the "Name" or "Group or user names" list.
6. Uncheck the "Read and Execute" box in the "Permissions" or "Permissions for Authenticated Users" list under the "Allow" column.
7. Re-check the "Read and Execute" box under the "Allow" column (this is the box you just unchecked).
8. Click the "Advanced" button and in the "Permission Entries" list make sure you see the "Authenticated Users" listed there with:
Permission = Read & Execute
Apply To = This folder, subfolders and files
9. I checked the "Replace permission entries on all child objects with entries shown here that apply to child objects" checkbox and clicked the "Apply" button. (This was not specified in the original instructions, but it worked.)
10. Click the "Ok" button until you close out all of the security property windows. The cursor may present the hourglass for a few seconds as it applies the permissions you just changed to all subfolders and files.
11. Reboot your computer to assure that these changes have taken effect.
12. Re-execute the application and it should now work.


Posted on Thursday, August 17, 2006 6:57 PM Classic ASP | Back to top

Related Posts on Geeks With Blogs Matching Categories
Copyright © Sanjay Uttam | Powered by: