in reply to Perl CGI with SQLite Windows and IIS

For starters you may wish to add 

 
use CGI::Carp qw(fatalsToBrowser);

[download]
to get past the bad headers part.

but i suspect that your problem is that when you said I did set the database directory to have rights of Full Control. one of two things were still not right.

first while the directory may have write privileges it may not have also changed all the files in that directory to have write privileges.

but it is more likely that you set up the privileges for your user, while IIS does not run under your userid, instead it runs under another userid. and that userid needs to have the write privileges as well as your userid

Replies are listed 'Best First'.
Re^2: Perl CGI with SQLite Windows and IIS
by RedJeep (Sexton) on Mar 19, 2018 at 20:11 UTC
    @huck,
    Thanks for the reply. I checked and the database file, sample.db, currently has full control for user IIS_IUSERS. I appreciate the help! Any other ideas on what to check?
[reply]

      Write a small test program

      #!/usr/bin/perl    
use strict;
use warnings;
use CGI qw(:standard);  
use CGI::Carp 'fatalsToBrowser';
 
my $dir = "c:/inetpub/wwwroot/data"; 

print header('text/plain');
if ( open my $fh,'>',$dir.'/write.txt' ){
  print "OK : write.txt created in $dir";
  close $fh;
} else {
  print "ERROR : No write permission to $dir"
}

      [download]
      poj
[reply]
[d/l]
        Much better. Solved the rights issue. In Anonymous Authentication switched from "Specific User" to "Application pool identity". Thanks all!!!
[reply]

In Section Seekers of Perl Wisdom