Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: DBI Oracle and our pal IIS

by BBQ (Deacon)
on Jun 08, 2000 at 03:05 UTC ( #16984=note: print w/replies, xml ) Need Help??


in reply to DBI Oracle and IIS

Try adding some of the below to you're script before you actually connect to the database.
# where you're Oracle home is $ENV{'ORACLE_HOME'} = 'E:/Oracle/OAS408'; $ORACLE_HOME = $ENV{'ORACLE_HOME'}; # if you use Oracle Application Server 4.x or > $ORAWEB_HOME = "$ORACLE_HOME/ows/4.0"; # if you want and chars of the sort. $ENV{NLS_LANG} = 'american_america.we8iso8859p1'; $ENV{ORA_NLS} = "$ORACLE_HOME/ocommon/nls/admin/data"; $ENV{ORA_NLS32} = "$ORACLE_HOME/ocommon/nls/admin/data";
It seems that the IUSR_MACHINE user doesn't know where to find Oracle Pro*C. You do have Pro*C installed, don't you?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://16984]
help
Chatterbox?
[chacham]: the same thing could be achieved with a trigger
[LanX]: choroba yes
chacham shudders at the thought of using a trigger...so evil
LanX will need to find a Perl workaround ... :-|
LanX leaving his cave to enjoy sun! *\o/*

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (6)
As of 2017-03-30 15:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (360 votes). Check out past polls.