|
 |
access_asp thread: VS: Re: Another Read-Only Connection Problem
Message #1 by "Teemu Keiski" <wroxhelp@m...> on Tue, 4 Jun 2002 22:39:39 +0300
|
|
I don't know if Ken agrees =3D), but Modify (Win 2000,Win XP) or Change
(WinNT) for IUSR_machinename should be enough. It's not good either but
it's less than Everyone/Full control.
It's because Access mdb file is physical file and when you are updating
db and so on, you are updating (changing in other words) the database
file so NT permissions should follow that.
Teemu Keiski
-----Alkuper=E4inen viesti-----
L=E4hett=E4j=E4: Karri Peterson [mailto:KPeterson@C...]
L=E4hetetty: 4. kes=E4kuuta 2002 22:22
Vastaanottaja: Access ASP
Aihe: [access_asp] Re: Another Read-Only Connection Problem
NTFS permissions are the permissions the operating system puts on the
file itself. Go to the directory your .mdb file is in, right click on
it and look at properties--security. Set it to a lower security
setting--such as everyone/full control.
Ken,
Is there a better option than everyone/full control with these access
file? I hate that--that's like an invitation to hackers.
Karri
-----Original Message-----
From: mwhitmill@e... [mailto:mwhitmill@e...]
Sent: Tuesday, June 04, 2002 3:27 PM
To: Access ASP
Subject: [access_asp] Re: Another Read-Only Connection Problem
>
a) Check your NTFS permissions
b) Do you have <% Option Explicit %> at the top of your page?
Cheers
Ken
####################################################################
a) I can't find my NTFS permissions. I understand permissions, but
don't
know how to find them and/or set them.
b) Yes, I do have <% Option Explicit %> in my program.
Looking forward to your response.
--Thanks, Mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <mwhitmill@e...>
Subject: [access_asp] Another Read-Only Connection Problem
: I'm running Windows-XP Pro using IIS.
:
: My error message is:
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
: [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
: object is read-only.
: /reunion/EAI_Name_Update.asp, line 545
:
: Line 545 is: objRSEntry.update
:
: Here's the connection open:
: set objConn =3D Server.CreateObject("ADODB.connection")
: objConn.open "DSN=3DInvite2ReunionDB"
:
: Here's the record set open:
: objRSEntry.Open sqlRS, objConn, adOpenDynamic,
adLockOptimistic
:
: I checked objConn.Properties("Read-Only Data Source") and it is TRUE.
: The book said I should be able to change properties but my program
blew
: up when I tried to set this value to FALSE.
:
: The properties associated with my actual Access file shows it not to
be
: READ-ONLY.
:
: I checked ODBC properties on my DSN and "Read Only" is NOT checked.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #2 by Karri Peterson <KPeterson@C...> on Tue, 4 Jun 2002 15:02:59 -0500
|
|
Thanks Teemu.
-----Original Message-----
From: Teemu Keiski [mailto:wroxhelp@m...]
Sent: Tuesday, June 04, 2002 2:40 PM
To: Access ASP
Subject: [access_asp] VS: Re: Another Read-Only Connection Problem
I don't know if Ken agrees =3D), but Modify (Win 2000,Win XP) or Change
(WinNT) for IUSR_machinename should be enough. It's not good either but
it's less than Everyone/Full control.
It's because Access mdb file is physical file and when you are updating
db and so on, you are updating (changing in other words) the database
file so NT permissions should follow that.
Teemu Keiski
-----Alkuper=E4inen viesti-----
L=E4hett=E4j=E4: Karri Peterson [mailto:KPeterson@C...]
L=E4hetetty: 4. kes=E4kuuta 2002 22:22
Vastaanottaja: Access ASP
Aihe: [access_asp] Re: Another Read-Only Connection Problem
NTFS permissions are the permissions the operating system puts on the
file itself. Go to the directory your .mdb file is in, right click on
it and look at properties--security. Set it to a lower security
setting--such as everyone/full control.
Ken,
Is there a better option than everyone/full control with these access
file? I hate that--that's like an invitation to hackers.
Karri
-----Original Message-----
From: mwhitmill@e... [mailto:mwhitmill@e...]
Sent: Tuesday, June 04, 2002 3:27 PM
To: Access ASP
Subject: [access_asp] Re: Another Read-Only Connection Problem
>
a) Check your NTFS permissions
b) Do you have <% Option Explicit %> at the top of your page?
Cheers
Ken
####################################################################
a) I can't find my NTFS permissions. I understand permissions, but
don't
know how to find them and/or set them.
b) Yes, I do have <% Option Explicit %> in my program.
Looking forward to your response.
--Thanks, Mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <mwhitmill@e...>
Subject: [access_asp] Another Read-Only Connection Problem
: I'm running Windows-XP Pro using IIS.
:
: My error message is:
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
: [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
: object is read-only.
: /reunion/EAI_Name_Update.asp, line 545
:
: Line 545 is: objRSEntry.update
:
: Here's the connection open:
: set objConn =3D Server.CreateObject("ADODB.connection")
: objConn.open "DSN=3DInvite2ReunionDB"
:
: Here's the record set open:
: objRSEntry.Open sqlRS, objConn, adOpenDynamic,
adLockOptimistic
:
: I checked objConn.Properties("Read-Only Data Source") and it is TRUE.
: The book said I should be able to change properties but my program
blew
: up when I tried to set this value to FALSE.
:
: The properties associated with my actual Access file shows it not to
be
: READ-ONLY.
:
: I checked ODBC properties on my DSN and "Read Only" is NOT checked.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
