Pete,
If you are trying to connect to an Oracle 7 database then you need to use
the Oracle 9.0 client. Connecting to Oracle 7 from 9.2 is no longer
supported. Any version equal to or less than 9.0.1 will work.
HTH,
Sam Gold
-----Original Message-----
From: Hope Peter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 15, 2005 10:39 PM
To: dbi-users@perl.org
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
