AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com.
Jeff Urlwin just posted today about using the DBD::Oracle build for AS 5.8.4. ----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Roy Niemann [mailto:[EMAIL PROTECTED] Sent: Thursday, June 16, 2005 8:50 AM To: Hope Peter; [email protected] Subject: RE: oracle win2k ORA-1222 problems Aloha (I'm jealous of course if you're in Hawaii), Activestate PERL does not support ORACLE in release 5.8 as far as I can tell. I am having a real problem with that! Go to their web site and they'll list the modules supported / failed during their installation. Oracle is listed as "failed" if I recall correctly. I may be wrong but I have yet to figure out how to get PERL/Oracle to get on speaking terms. It's kinda like my ex-wife. Regards from the East Coast, Roy -----Original Message----- From: Hope Peter [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 15, 2005 10:39 PM 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 This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
