Ok my Perl friends. I super appreciate your help. The problem is partially solved but more bizarre. I found that the system is duplicating the database file in a directory called... C:\BOXRoot\HarddiskVolume2\inetpub\wwwroot\data

Now, I have no idea what "BOXRoot" is. I did some searching on the Internet. No luck. I do not have dropbox.

The behavior is super crazy but 100% consistent.

If I create the database in the proper directory c:\inetpub\wwwroot\data and run the CGI script it will recreate the database in the c:\BOXRoot\..... directory and INSERT the record correctly. If I do not create the database at all and just plug in some whatever random database name then an empty (0 byte) database will be created in "BOXRoot". That ("0" byte) database does not allow writes.

I have done virus scans and found nothing. This is my dev machine. I know where the directory is now. Although I have no idea where it came from I am going to use as is. My thinking is that I must have mucked up some config setting somewhere.

I thought it only fair to share what I found in the event that someone else comes across the same problem. And, if in teh CGI script I open a filehandle to create a txt file and write to it... well you can guess where it ends up also... BOXRoot. So this is not a SQLite issue.

Thanks again everyone!!!

In reply to Re: Trouble writing to SQLite from CGI on Windows by RedJeep
in thread Trouble writing to SQLite from CGI on Windows by RedJeep

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.