|
 |
asp_databases thread: Microsoft JET Database Engine error '80004005'
Message #1 by "Dennis Lai" <wise@a...> on Sat, 22 Sep 2001 04:10:17
|
|
Can anyone suggest a solution to this error:
Microsoft JET Database Engine error '80004005'
The Microsoft Jet database engine cannot open the
file '\\2ndpc\data\123X.mdb'. It is already opened exclusively by another
user, or you need permission to view its data.
/mindy.asp, line 3
I have 2 pcs both using Win2k Server(NTFS)
1ST PC
There is a file called 123X.mdb. The folder in which the file resides is
shared. Security settings for both the folder and file has been set to
include everyone (last resort in a bid to get it to work!).
2ND PC
I am attempting to access 123X.mdb from this pc. I have no problems when I
attempt to access it's data using VB or EXCEL via VBA. However, If I
attempt to access this file using ASP via 2nd PC IIS, I always encounter
the above error message.
I am certain that there is nothing wrong in the type of connection or the
connection string as I have tested them out in VB and VBA and it works
perfectly fine. I have tried all kinds of connection method:
1) ADO (OLEDB)
2) ODBC (DSN)
3) ODBC (DSN-less)
Just to confirm that there is that the connection method/string is not the
cause of the above error message, I deliberate change the string and IIS
displayed a different error message.
As for the path, I have tried the following:
1) Mapping the shared folder as a Drive in the 2nd PC and specifying it
like I:\data\123x.mdb.
2) Including the pc name/ip in the path like \\2ndpc\data\123x.mdb or
\\10.7.1.246\data\123x.mdb
There is also nothing wrong with the path as both methods work in VB and
VBA. When I deliberately change the path, IIS displayed a different error
message. So I am certain the path is not the cause of the above messge
From the error message, I am quite sure it is a Win2K security setting
issue. Moreover I am only denied access using the 2nd PC IIS but no
problem when attempting to access it using VB or VBA.
Can anyone please help?
Message #2 by "Dallas Martin" <dmartin@z...> on Sat, 22 Sep 2001 09:48:49 -0400
|
|
When you access the Access db from VB or Excel, you are accessing it as an
authenticated user. That is, your log-on to the 2ndPC is being authenticated
by
the 1stPC.
Now when you attempt to access the db from within ASP, the IIS webserver
is using the IUSR_machinename account to access the db. This is where the
attempt is failing. The problem is that the IUSR_machinename account which
IIS is using is not being authenticated by the 1stPC. You need to establish
a W2K account on the 1stPC for the IUSR_machinename logon.
Dallas
----- Original Message -----
From: "Dennis Lai" <wise@a...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, September 22, 2001 4:10 AM
Subject: [asp_databases] Microsoft JET Database Engine error '80004005'
> Can anyone suggest a solution to this error:
>
> Microsoft JET Database Engine error '80004005'
>
> The Microsoft Jet database engine cannot open the
> file '\\2ndpc\data\123X.mdb'. It is already opened exclusively by another
> user, or you need permission to view its data.
>
> /mindy.asp, line 3
>
>
> I have 2 pcs both using Win2k Server(NTFS)
>
>
> 1ST PC
> There is a file called 123X.mdb. The folder in which the file resides is
> shared. Security settings for both the folder and file has been set to
> include everyone (last resort in a bid to get it to work!).
>
> 2ND PC
> I am attempting to access 123X.mdb from this pc. I have no problems when I
> attempt to access it's data using VB or EXCEL via VBA. However, If I
> attempt to access this file using ASP via 2nd PC IIS, I always encounter
> the above error message.
>
>
> I am certain that there is nothing wrong in the type of connection or the
> connection string as I have tested them out in VB and VBA and it works
> perfectly fine. I have tried all kinds of connection method:
>
> 1) ADO (OLEDB)
> 2) ODBC (DSN)
> 3) ODBC (DSN-less)
>
> Just to confirm that there is that the connection method/string is not the
> cause of the above error message, I deliberate change the string and IIS
> displayed a different error message.
>
>
>
> As for the path, I have tried the following:
>
> 1) Mapping the shared folder as a Drive in the 2nd PC and specifying it
> like I:\data\123x.mdb.
> 2) Including the pc name/ip in the path like \\2ndpc\data\123x.mdb or
> \\10.7.1.246\data\123x.mdb
>
> There is also nothing wrong with the path as both methods work in VB and
> VBA. When I deliberately change the path, IIS displayed a different error
> message. So I am certain the path is not the cause of the above messge
>
> >From the error message, I am quite sure it is a Win2K security setting
> issue. Moreover I am only denied access using the 2nd PC IIS but no
> problem when attempting to access it using VB or VBA.
>
> Can anyone please help?
Message #3 by "Iyappan P" <iyappan_p@h...> on Sat, 22 Sep 2001 14:32:37
|
|
I think it is because of NTFS security permissions. When using ASP with
anonymous access, the user is IUSR_MachineName. So u have to create the
user IUSR_Webservername on the other machine where the database(mdb file)
resides. And also make sure that u have given the write permission to this
user.
Regards,
Iyappan
>From: "Dennis Lai" <wise@a...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Microsoft JET Database Engine error '80004005'
>Date: Sat, 22 Sep 2001 04:10:17
>
>Can anyone suggest a solution to this error:
>
>Microsoft JET Database Engine error '80004005'
>
>The Microsoft Jet database engine cannot open the
>file '\\2ndpc\data\123X.mdb'. It is already opened exclusively by another
>user, or you need permission to view its data.
>
>/mindy.asp, line 3
>
>
>I have 2 pcs both using Win2k Server(NTFS)
>
>
>1ST PC
>There is a file called 123X.mdb. The folder in which the file resides is
>shared. Security settings for both the folder and file has been set to
>include everyone (last resort in a bid to get it to work!).
>
>2ND PC
>I am attempting to access 123X.mdb from this pc. I have no problems when I
>attempt to access it's data using VB or EXCEL via VBA. However, If I
>attempt to access this file using ASP via 2nd PC IIS, I always encounter
>the above error message.
>
>
>I am certain that there is nothing wrong in the type of connection or the
>connection string as I have tested them out in VB and VBA and it works
>perfectly fine. I have tried all kinds of connection method:
>
>1) ADO (OLEDB)
>2) ODBC (DSN)
>3) ODBC (DSN-less)
>
>Just to confirm that there is that the connection method/string is not the
>cause of the above error message, I deliberate change the string and IIS
>displayed a different error message.
>
>
>
>As for the path, I have tried the following:
>
>1) Mapping the shared folder as a Drive in the 2nd PC and specifying it
>like I:\data\123x.mdb.
>2) Including the pc name/ip in the path like \\2ndpc\data\123x.mdb or
>\\10.7.1.246\data\123x.mdb
>
>There is also nothing wrong with the path as both methods work in VB and
>VBA. When I deliberately change the path, IIS displayed a different error
>message. So I am certain the path is not the cause of the above messge
>
>From the error message, I am quite sure it is a Win2K security setting
>issue. Moreover I am only denied access using the 2nd PC IIS but no
>problem when attempting to access it using VB or VBA.
>
>Can anyone please help?
Message #4 by "Tomm Matthis" <matthis@b...> on Sat, 22 Sep 2001 12:28:41 -0400
|
|
Make sure the IUSR_xxx account has create/delete access on the folder where
the .MDB resides.... that account has to be able to create/delete the lock
(.LDB) file.
-- Tomm
> -----Original Message-----
> From: Dennis Lai [mailto:wise@a...]
> Sent: Saturday, September 22, 2001 4:10 AM
> To: ASP Databases
> Subject: [asp_databases] Microsoft JET Database Engine error '80004005'
>
>
> Can anyone suggest a solution to this error:
>
> Microsoft JET Database Engine error '80004005'
>
> The Microsoft Jet database engine cannot open the
> file '\\2ndpc\data\123X.mdb'. It is already opened exclusively by another
> user, or you need permission to view its data.
>
> /mindy.asp, line 3
>
>
> I have 2 pcs both using Win2k Server(NTFS)
>
>
> 1ST PC
> There is a file called 123X.mdb. The folder in which the file resides is
> shared. Security settings for both the folder and file has been set to
> include everyone (last resort in a bid to get it to work!).
>
> 2ND PC
> I am attempting to access 123X.mdb from this pc. I have no
> problems when I
> attempt to access it's data using VB or EXCEL via VBA. However, If I
> attempt to access this file using ASP via 2nd PC IIS, I always encounter
> the above error message.
>
>
> I am certain that there is nothing wrong in the type of connection or the
> connection string as I have tested them out in VB and VBA and it works
> perfectly fine. I have tried all kinds of connection method:
>
> 1) ADO (OLEDB)
> 2) ODBC (DSN)
> 3) ODBC (DSN-less)
>
> Just to confirm that there is that the connection method/string
> is not the
> cause of the above error message, I deliberate change the string and IIS
> displayed a different error message.
>
>
>
> As for the path, I have tried the following:
>
> 1) Mapping the shared folder as a Drive in the 2nd PC and specifying it
> like I:\data\123x.mdb.
> 2) Including the pc name/ip in the path like \\2ndpc\data\123x.mdb or
> \\10.7.1.246\data\123x.mdb
>
> There is also nothing wrong with the path as both methods work in VB and
> VBA. When I deliberately change the path, IIS displayed a different error
> message. So I am certain the path is not the cause of the above messge
>
> From the error message, I am quite sure it is a Win2K security setting
> issue. Moreover I am only denied access using the 2nd PC IIS but no
> problem when attempting to access it using VB or VBA.
>
> Can anyone please help?
|
|
|
View Cart
