SERVICES Hi, all

I've been running an (internal) enterprise app on PerlEx for the last 4
or 5 years.  We're looking to re-release the app with some updates and
want to move the OS, etc to a more recent release.

To that end, I'm building a test box, Windows 2003 Server, running IIS.
I've installed the latest ActiveState Perl package, 5.8.8.817, including
the perlex components.

Running the example/benchmark perlex scripts do work.

I've installed DBI and DBD::Oracle, using ppm.

I've now placed my app in and tried to run and get errors loading
Oracle.  I'm fairly certain I'm missing some environment variable or
something, somewhere.  The sample script (shown below), works correctly
on my old server.


I've produced a simple sample script : 

-------------------sample script----------------------

#  Test program 
use strict;
use dbi;

print "Content-type: text/html\n\n";

my $oradbh;
eval {
	$oradbh = DBI-> connect( "dbi:Oracle:zzzzzz.world", "yyyyyy",
"xxxxx",{ AutoCommit =>  0, RaiseError => 1, PrintError => 0, LongReadLen
=>  200000, LongTruncOk => 1 } );
}; if ($@) {print "Failed to connect to Database : $@";}
else {

	print "Connected to Oracle data connection\n";

	my $sth = $oradbh-> prepare("SELECT sysdate FROM dual");
	$sth-> execute();

	my ($date) = $sth-> fetchrow_array();

	$sth-> finish;
	$oradbh-> disconnect;

	print "Date from Oracle : $date\n";

}

print "All done";

------------------end script-----------

The output I get from this script when run through PerlEx is :

Failed to connect to Database : install_driver(Oracle) failed: Can't
load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module
DBD::Oracle: load_file:Access is denied at C:/Perl/lib/DynaLoader.pm
line 230. at (eval 7) line 3 Compilation failed in require at (eval 7)
line 3. Perhaps a required shared library or dll isn't installed where
expected at c:\intracgi\hris-chris\testconnect.plex line 9 All done


When I run it standalone (from the dos prompt), I get : 

Content-type: text/html

Failed to connect to Database : DBI connect('dvhris.world','dvhris',...)
failed:
 ORA-12705: Cannot access NLS data files or invalid environment
specified (DBD E
RROR: OCISessionBegin) at c:\intracgi\hris-chris\testconnect.plex line 9
All done
_______________________________________________
PerlEx mailing list
PerlEx@[...].com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs