in reply to connect to Oracle through CGI

It helps if you post the error message too. You can probably find it in the error_log file of your webserver.

Replies are listed 'Best First'.
Re: Re: connect to Oracle through CGI
by Anonymous Monk on Jan 03, 2003 at 18:45 UTC
    I'm using Apache so its the usual error of:

    The server encountered an internal error or misconfiguration and was unable to complete your request

    I think it might have something to do with the permission of the oracle directory.... Please help if you can
[reply]
      The *actual* message from the error_log is what everyone is looking for.
[reply]
        sorry about that...I misunderstood. Here is the actual error

        Premature end of script headers: attendance.pl
        DBI->connect() failed: ORA-12640: Authentication adapter initialization failed (DBD ERROR: OCIServerAttach) at C:/Program Files/Apache Group/Apache2/cgi-bin/attendance.pl line 50
        ORA-12640: Authentication adapter initialization failed (DBD ERROR: OCIServerAttach) at C:/Program Files/Apache Group/Apache2/cgi-bin/attendance.pl line 50.

[reply]
        Hi ,

        The Oracle Environment Parameters are not set from with in the CGI when called from HTML , I guess and hence get those Oracle env parameters in a file and require "./oraenv.pl"; in your CGI . This may help recognize the Oracle env. Also see the error message in web server log.

        Regards ,
        Padmaraj K.Shankar (Pad)
[reply]
        The Oracle Environment Parameters are not set from with in the CGI when called from HTML , I guess and hence get those Oracle env parameters in a file and

        require "./oraenv.pl";

        in your CGI . This may help recognize the Oracle env. Also see the error message in web server log.

[reply]

In Section Seekers of Perl Wisdom