Good points!

As for the compile, this is on an NT box, so we just used install DBD::Oracle from the ppm command line.

Here's the full story. I thought I could get by with a focused instance, but it appears not:

We had a site developer trying to connect to an Oracle database and draw out some information from a table. He was getting an error similar to the one above. Almost word-for-word, actually. We copied his code, specifically his 'use DBI' line and his DBI connect statement, including the authentication stuff. When we put it into our own script in another area, without anonymous access turned on, and without our anonymous user having NTFS permissions, it worked, after we authenticated. When we looked at his again, it didn't work. We put our script in his area, and it didn't work. We turned off anonymous access, and after login, it worked. I'm not an NT expert. I'd prefer to use Apache, mod_perl, and Linux any day, and twice on Sundays, but this is not my box. This does, however, appear to be an NTFS permission, possibly regarding the anonymous user and the rights of the anonymous user somewhere inside perl or orant directories. We've temporarily awarded full control to the anonymous user and, to be sure, the Everyone group. Still, no love.

Added:

We have a script that gives us clues as to where things occur. We 'use DBI;', print out some html code, and say something along the lines of "Starting to connect to database...". Then try to connect to the database with uid, passwd, etc. This allows our developers to get a better idea of where things are failing. When I say developers, I mean site developers, not really hard-core perl people. We did do things by the book, at first, but as things have progressed, we have tried to distill the problem a bit, and this is really what you see. Thanks,

Any ideas? 

J. J. Horner
Linux, Perl, Apache, Stronghold, Unix
jhorner@knoxlug.org http://www.knoxlug.org/

In reply to (jjhorner)Re: (Ovid) Re: (jjhorner)Re: (Ovid) Re: DBD::Oracle issues by jjhorner
in thread DBD::Oracle issues by jjhorner

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • 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:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, 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, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.