I had same problem. Solution was to give Read & Execute permissions to the c:\orant directories to the network/local account that the web server uses. The perl scripts need to go outside of the perl directories to use Oracle stuff, so give the web server permission to execute the Oracle stuff.
The reason it worked from the command line was that I was using my own network account that already had permissions to the Oracle directories.
Up until recently, I did troubleshooting by logging on to the web server using the account that the web server uses. Then use Windows Explorer to verify that the web server can see the same things I can see when logged in as myself. A recent "lockdown" tool removed the ability to log on locally to the web server itself, but I can still log on to another computer and do the testing.
Hey, my first post! FirstCool
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||