I am developing an article archive cgi script for a local university. Their web server is on NT and the database is on Oracle. Today, Perl was installed on NT from the most recent version at ActiveState.

That is the basics of what exists, now my code: 

use DBI;
use DBD::Oracle;
use strict;

my $dbh = DBI->connect("dbi:Oracle:host=myhost;sid=mysid", 'foo', 'bar
+') or die "I died: $DBI::errstr";

print "Content-type: text/html\n\n";
print "hey, i made it this far";

[download]

Which results in: 


install_driver(Oracle) failed: Can't load 
'D:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' 
for module DBD::Oracle: load_file:Access is denied 
at D:/Perl/lib/DynaLoader.pm line 200.
 at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or 
dll isn't installed where expected
 at d:\currmktg\test.cgi line 14

[download]

Note, my die statement "I died: $DBI::errstr" did not show up (because it 'die'd before the or?).

The 'Access Denied' part looks promising, but there are no odd permissions (as far as 'permissions' go on NT) on the file or any of its folders.

Maybe the module isn't installed? Nope, I had them checked. It is sitting precisely where it should be. DBI is where it should be too.

A correct and full installation of SQL*Net is on the machine as well. Not that may or may not have been brought up, I just want to cover some possible bases.

The project was going to be done in ColdFusion, but I convinced them to use Perl for two reasons: I know more Perl than ColdFusion, and Perl is the right tool for this job.

Now, before they installed Perl, they had set up a DSN on the machine so ColdFusion could connect to the database via ODBC. That DSN wouldn't have been able to been set up without the proper SQL*Net tools available.

Should I, for the sake of moving forward, have them install the Perl ODBC module and try connecting that way? If I did, what would be the performance loss/gain over a fixed installation of DBD::Oracle?

Thanks for any help.

--
notsoevil
--
Jeremiah 49:32 - And their camels shall be a booty. . .

In reply to Oracle and Perl by notsoevil

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.