|Keep It Simple, Stupid|
Oracle and Perlby notsoevil (Pilgrim)
|on Mar 28, 2001 at 21:40 UTC||Need Help??|
notsoevil has asked for the wisdom of the Perl Monks concerning the following question:
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:
Which results in:
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.