Simon
Thanks for the suggestions. The DSN-less connection produced the same
results - however logging in to the FILE as administrator I WAS able to
access the database - Permissions!!!
Using the filemonitor utility (thanks to Tim for the suggestion) I noticed
that an access denied error was occuring on the following file create:
c:\WINNT\JETxxx.tmp when logged in as anonymous intrnet user via CGI.
Currently the everyone group (and the internet guest account) has only READ
access to C:\WINNT directory. By granting CHANGE permissions to the
internet guest account the JETxxx.tmp file is successfully created and the
ODBC error I was getting no longer happens!!! I was unaware that the JET
database engine made other temporary files than the .LDB file but you learn
something every day!
I'm not sure whether CHANGE access on the WINNT directory is such a good
idea though. Do you know if there is a way of forcing the Access ODBC
driver to use a different directory for its temporary files.
The last issue relates to multiple access to the database from more than
one script. I use a table within the database to write temporary records
to and with more than one user accessing the script I get a 'file locked'
error back from one of the instances of the script. Do I need to implement
my own semaphore around the "INSERT" and "DELETE" sql statements in my
program or does anyone know of another way to queue requests to the
driver?
Shouldn't the ODBC driver handle multiple concurrent accesses anyway?
Maybe there is something than can be configured in the WIN32::ODBC module?
Thanks .
Bill
===========================================================================
===========
Message text written by Simon Oliver
>
Bill, I find the cannot open the file '(unknown)' very odd. This sounds
like
permissions to me. Have you tried:
1. A DSN-less connection:
$dbq = 'C:\\Program Files\\Microsoft
Office\\Office\\Samples\\Northwind.mdb';
$dsn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=$dbq;";
$db = new Win32::ODBC($dsn)
2. Running the script as another user: Try changing the NTFS permissions
for
the script so that the user must log in. The script will be run as that
user
(try an administrator account). If it works now then you know there is a
problem with permission.
3. You didn't mention the DSN configuration. It doesn't use a UNC path
name
does it?
Also see:
http://support.microsoft.com/support/kb/articles/q174/9/43.asp
http://support.microsoft.com/support/kb/articles/Q166/0/29.ASP
http://support.microsoft.com/support/kb/articles/Q174/8/11.ASP
--
Simon Oliver
---
You are currently subscribed to perl-win32-users as:
[EMAIL PROTECTED]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
----------------------- Internet Header --------------------------------
Sender: [EMAIL PROTECTED]
Received: from listserv.activestate.com (listserv.activestate.com
[199.60.48.6])
by spdmgaaa.compuserve.com (8.9.3/8.9.3/SUN-1.9) with SMTP id
LAA23028
for <[EMAIL PROTECTED]>; Tue, 9 May 2000 11:09:39 -0400
(EDT)
Received: from curlew.cs.man.ac.uk ([130.88.13.7]) by
listserv.activestate.com with SMTP (Lyris Server version 3.0); Tue, 09 May
2000 07:48:35 -0700
Received: from so.bi.umist.ac.uk ([130.88.110.160] helo=umist.ac.uk)
by curlew.cs.man.ac.uk with esmtp (Exim 1.92 #3)
id 12pBIu-000LWy-00; Tue, 9 May 2000 15:48:08 +0100
Message-ID: <[EMAIL PROTECTED]>
Date: Tue, 09 May 2000 15:53:03 +0100
From: Simon Oliver <[EMAIL PROTECTED]>
X-Accept-Language: en
MIME-Version: 1.0
To: "Perl-Win32-Users Mailing List"
<[EMAIL PROTECTED]>
CC: Perl-Win32-Users Mailing List
<[EMAIL PROTECTED]>
Subject: Re: ODBC on WinNT
References: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
List-Unsubscribe:
<mailto:[EMAIL PROTECTED]>
List-Software: Lyris Server version 3.0
List-Subscribe: <mailto:[EMAIL PROTECTED]>
List-Owner: <mailto:[EMAIL PROTECTED]>
X-List-Host: ActiveState <http://www.ActiveState.com>
Reply-To: Simon Oliver <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
X-Lyris-Message-Id:
<LYR145489-57968-2000.05.09-07.48.51--billstennett#[EMAIL PROTECTED]
iveState.com>
Precedence: bulk
X-listname: perl-win32-users
X-ListMember: [EMAIL PROTECTED]
<
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
