|
 |
asp_database_setup thread: Error connecting to Access DB
Message #1 by "Nick" <nikosdra@l...> on Sun, 18 Mar 2001 11:20:21
|
|
I'm having some difficulty in establishing a DB connection in an Access
DB. Trying to see my default.asp page of my machine, I receive the
following error message:
<!--Begin Error Message-->
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the
file 'C:\datastores\marketsec.mdb'. It is already opened exclusively by
another user, or you need permission to view its data.
/confile.asp, line 6
<!--End Error Message-->
The same asp pages and the same database work fine on a different machine
so i suppose i have to check my settings.
The DB is not in use by anyone else (nothing else works and no .ldb lock
file appears) and the folders all have the proper
permissions set. If someone could provide me with a checklist of potential
problems that I can go through, I would be most appreciative.
Thanks!
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 19 Mar 2001 21:35:24 +1100
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: I'm having some difficulty in establishing a DB connection in an Access
: DB. Trying to see my default.asp page of my machine, I receive the
: following error message:
:
: <!--Begin Error Message-->
: Error Type:
: Microsoft JET Database Engine (0x80004005)
: The Microsoft Jet database engine cannot open the
: file 'C:\datastores\marketsec.mdb'. It is already opened exclusively by
: another user, or you need permission to view its data.
: /confile.asp, line 6
: <!--End Error Message-->
:
: The same asp pages and the same database work fine on a different machine
: so i suppose i have to check my settings.
: The DB is not in use by anyone else (nothing else works and no .ldb lock
: file appears) and the folders all have the proper
: permissions set. If someone could provide me with a checklist of
potential
: problems that I can go through, I would be most appreciative.
: Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
What are the folder permissions for the folder that the .mdb file is in?
What are the file permissions for the actual file? (both of the above for
the IUSR_<machinename> account.
Are you running this website out-of-process?
What is your connection string?
Cheers
Ken
Message #3 by "Tim Meagher" <tmeagher@c...> on Tue, 20 Mar 2001 17:43:50
|
|
I am having the same problem, and yes, I have given the CHANGE permission
to IUSR_machine_name for the directory and file. My server has gone
through security hardening, so I'm wondering if there are any registry
settings that are limiting access to this resouce.
- Tim
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> : I'm having some difficulty in establishing a DB connection in an Access
> : DB. Trying to see my default.asp page of my machine, I receive the
> : following error message:
> :
> : <!--Begin Error Message-->
> : Error Type:
> : Microsoft JET Database Engine (0x80004005)
> : The Microsoft Jet database engine cannot open the
> : file 'C:\datastores\marketsec.mdb'. It is already opened exclusively by
> : another user, or you need permission to view its data.
> : /confile.asp, line 6
> : <!--End Error Message-->
> :
> : The same asp pages and the same database work fine on a different
machine
> : so i suppose i have to check my settings.
> : The DB is not in use by anyone else (nothing else works and no .ldb
lock
> : file appears) and the folders all have the proper
> : permissions set. If someone could provide me with a checklist of
> potential
> : problems that I can go through, I would be most appreciative.
> : Thanks!
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> What are the folder permissions for the folder that the .mdb file is in?
> What are the file permissions for the actual file? (both of the above for
> the IUSR_<machinename> account.
> Are you running this website out-of-process?
> What is your connection string?
>
> Cheers
> Ken
>
Message #4 by "Cole, R. Mr. DOIM" <8r8251@e...> on Tue, 20 Mar 2001 12:49:29 -0500
|
|
See http://support.microsoft.com/support/kb/articles/Q238/9/71.ASP
Rich Cole
Signal Corporation
-----Original Message-----
From: Tim Meagher [mailto:tmeagher@c...]
Sent: Tuesday, March 20, 2001 12:44 PM
To: ASP Database Setup
Subject: [asp_database_setup] Re: Error connecting to Access DB
I am having the same problem, and yes, I have given the CHANGE permission
to IUSR_machine_name for the directory and file. My server has gone
through security hardening, so I'm wondering if there are any registry
settings that are limiting access to this resouce.
- Tim
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> : I'm having some difficulty in establishing a DB connection in an Access
> : DB. Trying to see my default.asp page of my machine, I receive the
> : following error message:
> :
> : <!--Begin Error Message-->
> : Error Type:
> : Microsoft JET Database Engine (0x80004005)
> : The Microsoft Jet database engine cannot open the
> : file 'C:\datastores\marketsec.mdb'. It is already opened exclusively by
> : another user, or you need permission to view its data.
> : /confile.asp, line 6
> : <!--End Error Message-->
> :
> : The same asp pages and the same database work fine on a different
machine
> : so i suppose i have to check my settings.
> : The DB is not in use by anyone else (nothing else works and no .ldb
lock
> : file appears) and the folders all have the proper
> : permissions set. If someone could provide me with a checklist of
> potential
> : problems that I can go through, I would be most appreciative.
> : Thanks!
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> What are the folder permissions for the folder that the .mdb file is in?
> What are the file permissions for the actual file? (both of the above for
> the IUSR_<machinename> account.
> Are you running this website out-of-process?
> What is your connection string?
>
> Cheers
> Ken
>
Message #5 by "Tim Meagher" <tmeagher@c...> on Tue, 20 Mar 2001 18:58:49
|
|
Thanks, but that didn't help. Funny thing is that if I give the
IUSR_machinename admin access, then I can access the database without any
problems.
- Tim
> See http://support.microsoft.com/support/kb/articles/Q238/9/71.ASP
>
> Rich Cole
> Signal Corporation
>
> -----Original Message-----
> From: Tim Meagher [mailto:tmeagher@c...]
> Sent: Tuesday, March 20, 2001 12:44 PM
> To: ASP Database Setup
> Subject: [asp_database_setup] Re: Error connecting to Access DB
>
>
> I am having the same problem, and yes, I have given the CHANGE
permission
> to IUSR_machine_name for the directory and file. My server has gone
> through security hardening, so I'm wondering if there are any registry
> settings that are limiting access to this resouce.
>
> - Tim
>
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > : I'm having some difficulty in establishing a DB connection in an
Access
> > : DB. Trying to see my default.asp page of my machine, I receive the
> > : following error message:
> > :
> > : <!--Begin Error Message-->
> > : Error Type:
> > : Microsoft JET Database Engine (0x80004005)
> > : The Microsoft Jet database engine cannot open the
> > : file 'C:\datastores\marketsec.mdb'. It is already opened exclusively
by
> > : another user, or you need permission to view its data.
> > : /confile.asp, line 6
> > : <!--End Error Message-->
> > :
> > : The same asp pages and the same database work fine on a different
> machine
> > : so i suppose i have to check my settings.
> > : The DB is not in use by anyone else (nothing else works and no .ldb
> lock
> > : file appears) and the folders all have the proper
> > : permissions set. If someone could provide me with a checklist of
> > potential
> > : problems that I can go through, I would be most appreciative.
> > : Thanks!
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >
> > What are the folder permissions for the folder that the .mdb file is
in?
> > What are the file permissions for the actual file? (both of the above
for
> > the IUSR_<machinename> account.
> > Are you running this website out-of-process?
> > What is your connection string?
> >
> > Cheers
> > Ken
> >
Message #6 by "Cole, R. Mr. DOIM" <8r8251@e...> on Tue, 20 Mar 2001 14:47:27 -0500
|
|
How about http://support.microsoft.com/support/kb/articles/Q253/5/80.ASP
Rich Cole
Signal Corporation
-----Original Message-----
From: Tim Meagher [mailto:tmeagher@c...]
Sent: Tuesday, March 20, 2001 1:59 PM
To: ASP Database Setup
Subject: [asp_database_setup] Re: Error connecting to Access DB
Thanks, but that didn't help. Funny thing is that if I give the
IUSR_machinename admin access, then I can access the database without any
problems.
- Tim
> See http://support.microsoft.com/support/kb/articles/Q238/9/71.ASP
>
> Rich Cole
> Signal Corporation
>
> -----Original Message-----
> From: Tim Meagher [mailto:tmeagher@c...]
> Sent: Tuesday, March 20, 2001 12:44 PM
> To: ASP Database Setup
> Subject: [asp_database_setup] Re: Error connecting to Access DB
>
>
> I am having the same problem, and yes, I have given the CHANGE
permission
> to IUSR_machine_name for the directory and file. My server has gone
> through security hardening, so I'm wondering if there are any registry
> settings that are limiting access to this resouce.
>
> - Tim
>
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > : I'm having some difficulty in establishing a DB connection in an
Access
> > : DB. Trying to see my default.asp page of my machine, I receive the
> > : following error message:
> > :
> > : <!--Begin Error Message-->
> > : Error Type:
> > : Microsoft JET Database Engine (0x80004005)
> > : The Microsoft Jet database engine cannot open the
> > : file 'C:\datastores\marketsec.mdb'. It is already opened exclusively
by
> > : another user, or you need permission to view its data.
> > : /confile.asp, line 6
> > : <!--End Error Message-->
> > :
> > : The same asp pages and the same database work fine on a different
> machine
> > : so i suppose i have to check my settings.
> > : The DB is not in use by anyone else (nothing else works and no .ldb
> lock
> > : file appears) and the folders all have the proper
> > : permissions set. If someone could provide me with a checklist of
> > potential
> > : problems that I can go through, I would be most appreciative.
> > : Thanks!
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >
> > What are the folder permissions for the folder that the .mdb file is
in?
> > What are the file permissions for the actual file? (both of the above
for
> > the IUSR_<machinename> account.
> > Are you running this website out-of-process?
> > What is your connection string?
> >
> > Cheers
> > Ken
> >
---
STAY UP TO DATE ON ASP.NET, C#, VB.NET, SQL and XML
Developersdex indexes over 100 of the top ASP, SQL, VB
and XML sites bringing in more than 5,000 new resources
every day. They even integrate all the top .NET
newsgroups so you can search/post/reply across
multiple newsgroups within their site. The next time
you want to find an answer on ASP, C#, SQL, VB or XML
think of Devdex! http://www.developersdex.com/
8r8251@e...
$subst('Email.Unsub')
Message #7 by "Meagher, Tim" <tmeagher@c...> on Tue, 27 Mar 2001 04:33:52 -0800
|
|
Hi Rich,
I found the problem. The lockfile for the Access database was not being set
up in the temp directory, even though I set the environment variable for it
and gave the IUSR_... account permission into the temp dir. With auditing
enabled, I found that the lockfile was being created in the winnt directory.
I'm not thrilled with the security aspects of giving the IUSR account any
perms to the winnt dir (although it looks like it only needs R/W).
I wish I knew why the Jet drivers don't set the lockfile in the temp
directory when the environment variable is configured per Q251254.
Regards,
Tim Meagher
-----Original Message-----
From: Cole, R. Mr. DOIM [mailto:8r8251@e...]
Sent: Tuesday, March 20, 2001 2:47 PM
To: ASP Database Setup
Subject: [asp_database_setup] Re: Error connecting to Access DB
How about http://support.microsoft.com/support/kb/articles/Q253/5/80.ASP
Rich Cole
Signal Corporation
-----Original Message-----
From: Tim Meagher [mailto:tmeagher@c...]
Sent: Tuesday, March 20, 2001 1:59 PM
To: ASP Database Setup
Subject: [asp_database_setup] Re: Error connecting to Access DB
Thanks, but that didn't help. Funny thing is that if I give the
IUSR_machinename admin access, then I can access the database without any
problems.
- Tim
> See http://support.microsoft.com/support/kb/articles/Q238/9/71.ASP
>
> Rich Cole
> Signal Corporation
>
> -----Original Message-----
> From: Tim Meagher [mailto:tmeagher@c...]
> Sent: Tuesday, March 20, 2001 12:44 PM
> To: ASP Database Setup
> Subject: [asp_database_setup] Re: Error connecting to Access DB
>
>
> I am having the same problem, and yes, I have given the CHANGE
permission
> to IUSR_machine_name for the directory and file. My server has gone
> through security hardening, so I'm wondering if there are any registry
> settings that are limiting access to this resouce.
>
> - Tim
>
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > : I'm having some difficulty in establishing a DB connection in an
Access
> > : DB. Trying to see my default.asp page of my machine, I receive the
> > : following error message:
> > :
> > : <!--Begin Error Message-->
> > : Error Type:
> > : Microsoft JET Database Engine (0x80004005)
> > : The Microsoft Jet database engine cannot open the
> > : file 'C:\datastores\marketsec.mdb'. It is already opened exclusively
by
> > : another user, or you need permission to view its data.
> > : /confile.asp, line 6
> > : <!--End Error Message-->
> > :
> > : The same asp pages and the same database work fine on a different
> machine
> > : so i suppose i have to check my settings.
> > : The DB is not in use by anyone else (nothing else works and no .ldb
> lock
> > : file appears) and the folders all have the proper
> > : permissions set. If someone could provide me with a checklist of
> > potential
> > : problems that I can go through, I would be most appreciative.
> > : Thanks!
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >
> > What are the folder permissions for the folder that the .mdb file is
in?
> > What are the file permissions for the actual file? (both of the above
for
> > the IUSR_<machinename> account.
> > Are you running this website out-of-process?
> > What is your connection string?
> >
> > Cheers
> > Ken
> >
Message #8 by "Ken Schaefer" <ken@a...> on Wed, 28 Mar 2001 11:00:26 +1000
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: I found the problem. The lockfile for the Access database was not being
set
: up in the temp directory, even though I set the environment variable for
it
: and gave the IUSR_... account permission into the temp dir. With auditing
: enabled, I found that the lockfile was being created in the winnt
directory.
: I'm not thrilled with the security aspects of giving the IUSR account any
: perms to the winnt dir (although it looks like it only needs R/W).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
That's odd - my lockfiles are normally created in the same directory as my
.mdb file...
Cheers
Ken
Message #9 by "Meagher, Tim" <tmeagher@c...> on Tue, 27 Mar 2001 19:21:39 -0800
|
|
Good point, its actually not the database lock file, its the temp files
created by the Jet.
- Tim
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Tuesday, March 27, 2001 8:00 PM
To: ASP Database Setup
Subject: [asp_database_setup] Re: Error connecting to Access DB
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: I found the problem. The lockfile for the Access database was not being
set
: up in the temp directory, even though I set the environment variable for
it
: and gave the IUSR_... account permission into the temp dir. With auditing
: enabled, I found that the lockfile was being created in the winnt
directory.
: I'm not thrilled with the security aspects of giving the IUSR account any
: perms to the winnt dir (although it looks like it only needs R/W).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
That's odd - my lockfiles are normally created in the same directory as my
.mdb file...
Cheers
Ken
|
|
|
View Cart
