SERVICES Thanks, Graham.  I didn't quite understand this part - add which?

>  And that running it through PerlEx you *may* have to also add that to
>  your BEGIN block . You certainly will if its running on over HTTP or
>  something like that.

I've made some progress since my post, though :)

The Oracle client version on the machine is 9.2 (which matches the
database that we're connecting to).  I downloaded the Oracle DBD through
ppm

The command line now runs correctly - I had to set NLS_LANG and a few
other things, but it works fine now.  However, running the exact same
program from perlex still fails.  This hints to me that it is a problem
with environment variables.

I've added commands to spit the environment out, for reference.  PerlEx
now gives :

-----------------sample output----------------------------------

USERPROFILE = C:\Documents and Settings\Default User
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_HOME = C:\oracle\ora92
COMMONPROGRAMFILES = C:\Program Files\Common Files
PERLXS = PerlEx
TNS_ADMIN = c:\oracle\ora92\network\admin
PROGRAMFILES = C:\Program Files
OS = Windows_NT
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
NUMBER_OF_PROCESSORS = 1
FP_NO_HOST_CHECK = NO
PATH = c:\perl\bin;C:\oracle\ora92\bin;C:\Program
Files\Oracle\jre\1.3.1\bin;C:\Program
Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\Sys
tem32\Wbem
GATEWAY_INTERFACE = CGI-PerlEx
PROCESSOR_ARCHITECTURE = x86
TEMP = C:\WINDOWS\TEMP
SYSTEMDRIVE = C:
PROCESSOR_REVISION = 0102
SYSTEMROOT = C:\WINDOWS
COMSPEC = C:\WINDOWS\system32\cmd.exe
WINDIR = C:\WINDOWS
WF_RESOURCES = C:\oracle\ora92\WF\RES\WFus.RES
CLUSTERLOG = C:\WINDOWS\Cluster\cluster.log
PROCESSOR_LEVEL = 15
PERLHOST = PerlEx
PROCESSOR_IDENTIFIER = x86 Family 15 Model 1 Stepping 2, GenuineIntel
APP_POOL_ID = DefaultAppPool
COMPUTERNAME = HQNTHRISDEV
ALLUSERSPROFILE = C:\Documents and Settings\All Users
TMP = C:\WINDOWS\TEMP
Failed to connect to Database : DBI connect('dvhris','dvhris',...)
failed: ORA-12154: TNS:could not resolve the connect identifier
specified (DBD ERROR: OCIServerAttach) at
c:\intracgi\hris-chris\testconnect.plex line 22 All done 

_______________________________________________
PerlEx mailing list
PerlEx@[...].com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs