Re: Perl CGI with SQLite Windows and IIS

[huck]

For starters you may wish to add

 
use CGI::Carp qw(fatalsToBrowser);

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

[RedJeep]

@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?

[poj]

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"
}

poj

[RedJeep]

Much better. Solved the rights issue. In Anonymous Authentication switched from "Specific User" to "Application pool identity". Thanks all!!!