Just wanted to say thanks for all the pointers and tips.
Have been able to get the webserver to connect to the oracle DB.
The issue was in the permissions of the web service itself.  
The IUSR_ and IWAM_ accounts on the server need to have read and execute 
permissions to the ORACLE_HOME directory.  Added the users, forced the 
permissions to replicate to all child files and folders, stopped and restarted 
the web service and everything appears to be working properly.
 
Peter

________________________________

From: Hope Peter [mailto:[EMAIL PROTECTED]
Sent: Wed 6/15/2005 20:38
To: [email protected]
Subject: dbi:oracle win2k ORA-1222 problems



Aloha.

Have just inherited a failed web app.  It originally was running on unix.  Then 
got ported to NT.  Then ported to Win2k.  Client network admins recently 
updated the server and the web application will no longer connect to the 
database.



The web server is a WIN2k w/sp4 box running IIS5, Oracle Client 9.2, 
ActiveState Perl 5.8.6.811, DBI 1.43, DBD-Oracle 1.16, Oraperl 1.44.



The database is Oracle 7 running on a totally different machine.



The scripts running in the web browser come back with a ORA-1222 invalid 
protocol error.

But if I run them from the command prompt, they execute fine.



I found a bit of code that would check all available DBI drivers and their data 
sources.



#!/usr/bin/perl -w

use DBI;

my @drivers = DBI->available_drivers();



die "No drivers found!\n" unless @drivers; # should never happen

foreach my $driver ( @drivers ) {

    print "Driver: $driver\n";

    my @dataSources = DBI->data_sources( $driver );

    foreach my $dataSource ( @dataSources ) {

        print "\tData Source is $dataSource\n";

    }

    print "\n";

}exit;



When this was run from the command prompt I got



Driver: Oracle

    Data Source is DBI:Oracle:Space

    Data Source is DBI:Oracle:GSS



When run from the web page all that comes up is

       Driver: Oracle



I can not figure out why the web version isnt working correctly.

Pete



Reply via email to