Thanks for the reply
My database is definitely set up as a system DSN. So I don't think that is
the problem although I will double double check!
Is it necessary to have Microsoft Access itself installed for this to work?
I thought not but I'll try anything to get to the bottom of this one.
Thanks
Bill
Message text written by "Conrad Classen"
>
Check that the DSN configured on the MT machine is done using a 'System'
DSN
and
NOT a 'User' or 'File' DSN. This must be done with Administrator rights.
CHC
----- Original Message -----
From: "Bill Stennett" <[EMAIL PROTECTED]>
To: "Perl-Win32-Users Mailing List"
<[EMAIL PROTECTED]>
Sent: Saturday, May 06, 2000 2:59 PM
Subject: ODBC on WinNT
Hi all
We have developed a simple database script in Perl to interogate a database
by linking to the Microsoft Access ODBC driver using the Win32::ODBC
module. We are running perl build 613. and have installed latest Data
Access Components (2.1.x.x.x) for NT and '95
When I run this script on a Win95 Platform using PWS everything is as it
should be. However when I port it to the NT4 server running IIS4 I get an
error message back from Win32::ODBC saying "
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 commands:
# open connection to system DSN
$dsn = "databasename";
$infodb = new Win32::ODBC($dsn) ||
die qq{Cannot open ODBC connection:}, Win32::ODBC::Error, qq{\n};
There are no other users on this test machine and for testing purposes I
have granted as many rights as I can think of to see if it makes any
difference - but no luck!
I guess my question boils down to whether anyone has experienced a similar
problem setting up a perl link to a windows NT ODBC Access database and if
anyone could direct me towards possible causes.
Any suggestions much appreciated
Thanks
Bill Stennett
---
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]
---
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 spdmgaac.compuserve.com (8.9.3/8.9.3/SUN-1.9) with SMTP id
GAA00952
for <[EMAIL PROTECTED]>; Sun, 7 May 2000 06:46:20 -0400
(EDT)
Received: from chc.co.za ([196.38.236.177]) by listserv.activestate.com
with SMTP (Lyris Server version 3.0); Sun, 07 May 2000 03:43:11 -0700
Received: from LYNNE [196.34.156.134] by chc.co.za
(SMTPD32-5.05) id A727873E029C; Sun, 07 May 2000 12:42:31 +0200
Message-ID: <003101bfb810$bcbec670$[EMAIL PROTECTED]>
From: "Conrad Classen" <[EMAIL PROTECTED]>
To: "Perl-Win32-Users Mailing List"
<[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Subject: Re: ODBC on WinNT
Date: Sun, 7 May 2000 12:41:00 +0200
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
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: "Conrad Classen" <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
X-Lyris-Message-Id:
<LYR145489-57686-2000.05.07-03.43.15--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]