p2p.wrox.com: Archives - asp

asp_databases thread: Permission Problem

Message #1 by jmss66@a... on Mon, 14 Jan 2002 18:56:23

I am now just beginning on the ASP Database Book and just finished with 

Beginnning ASP.

Here is my code from the book and below it is the Error Message I 

encountered when I ran it. It's saying permission problem but I checked 

the database property and I have all the rights to this database. I 

encountered this problem too when I was going through Beginning ASP and 

somebody suggested that I put the database on the root Directory of C: so 

I did and it worked. I applied the same solution to this unfortunately it 

still gave me this error. Please help me in finding the problem. I created 

the DSN how it showed in the book. 



Thanks in advance,

Judy



<%@Language=VBScript%>

<HTML>

<HEAD>

	<TITLE>Home Page</TITLE>

</HEAD>

<BODY>

<P>This line from HTML</P>

<HR>

<P>Next line from ASP will work<BR>

if ASP extensions installed correctly:<BR>

<%

	Response.Write "<B> From ASP</B>"

%>

<HR>

<P>Next line from ADO will work if DSN named sailors has been set<BR>

for example database which is named SAILORS.MDB.</P>

<%

	Set oRS=Server.CreateObject("ADODB.recordset")

	oRS.Open "SELECT * FROM People", "DSN=sailors"

	oRS.MoveFirst

	Response.Write "<B>" & oRS("PeopleNameLast") & "</B>"

%>

<HR>

Finished test page</P>

</BODY>

</HTML>



Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[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.

/ASPDatabase/testsailor.asp, line 19

Message #2 by "Steffen Wogensen Jaques" <webmaster@w...> on Tue, 15 Jan 2002 09:01:09 +0100

Hey,



That error occours when you or someone else are viewing the file (i.e. an

mdb file is opened in Access).

It might also be caused by you forgetting to close the database connection

(but I'm not sure about that though). So always remeber to close connections

after use.



Kind Regards,



SWJ.



----- Original Message -----

From: <jmss66@a...>

To: "ASP Databases" <asp_databases@p...>

Sent: Monday, January 14, 2002 6:56 PM

Subject: [asp_databases] Permission Problem





> I am now just beginning on the ASP Database Book and just finished with

> Beginnning ASP.

> Here is my code from the book and below it is the Error Message I

> encountered when I ran it. It's saying permission problem but I checked

> the database property and I have all the rights to this database. I

> encountered this problem too when I was going through Beginning ASP and

> somebody suggested that I put the database on the root Directory of C: so

> I did and it worked. I applied the same solution to this unfortunately it

> still gave me this error. Please help me in finding the problem. I created

> the DSN how it showed in the book.

>

> Thanks in advance,

> Judy

>

> <%@Language=VBScript%>

> <HTML>

> <HEAD>

> <TITLE>Home Page</TITLE>

> </HEAD>

> <BODY>

> <P>This line from HTML</P>

> <HR>

> <P>Next line from ASP will work<BR>

> if ASP extensions installed correctly:<BR>

> <%

> Response.Write "<B> From ASP</B>"

> %>

> <HR>

> <P>Next line from ADO will work if DSN named sailors has been set<BR>

> for example database which is named SAILORS.MDB.</P>

> <%

> Set oRS=Server.CreateObject("ADODB.recordset")

> oRS.Open "SELECT * FROM People", "DSN=sailors"

> oRS.MoveFirst

> Response.Write "<B>" & oRS("PeopleNameLast") & "</B>"

> %>

> <HR>

> Finished test page</P>

> </BODY>

> </HTML>

>

> Error Type:

> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

> [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.

> /ASPDatabase/testsailor.asp, line 19

>




$subst('Email.Unsub').

Message #3 by jmss66@a... on Tue, 15 Jan 2002 15:58:26

The first thing I checked when I got this error was if I have the file 

open. It was not open and I have read/write/execute permissions on this 

file too. As to closing the database, I can't even open it yet so closing 

is not an issue. The last time I had this problem someone told me to place 

the file in the root directory of C: and it worked, now I can't make it 

work inspite of moving it to c:. I appreciate you helping me with this 

problem. I am just getting started on this book and it is giving me 

problems right away. Can someone please help me.



Thanks,

Judy

> Hey,

> 

> That error occours when you or someone else are viewing the file (i.e. an

> mdb file is opened in Access).

> It might also be caused by you forgetting to close the database 

connection

> (but I'm not sure about that though). So always remeber to close 

connections

> after use.

> 

> Kind Regards,

> 

> SWJ.

> 

> ----- Original Message -----

> From: <jmss66@a...>

> To: "ASP Databases" <asp_databases@p...>

> Sent: Monday, January 14, 2002 6:56 PM

> Subject: [asp_databases] Permission Problem

> 

> 

> > I am now just beginning on the ASP Database Book and just finished with

> > Beginnning ASP.

> > Here is my code from the book and below it is the Error Message I

> > encountered when I ran it. It's saying permission problem but I checked

> > the database property and I have all the rights to this database. I

> > encountered this problem too when I was going through Beginning ASP and

> > somebody suggested that I put the database on the root Directory of C: 

so

> > I did and it worked. I applied the same solution to this unfortunately 

it

> > still gave me this error. Please help me in finding the problem. I 

created

> > the DSN how it showed in the book.

> >

> > Thanks in advance,

> > Judy

> >

> > <%@Language=VBScript%>

> > <HTML>

> > <HEAD>

> > <TITLE>Home Page</TITLE>

> > </HEAD>

> > <BODY>

> > <P>This line from HTML</P>

> > <HR>

> > <P>Next line from ASP will work<BR>

> > if ASP extensions installed correctly:<BR>

> > <%

> > Response.Write "<B> From ASP</B>"

> > %>

> > <HR>

> > <P>Next line from ADO will work if DSN named sailors has been set<BR>

> > for example database which is named SAILORS.MDB.</P>

> > <%

> > Set oRS=Server.CreateObject("ADODB.recordset")

> > oRS.Open "SELECT * FROM People", "DSN=sailors"

> > oRS.MoveFirst

> > Response.Write "<B>" & oRS("PeopleNameLast") & "</B>"

> > %>

> > <HR>

> > Finished test page</P>

> > </BODY>

> > </HTML>

> >

> > Error Type:

> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

> > [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.

> > /ASPDatabase/testsailor.asp, line 19

> >




> $subst('Email.Unsub').

> 

>

Message #4 by "Tomm Matthis" <matthis@b...> on Tue, 15 Jan 2002 11:30:32 -0500

The IUSR_xxx account needs to have read/write/delete access to the *folder*

where the .mdb resides in order to create/delete/update the lock (.LDB) file.



-- Tomm



> -----Original Message-----

> From: jmss66@a... [mailto:jmss66@a...]

> Sent: Tuesday, January 15, 2002 3:58 PM

> To: ASP Databases

> Subject: [asp_databases] Re: Permission Problem

>

>

> The first thing I checked when I got this error was if I have the file

> open. It was not open and I have read/write/execute permissions on this

> file too. As to closing the database, I can't even open it yet so closing

> is not an issue. The last time I had this problem someone told me to place

> the file in the root directory of C: and it worked, now I can't make it

> work inspite of moving it to c:. I appreciate you helping me with this

> problem. I am just getting started on this book and it is giving me

> problems right away. Can someone please help me.

>

> Thanks,

> Judy

> > Hey,

> >

> > That error occours when you or someone else are viewing the file (i.e. an

> > mdb file is opened in Access).

> > It might also be caused by you forgetting to close the database

> connection

> > (but I'm not sure about that though). So always remeber to close

> connections

> > after use.

> >

> > Kind Regards,

> >

> > SWJ.

> >

> > ----- Original Message -----

> > From: <jmss66@a...>

> > To: "ASP Databases" <asp_databases@p...>

> > Sent: Monday, January 14, 2002 6:56 PM

> > Subject: [asp_databases] Permission Problem

> >

> >

> > > I am now just beginning on the ASP Database Book and just finished with

> > > Beginnning ASP.

> > > Here is my code from the book and below it is the Error Message I

> > > encountered when I ran it. It's saying permission problem but I checked

> > > the database property and I have all the rights to this database. I

> > > encountered this problem too when I was going through Beginning ASP and

> > > somebody suggested that I put the database on the root Directory of C:

> so

> > > I did and it worked. I applied the same solution to this unfortunately

> it

> > > still gave me this error. Please help me in finding the problem. I

> created

> > > the DSN how it showed in the book.

> > >

> > > Thanks in advance,

> > > Judy

> > >

> > > <%@Language=VBScript%>

> > > <HTML>

> > > <HEAD>

> > > <TITLE>Home Page</TITLE>

> > > </HEAD>

> > > <BODY>

> > > <P>This line from HTML</P>

> > > <HR>

> > > <P>Next line from ASP will work<BR>

> > > if ASP extensions installed correctly:<BR>

> > > <%

> > > Response.Write "<B> From ASP</B>"

> > > %>

> > > <HR>

> > > <P>Next line from ADO will work if DSN named sailors has been set<BR>

> > > for example database which is named SAILORS.MDB.</P>

> > > <%

> > > Set oRS=Server.CreateObject("ADODB.recordset")

> > > oRS.Open "SELECT * FROM People", "DSN=sailors"

> > > oRS.MoveFirst

> > > Response.Write "<B>" & oRS("PeopleNameLast") & "</B>"

> > > %>

> > > <HR>

> > > Finished test page</P>

> > > </BODY>

> > > </HTML>

> > >

> > > Error Type:

> > > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

> > > [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.

> > > /ASPDatabase/testsailor.asp, line 19

> > >




> > $subst('Email.Unsub').

> >

> >

>




> $subst('Email.Unsub').

Message #5 by Jmss66@a... on Tue, 15 Jan 2002 15:54:53 EST

So how do I set up the IUSR_xxx account to have read/write/delete access?

Message #6 by "Kim Iwan Hansen" <kimiwan@k...> on Wed, 16 Jan 2002 09:34:33 +0100

http://www.skybuilders.com/Documentation/InstallManual2000.html



-Kim





> -----Original Message-----

> From: Jmss66@a... [mailto:Jmss66@a...]

> Sent: 15. januar 2002 21:55

> To: ASP Databases

> Subject: [asp_databases] Re: Permission Problem

> 

> 

> So how do I set up the IUSR_xxx account to have read/write/delete access?

> 




> $subst('Email.Unsub').

>

Message #7 by Jmss66@a... on Wed, 16 Jan 2002 09:29:46 EST

Interesting and so helpful. Thanks.



In a message dated Wed, 16 Jan 2002  4:16:47 AM Eastern Standard Time, "Kim Iwan Hansen" <kimiwan@k...> writes:



> http://www.skybuilders.com/Documentation/InstallManual2000.html

> 

> -Kim

> 

> 

> > -----Original Message-----

> > From: Jmss66@a... [mailto:Jmss66@a...]

> > Sent: 15. januar 2002 21:55

> > To: ASP Databases

> > Subject: [asp_databases] Re: Permission Problem

> > 

> > 

> > So how do I set up the IUSR_xxx account to have read/write/delete access?

> > 




> > $subst('Email.Unsub').

> > 

>

Return to Index

P2P Archives