Re: Update Access table from Perl script via ODBC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: messengertj (messengertj_at_discussions.microsoft.com)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 09:17:01 -0800

I've checked "No" in response to "Was this helpful" but that's not entirely
fair.

It had occurred to me on my own that I was adding an unnecessary layer by
running my Perl script as a CGI script through IIS and that I might have
better permissions running it as a straight Perl script that didn't use an
HTTP server. This has proved to be case -- now successful with UPDATE. Your
message made it seem more likely that I should try this. So thanks for that
encouraging word. (I was using IIS to get scrollable output as an HTML page.
 There are too many lines to scroll in a command window. Of course, I can
redirect to a file and look at that.)

BUT your message lacked the words-of-one-syllable instructions I'd need to
set permissions for IUSR_machinename. With what, exactly, do I do this and
where, exactly do I find IUSR_machinename? Though I don't actually need it
for the present, I'd like to know how just in case.

"Douglas J. Steele" wrote:

> I don't know anything about web programming with Perl, but with ASP, you
> need to ensure that the ID under which ASP is running (typically
> IUSR_machinename) has full access (Read, Write, Delete and eXecute) on the
> folder where the MDB file is located.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "messengertj" <messengertj@discussions.microsoft.com> wrote in message
> news:CF27D52F-CF37-4F71-AD05-3CC69C236DF4@microsoft.com...
> > I'm trying to update an Access table from a Perl script with DBI and
> > DBD::ODBC. (There is serious number crunching involved that I already
> > have
> > programmed in Perl, and I haven't used Basic for anything much in 35
> > years.)
> > To my surprise I didn't have much trouble connecting. SELECT works fine
> > too,
> > but UPDATE gives me the "Operation must use an updateable query" message.
> > Since this is a simple one-table update, it's the permissions problem, not
> > the cross tabs problem. As a newbie to Access, I'm unfamiliar with
> > setting
> > permissions in it -- somewhere in the Windows XP, DSN, Access chain I
> > don't
> > have write permission. Or maybe it's the Internet Guest account. (This
> > same
> > query works fine on a MySQL database where I understand the permissions
> > better.) Help! And words of one syllable please. (The Read Only box is
> > NOT
> > checked in the DSN.)
>
>
>

Relevant Pages

  • RE: VBScript to audit shares and share permissions
    ... these shares aren't published in AD to my knowledge so I think I'm ... file system level (and maybe some other permissions). ... Free time? ... You can use a Perl script that produces the same output, ...
    (Focus-Microsoft)
  • Update Access table from Perl script via ODBC
    ... I'm trying to update an Access table from a Perl script with DBI and ... Since this is a simple one-table update, it's the permissions problem, not ... the cross tabs problem. ... checked in the DSN.) ...
    (microsoft.public.access.externaldata)
  • Re: Update Access table from Perl script via ODBC
    ... Recognize that user ids and permissions are part of the operating system, ... > running my Perl script as a CGI script through IIS and that I might have ... >> Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.externaldata)
  • Re: problem after upgrade
    ... If I understand your perl script is creating directories and files. ... Check your NTFS permissions. ... you will have to e.g. five IUSR_account permissions to create ... these files and folders (it does depend on how you wrote your script -- but ...
    (microsoft.public.inetserver.iis.security)
  • Re: executing a file
    ... I had gotten the perl script working standalone ... Doug Steele, Microsoft Access MVP ... My command now has quotes as per your example. ...
    (microsoft.public.access.formscoding)