I have a requirement to access an Oracle 8i DB (installed on NT server) using Active Server Page on a client machine (also NT server) which does not have an Oracle instance. Both servers are part of a TCP/IP network. What is the best way to accomplish this? Furthermore I downlaoded and installed OO4O81638.exe and OO4O81638full.exe from Oracle site and tried both, but non of them work.
This conversation is currently closed to new comments.
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.
When I tried to install odbc driver, I got the following error message:
The oracle client and networking components were not found. These components are supplied by oracle corp. and are part of the oracle v 7.3 (or greater) client s/w installation. You will not be able to use this driver until these components have been installed.
I tried the example in the article, however I still get the following error on the Server.CreateObject() statement. I checked the corresponding DLL (OIP8.DLL), it exists and is properly registered and oracle home directory is accessible by IIS (no security issue). ======================================= error 'ASP 0115' Unexpected error
/oo4odemo2.asp A trappable error occurred in an external object. The script cannot continue running. Server object error 'ASP 0115 : 8000ffff' Unexpected error /oo4odemo2.asp, line 13
A trappable error occurred in an external object. The script cannot continue running. =======================================
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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Oracle Database Connectivity (OO4O)