Sorry for the top-posting, the original was in HTML.
 
Note the "Access is denied" message.  It's most likely in the dbi-faq and
the DBD::ODBC documentation.  Your IIS user IUSR_XXXX doesn't have
permission to something.  Most likely, at this point, it's the location
where you installed Perl modules, but it probably isn't limited to that.
You will also need to ensure that user can access your database (i.e. you
are using a UNC, the network path is accessible from IUSR_XXXXX, etc).
 
Jeff

-----Original Message-----
From: Jackson, Mark [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 12, 2004 1:50 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: install_driver(ODBC) failed: Can't load 



I have successfully loaded the Activestate Perl on to a Windows NT4.0 Server
with 6a service pack with IIS 4.0. I also have been able to successfully
install DBD::ODBC and to create a system DNS in ODBC. I can run the program
successfully from the Perl editor on the server where Perl is installed.
When the same code is executed from through a web browser I get the
following error:

 

The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are: 

install_driver(ODBC) failed: Can't load
'C:/Perl/site/lib/auto/DBD/ODBC/ODBC.dll' for module DBD::ODBC:
load_file:Access is denied at C:/Perl/lib/DynaLoader.pm line 229.

 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 E:\pps_sid\cgi-bin\tst3.pl line 6

HTTP/1.0 200 OK

 

The following is the test code I used to try and get this to work:

 

print "HTTP/1.0 200 OK\n";

#!/usr/bin/perl

 

use DBI;

 

my $conn = DBI->connect("dbi:ODBC:master","user","testpass")

    or die "Error:$DBI::errstr\n";

    

my $sql = qq(select first,last,ethnic,dob,langsclsco,test_date from gepa
where test_date = 'March 1999');

 

print "$sql \n\n";

 

my $sth = $conn->prepare($sql);

$sth->execute();

 

print DBI::dump_results($sth);

 

To date I still get the same error when executing the above code. Please
note that I am using Perl v5.8.2, DBI version 1.39, and DBD::ODBC driver for
DBI version 1.06. All built for mswin32-x86-multi-thread.

 

Please Help, help would be appreciated.

 

Mark Jackson

[EMAIL PROTECTED]

 

 

 

Reply via email to