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]
