Hi Simon
To sumarise, the error we get from ODBC is:
Cannot open ODBC connection:-1032[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.
The error occurs at the first attempt to open a link to the DSN using the
following PERL commands:
# open connection to system DSN
$dsn = "databasename";
$infodb = new Win32::ODBC($dsn) ||
die qq{Cannot open ODBC connection:}, Win32::ODBC::Error, qq{\n};
The DSN is created as a SYSTEM DSN with the default settings. and I have
installed the latest MDAC components (actually 2.1.x).
I really can't tell if the problem is to do with file permissions / access
rights or some more obscure ODBC issue relating to Microsoft Access
databases. I granted [full control] as a way of removing the permissions
issue from the equation and still I get this error message. As I'm sure
you can tell I'm new to ODBC but I was able to prototype this system using
the same database and CGI scripts on a client machine running windows 95
and everything worked fine.
Can you suggest any other areas for me to explore?
Thanks for your time
Bill
Message text written by Simon Oliver
>
> I've looked very carefully at the permissions and have granted [Full
> Control] access to both the IUSR and IWAM accounts on the directory
> containing the database .MDB file. I've also granted [Full Control] at
the
> file level as well. Unfortunately I'm still getting the problem of the
ODBC
> driver reporting that my file is locked by another user or I need
> permission to view the data. (Aaaaargh!!!)
Only Change permission is required
>
> Can you tell me what configuration you used to make this work? I'm sure
> that I must be missing something really simple but I don't know what! Are
> there any other directories which need permissions for this to work? I
> have also granted read and write access to the database directory from
> within the IIS server manager.
Don't do that! That allows hackes in and is not required.
>
> We use NT4 service pack 6a, IIS4, The data base was created in Access
'97.
> The database file is in a directory off the root level of the web
> (d:\inetpub\wwwroot\db\filename.mdb). Annonymous access is granted to the
> database directory.
I missed the start of this thread. Are you using a system DSN? Have you
tested
from the command line? What is the exact error message you received?
Have you installed the latest MDAC from microsoft:
http://www.microsoft.com/data/download.htm
--
Simon Oliver
----------------------- Internet Header --------------------------------
Sender: [EMAIL PROTECTED]
Received: from curlew.cs.man.ac.uk (curlew.cs.man.ac.uk [130.88.13.7])
by sphmgaac.compuserve.com (8.9.3/8.9.3/SUN-1.9) with ESMTP id
JAA01719
for <[EMAIL PROTECTED]>; Tue, 9 May 2000 09:20:34 -0400
(EDT)
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 12p9vy-000BmC-00; Tue, 9 May 2000 14:20:22 +0100
Message-ID: <[EMAIL PROTECTED]>
Date: Tue, 09 May 2000 14:25:17 +0100
From: Simon Oliver <[EMAIL PROTECTED]>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Bill Stennett <[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
<
---
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]
