Windows

You need not have oracle Instance on the webserver , just Install odbc driver for 8i on the webserver, create a system dsn to the database , use this dns to connect to the database in the asp code ,
hope this helps.

Try this article....

http://www.15seconds.com/issue/000131.htm

I am sure its still because of Security Setting,

Try these approaches :)

1. DLLs Not Accessible by the System Because of Security Setting
When a client requests an Active Server Pages (ASP) page from a server, the ASP page runs in a security context dependant on the authentication method used to access the Web Server. For instance, anonymous requests run in the context of the IUSR_MACHINENAME where MACHINENAME is the name of your computer. For information on other authentication methods and security considerations, please consult the IIS documentation. What this means in terms of an 800a01ad error is that the authenticated user must have access (via NTFS file permissions) to the COM DLL and all of the dependant DLLs.

A shotgun approach can be used to determine if this is the cause of the problem. Using the Windows Explorer, select Properties for the COM DLL, select the Security tab, and grant "everyone" at least read access to the DLL. Do the same for the dependent DLLs anddirectories containing the DLLs. This should eliminate any security restrictions that may be affecting the creation of the COM object. Security can be tightened after it is determined that this was the problem. Keep in mind, many of the dependant DLLs are Windows system DLLs and will have at least "everyone read" access already. Do not mistakenly remove this access when "tightening" the security.

2. Copy the dll to one of the directory of the web server (ex c:\inetpub\wwwroot\anydir) & re register it from that directory. Similar approach has worked for me in my past.


Do let me know, good luck

This question was closed by the author