General discussion

  • Creator
    Topic
  • #2091300

    Oracle Database Connectivity (OO4O)

    Locked

    by nematkhoshini ·

    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.

All Comments

  • Author
    Replies
    • #3878866

      Oracle Database Connectivity (OO4O)

      by astute ·

      In reply to Oracle Database Connectivity (OO4O)

      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.

      • #3878845

        Oracle Database Connectivity (OO4O)

        by nematkhoshini ·

        In reply to Oracle Database Connectivity (OO4O)

        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.

    • #3878791

      Oracle Database Connectivity (OO4O)

      by astute ·

      In reply to Oracle Database Connectivity (OO4O)

      • #3879356

        Oracle Database Connectivity (OO4O)

        by nematkhoshini ·

        In reply to Oracle Database Connectivity (OO4O)

        Hi sharan,

        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.
        =======================================

    • #3879324

      Oracle Database Connectivity (OO4O)

      by astute ·

      In reply to Oracle Database Connectivity (OO4O)

      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

    • #3869546

      Oracle Database Connectivity (OO4O)

      by nematkhoshini ·

      In reply to Oracle Database Connectivity (OO4O)

      This question was closed by the author

Viewing 3 reply threads